Prashant Sahay's Q&A profile

• SQL Server looping through table tom exec an SP many times

  Hi, If i have an SP called mySP that accepts one parameter @param If I have a table of paramaters with only one column like this: Param1 Param2 .. ParamN How do I do if I want to execute the SP on all the table fields: some thing like this: Exec my SP 'Param1' Exec mySP 'Param2' ... Exec mySP 'ParamN' I want that automatically since the parameters are going to be in a table called myTblParams Notice that I don t want to pass all the parameters to the SP just once but only one value each time I execute the SP since mySP ccepts only one parameter. Thanks a lot for guidelines yeah guys u re so right (obviously:) ) . any way in my seached field in the table filelist i had the word: 'isvirtual ' with many spaces since the fiel ...Show All

• SQL Server xquery not working in sql server 2005?

  i ran the following query from my sql server 2005 standard installation: USE AdventureWorks ; GO SELECT T2 . Loc . query ( '.' ) FROM Production . ProductModel CROSS APPLY Instructions . nodes ( '/root/Location' ) as T2 ( Loc ) and i got the following error message: Msg 2260, Level 16, State 1, Line 3 XQuery [Production.ProductModel.Instructions.nodes()]: There is no element named 'root' all of the rows in the "Instuctions" column contain only xml which has a "root" node. can someone please tell me why this query isn't working thanks. "ManuInstructionsSchemaCollection" XML Schema includes namespace definition. As result you must use with namespace in you queries. S ...Show All

• Visual C# C# 3.0 in Windows Vista

  I have heard something about it. Do anybody know when is it coming and is it going to be in Windows Vista Thanks, Timo Hi; A RC of net 3.0 was released on the 8th. On the site you will also find the SDK for Vista. I haven't used the .Net3.0 for quite a while. I used the WCF last year when it was still called Indigo for a demo. There are usually new releases every 3 month. The last CTP waqs released in July 2006. http://www.netfx3.com/blogs/news_and_announcements/default.aspx Regards Shivam ...Show All

• .NET Development Will .NET Framework 3.5 be a Cumulative Installer (1.1 + 2.0 + 3.0 + 3.5) ?

  Ok, this may be a very stupid question, but I am getting a little fed up of installing every released version of the .NET Framework whilst Java 5 runtime just needs you to uninstall and / or reinstall the new update such as version 11 - very simple! Currently to migrate and / or work on differing client projects and their unique requirements for different systems, I need to install on Windows XP (without SP2): 1) .NET Framework 1.0 with SP1 2) .NET Framework 1.1 with SP1 3) .NET Framework 2.0 and now 4) .NET Framework 3.0 Will Microsoft make .NET Framework 3.5 Orcus a cumulative installer for all releases or at least subsume .NET 2.0 & .NET 3.0 & .NET 3.5 together Alternatively, a single custom insta ...Show All

• SQL Server Drillthrough with Return clause

  I am trying to perform a drillthrough with the return clause so that i can get the member keys. when the performing the drillthrough, i get the followin message: Errors from the SQL query module: The 'dim peiod' table either does not exist in the 'Dm GL' schema (or cube.), or the user does not have the necessary permissions to access it. I've dumbed down the query as much as possible i think - and it works fine without the return.... drillthrough maxrows 10 select {[measures].[amount]} on 0, {[dim acct].[account]} on 1 from [dm gl] return [dim peiod].[month] thanks much, sully Is the office problem related to the issue I blogged about here http://geeks ...Show All

