Atul Palkhe's Q&A profile

• Visual Studio HELP ME PLEASE !! PARAMETERS

  I need to switch between the databases at runtime for my crystal reports in .NET 2.0. Is it possible to change the crystal reports connection string at run time in .NET 2.0 Please provide me any sample code which illustrates dynamically changing the connection string of crystal reports at rune time. Thanks in advance, Vaishu Try this code sample: Dim crtableLogoninfos As New TableLogOnInfos() Dim crtableLogoninfo As New TableLogOnInfo() Dim crConnectionInfo As New ConnectionInfo() Dim CrTables As Tables Dim CrTable As Table 'Declare ReportDocument object and load your existing report 'Make sure that you give the correct path for the document else it will give exception ...Show All

• Visual C# Using C++ pointer tricks in C#: type safety & unsafe blocks

  This may sound like an unusual question for C# users, but I am trying to migrate some tricky C++ code that utilized pointers in a very efficient manner to populate an array of four bytes with the four bytes of a long value, like so: unsigned char longData[4]; long * longPtr = &longData[0]; * longPtr = doSomeCalcWhichReturnsALongValue(someIntValue); The type safety enforced by C#/.NET doesn't seem to casting between a byte pointer and a long pointer, even when wrapped in an "unsafe" method: unsafe static public byte[] convertData ( int rawData ) { byte[] data = new byte[4]; fixed (float* floatPtr = &data[0]){} int scaledValue = 127 - rawData; // LookupTable contains a list of pre-calc'ed flo ...Show All

• SQL Server KeepTogether header does not work correctly.

  I selected "Repeat Group Header" in my grouping properties. This is working fine; however, if a group is to start as the last line in a page, the header prints on that last line and then the header is printed once more in the next page. Consequently I end up with two consecutive headers with no detail lines in between. How do I prevent the printing of two consecutive headers for the same group I want to get rid of the one that occurs as the last line on the page. Thanks for the reply. I appreciated you trying to help me. I found this problem in several reports and the problem repeats a few times in each report. I tried your suggestion, it was a good thought, but did not work. It shifted ...Show All

• Visual Studio 2008 (Pre-release) Only letters and numbers in a TextBox

  Hi all, I have a TextBox in which I want the user to enter only letters and numbers. How do I go about this Cheerio, Frances Hi, Check for Ascii Values , while user presses the keys, Allow only 97-122 for (a to z) 8 for Backspace 32 for SpaceBar 48 to 57 for Numbers 0 to 9 and 65 to 90 for (A to Z ) Thnx Sidheshwar N ...Show All

• Microsoft ISV Community Center Forums Does anyone know some good places to look for Architects

  My name is Chris Cox and I work for Intuit recruiting technical talent. I wanted to check in this forum to see if anyone knew of any good associations, user groups, blogs, or even good architects. Feel free to email me if you have any suggestions. Thanks, Chris Cox chris_cox@intuit.com ...Show All

• Visual Studio 2008 (Pre-release) Webservice sync limitations

  Hi Everyone, I've created a vb.net app based on the n-tier design where my webservice is located on a Windows 2003 server running IIS6. My SQL Server database is on another server running Windows 200 Server and my client is Windows XP. I'm sync'ing about 20 tables with 1 of them containing approximately 200,000-300,000 records. My problem is everything works perfect except on that one large table unless I delete out some of the records. This particular table is setup as "SyncDirection.DownloadOnly" as it has monthly sales figures. When I attempt to sync that table and not limit the records my client app gives me a timeout error. If I increase the timeout within the web service proxy on the client, I then get an error on the c ...Show All

• .NET Development DataType Yes/No

  Using Access as a database On the Insert Command how do I do a field that has a data type of Yes/No. is it sql +="0,"; or sql+="'0'"; or what Thanks in advance. that would be a Bit value (1/0, yes/no, true/false) so itll just be 0 (for false) or 1 (for true): sql += "0"; Also looks like you are using standard SQL "injection" - I would recommend using Stored Procedures as they are fast and secure and you don't need to worry about building the query string/SQL String/statement as it would be stored in the SPROC itself on the SQL Server. All you would have to do is supply the correct parameters with values in your Client app and call the stored proc ...Show All

• Software Development for Windows Vista Is it possible to call a public method of a Workflow WebService from a Class

  Hi I am trying to call a webservice from workflow asynchronously. The response of the WebService will be in a class. I want to call the workflow webservice from that class and place the response in a public method. I have added a webreference of the workflow webservice in that class, created an instance for that and trying to access the public method in that. But I am not able to access public method in workflow webservice. Is there any way that I can call workflow webservice and access the public method in it. or is there any way that I can put my response(which is in a class) of the webservice (which is invoked asynchronously from a workflow) after some activities are executed. Please help me anybody. Thanks in advance. ...Show All

• Visual FoxPro Help with expression (one more time...)?

  Hello All...many thanks to all who helped with my previous post. I have hit one more 'snag' in preparing my data. Here's a sample of three fields in my table... MRC REQUIRED DETAILS 4720-00-001-0057 ADLF HOSE OR TUBING SPEC/STD DATA MIL MIL-H-5593,SIZE 4 SPECIFICATION ADJM INNER CONVEYING TUBE MATERIAL RUBBER, SYNTHETIC MEDA MEDIA FOR WHICH DESIGNED AIR CRWL INSIDE SURFACE CONDITION SMOOTH CQCS LAYER COMPOSITION AND LOCATION 1ST LAYER ANY ACCEPTABLE CQCS OUTER LAYER MOLDED RUBBER CRJM OUTER COVERING ENVIRONMENTAL ABRASION RESISTANT AND PROTECTION CRJM ...Show All

• Windows Forms Windows Form in Native Window

  Hi, I would like to display my windows form as a child of native window which is identified by it's HWND. The HWND is created by CreateWindowEx in another part of the application. In fact, I would like to replace the window with the form. Is it possible Thanks for your help, zde Only if you have the source code for that program and can recompile it with a modern compiler. Even then, you'd need to either support ActiveX controls or use MFC. ...Show All

• Smart Device Development Help Modifying the Entry Point Property

  I'm modifying my projects Linker properties in an attempt to write a driver. Under Linker and in System, the Subsystem and Driver properties have a drop-down menu that allows one to set these to: Native (/SUBSYSTEM:NATIVE) and WDM (/DRIVER:WDM) However, in Advanced the Entry Point property gives a text box which requires me to type in the entry point function name (DriverEntry). How is this done Do I just type the function name, "DriverEntry", or do I type in "/ENTRY:DriverEntry", or is the syntax similar to the two above and I need to type in "DriverEntry (/ENTRY:DriverEntry)" ...Show All

• SQL Server Multiple values contained in query string to be used as parameter in Report. HELP!

  Hi, I'm a bit desperate here so any solutions would be much appreciated. I'm using SQL reporting services 2005 & .NET2.0 & Oracle DB. I need to pass multiple values in the query string, or any other suggested way, to my report to be used as a parameter. The idea is a user on the web app will do a search & select an item to open a new form. The user can print the report from here, by pressing a button and being redirected to the report's URL. In this form there will be many (could be alot) of IDs that I will need to pass to the report and the report will use these as a parameter. The problem is that I am passing it at the moment as a comma deliminated string so instead of the SQL doing this : "ID in ('1', '2')", it's d ...Show All

• SQL Server MDX multidimensional sum

  Hi i m a new at mdx i have a big problem with the sum simple cube: SET [Agreed Action List] as { {( [Agreed Action].[Description En]. children -- IF I Decomment the following line adding another level to the row hierarchy ... boom --,{ [Trafficked Person].[Sex En].&[male],[Trafficked Person].[Sex En].&[female]} )} } MEMBER [Agreed Action].[Description En].[sum] as 'Sum([Agreed Action List],[Measures].[TP Count])' SELECT NON EMPTY { [Agreed Action List], [Agreed Action].[Description En].[sum] } ON ROWS , NON EMPTY { [Case Opened Date].[year].&[2001], [Case Opened Date].[year].&[2002] } * { [Measures].[TP Count]} T ...Show All

• Visual Basic winsock help

  I have a program that was created in VB6 which uses a winsock.getdata control to output a string in a textbox, the actual code looks like this Private Sub Winsock1_DataArrival(ByVal bytesTotal As Long) Dim strData As String Winsock1.GetData strData, vbString DvtString.Text = strData End Sub When I try and implement this in Visual basic 2005 express edition I don't appear to receive the string. I've had a look around and I've seen something about running the winsock control in legacy mode (not sure how to do this) and something saying winsock isn't included in VB2005. Can anyone shed any light on this for me please. The code below is how I've written it in VB2005EE Private Sub Winsock1_DataArrival(ByVal bytesTotal As Lo ...Show All

• Windows Forms Selecting text in textboxes

  Hey, I want to have the text selected when tab between them. I've tried the following but it doesn't work due to late binding. Private Sub OnEnterHandler( ByVal sender As Object , ByVal e As EventArgs) Handles textbox1.enter, textbox2.enter, textbox3.enter, textbox4.enter myTextbox = sender myTextbox.SelectAll() End Sub I know I've done this earlier but I can't figure out how I did. Please, can someone help me. I found out the trick... Dim myTextbox As TextBox = CType (sender, TextBox) myTextbox.SelectAll() ...Show All