• Visual Basic Desktop folder question

  Hello, I was using the "My" namespace to reference the Desktop folder, like this: My .Computer.FileSystem.SpecialDirectories.Desktop but it was not showing all the contents of the folder. Another person said that the "My" value returns the filesystem folder corresponding to the desktop and not the Windows shell desktop folder. Is there more than one Desktop What does this mean Thanks for any suggestions. sorry how do you mean its not showing the contents of the folder This should do the same thing if you are retrieving say files/folders of the desktop: Dim theFiles() as String = System.IO.Directory.GetFiles(Environment.GetFolderPath(Environment.SpecialFolder ...Show All

• Visual C# lil addition..

  a lil addition to what i posted.. Would it be more efficient to use "TestCategory" assigned to a constant.. But if the app.config file changes it will be a prob.. also if i use the above coding i wrote it will have a dependency with the app.config ( with the order of the categorySources) ...Show All

• Visual Studio VB.net 2005 provider connection error

  I made a vb.net project on a device and it worked fine woth no errors at all but when moving the project to another PC with same software installed(vb.net2005) i get the following error message: "there was a failure while initializing the microsoft visual source safe control provider. You cannot use this provider to perform source control operations" could any one please help me on this error > "there was a failure while initializing the microsoft visual source safe control provider. " This message means that VSS is installed on the machine (otherwise you'd get a different error message, saying that provider is not installed), but there is a problem loading or initializ ...Show All

• .NET Development Rs232-threads-problems

  Hi, I have a strange problem...I work an application which is multithreading.I interrupt,with my application, the communication of two devices which send each other hexadecimal messages to communicate with Rs232..so i can check in my program what kind of messages are that and i can also change some bytes and send them back changed..the problem is that when I run this in my pc(2GHz) is run ok..everything work..I have mentioned the GHz cause I do a lot of processes until I send back the changed bytes and that some times take long time and I lose the communication(i need real time coinnection)..In my old pc (1GHZ) it also works...But when I gave that to my firend to check in his pc (3,4)..it doesn;t work...Have you any idea aboput the reason. ...Show All

• SQL Server How can i import data/mdf file created in SQL 2005 into a database on SQL server 2000

  How can i import data/mdf file created in SQL 2005 into a database on SQL server 2000 ...Show All

• Visual Studio Team System Get specific version tells me file is being used by another process

  Sometimes when I select a folder and run the get specific version (I choose latest and check both boxes to force get), TFS will show a message box telling me that some file could not be processed because it was being used by another process. I am assuming this is because another user is either checking a file out or in or is also pulling the latest version. That is, TFS is the "other process". Why doesn't TFS simply retry pulling the file or files instead of waiting until I come back to the office to push the freaking button so the fetch will finish Then to get the file, of course I have to do a get again. Is this a bug or a feature Sometimes I see that the file in the message box has "Latest" marked as "y ...Show All

• Visual Basic How can I replace the newline character with something else from a textbox?

  In my database I have addresses in one line, comma separated. That way they can be as many lines as they want... I read from the database and put addresses in a textbox as you would like to read them - on individual lines. I use a simple string substitution: txtAddress.Text = Replace(cmbAddress.Text, ",", vbNewLine) I'm having problems saving it back to the database with commas if the user modifies it. I tried variations on: Replace(txtAddress.Text, vbNewLine, ",") with vbCrLf or chr(13) isntead of vbNewLine with no success so far... Anyone know how I can succesfully find my new line characters and replace them with commas Thanks, James It was a silly mistake on my part. I am converti ...Show All

• Visual Studio Team System Connect to TFS window get programmatically

  Hi All, I want to do programmatically invoke the window which will show me the "Connect to Team Foundation Server" where you can add the server, edit or delete and once you added the List of projects will be displayed...... Will this exposed in OM Please help me in this regard. Thanks in advance. Regards, Kathir Hi Dennis Thanks a lot. Dennis. I invoked the same window through OM..and it is saved my time of creating the new customized window forms...thanks once again.... Can you please tell me, how to set the Multiple selection mode for the projects, i did like this. DomainProjectPicker picker = new DomainProjectPicker ( DomainProjectPickerMode .AllowProjectSelect); / ...Show All

• Visual Basic Converting a C style struct to a VB. Net Structure

  I have a dll library that I wish to use in VB .Net there .h has many different structures which to pass to various functions in the dll. Many are strictly input to the dll but some are a mix of in and out. example typedef struct tagPT_DioGetCurrentDOByte { USHORT port; USHORT far *value; } PT_DioGetCurrentDOByte, FAR * LPT_DioGetCurrentDOByte; In VB 6 this was pretty simple as I could declare port as byval and *value as byref. What is the proper declaration in VB.Net Hello Mattias, You are right about VB 6 but regardless this throws an Object reference not set to an instance of object exception. Public Declare Function DRV_DioGetCurrentDOByte Lib "adsapi32.dll&quo ...Show All

• SQL Server Disappear the generic bar.

  Hallo all : How to disappear the generic bar in the report, or to disappear some options (example export). I speak about the bar which in the top of the report or there are the numbers of pages. Thank's. Right-click on the report once it has finished retrieving data and select properties. You can use the URL in the properties to point to a report that does not have the toolbar. (using /reportserver/ url instead of /reports) There are also rc: commands to turn off the toolbars. http://msdn2.microsoft.com/en-us/library/ms152835.aspx cheers, Andrew ...Show All