Gaurav.Srivastava's Q&A profile

• SQL Server An error has occered while establishing a connection to the server.

  I downloaded the AdventureWorks sample from the msft website and installed the sql exp. with advanced services and the toolkit. but an error occured while i opened the solution file "AdventureWorks Sample Reports.sln" and tried to test the connection. It said that it was prossibly caused by the default settings denying remote connections. But the fact is that I have already enable the remote connection, both for TCP/IP and named pipes ...Show All

• SQL Server Shredding recordset object var in ForEach loop (problem)

  I have a package that starts by loading a recordset into an object variable. The recordset is then enumerated with a ForEach loop. The loop sets some string variables. Within the loop container I have a Script task that uses a MsgBox to show the results for testing purposes. The package uses checkpoint restart (if that matters ). The first time I run the package the 1st record is displayed in the MsgBox, then the 2nd, but then the loop is st ...Show All

• SQL Server Remove rtf code from text

  Hi guys, here I am again, Now with a different question. I succesfully converted the binary code to plain text. The text however was put into the database as RTF. Can anyone tell me how to remove the RTF code from the plain text. Thanx Gabs This will be not too simple ;) First of all read: http://www.c-sharpcorner.com/Code/2005/June/CustomAssemblyinRS.asp This is for RS2000, but works for RS2005 also. What ...Show All

• .NET Development Converting Column to String From Dataset?

  Hi everyone , this is my first post and I am new here, I have some questions which requires your help ASAP. I actually need to convert a certain column from some table in a dataset to String array or simply String so I can verify its value with another textbox value. Let me explain in use case better: 1. I enter an value in the textbox 2. Upon textChanged, system search for value in specific column in the dataset 3. If code exist, xxx 4. ...Show All

• Windows Forms DataGridViewComboBoxColumn binding to an Object

  I have a DataGridViewComboBoxColumn in a DataGridView that I'd like to bind to an object in the grid's datasource.  The combo's datasource is a collection those objects.  I've been unable to get this to work without having an ID field in t ...Show All

• Visual Studio Express Editions Event 'Sender' booleanessity (Okay maybe it's not a word)

  I find myself trying to do a conditional 'if' when the event sender can be one of several 'senders' and I only want to do something if it is NOT a particular 'sender'. I use: If sender Is PrintPreviewControl1 Then ' Guess I'll have to use an else to get a 'not' Else testing = True End If There seems not to be any "<>" or "not" or "not =" syntax for the 'if sender' situati ...Show All

• Smart Device Development time() / localtime() in VS 2005 Windows mobile 5.0 pocket PC projects

  VS 2005 compiles Windows mobile 5.0 pocket PC projects that use time()/localtime(), but the linker does not find their implementation. So which replacements exist under Windows CE that I can use Maybe you can try to use SYSTEMTIME structure instead of use localtime() function. Like this: SYSTEMTIME curTime; GetSystemTime(&curTime); Hope this can helpful. ...Show All

• Visual Basic Adding permanent filename data to a combo box during program execution

  I need to know how to permanently add file name data to the list in a combo box. I am developing an application in Visual Studios and want to save and retrive data to files...I am currently writing and reading data to file names using the Stream Reader and Stream Writer.  This data is being stored in the projects bin directory. Everything works fine during the session, but after leaving and then restarting the session, the filename data i ...Show All

• Visual C# c# asp.net static variables

  i'm a little confused with c# static variables. i understand what static variables are, however it seems their lifetime goes beyond the lifetime of the page call (in asp.net). eg. a static variable in some class public static int m_test; EXAMPLE SENARIO: 1. call the page and print the variable (value is 0) 2. call the page again and set the variable to 100 3. call the page again and print the variable (the value is now 100) I am a little concern ...Show All

• Visual C++ handling the global static object constructor thrown exception in VC++ Express Edition

  Hi, I am new to VC++ and would like to know how can I handle the exceptions thrown from a constructor of a global static object is to be handlwed in VC++. I tried creating another global static object which sets a handler function using set_terminate method but the control is not going there. Any guidance appretiated in handling the exceptions thrown by the constructors. Thanks and Regards, You run just into more troubles. ...Show All

• .NET Development Networked Application Scenario (any ideas would be great!)

  I've posted several questions about network streams but as I haven't had many replies I'm guessing I'm going about it in the completely wrong way! This time, I'll try to explain what I need to achieve and hopefully someone out there will be able to help me with a method. I'm building a networked application for use at my college (over a LAN). The server needs to be multi-client enabled, and hold information about each client individually ( ...Show All

• SQL Server How to Select Delimiter in 'Results to File'

  I want to use custom delimiters for different queries when I send the results to files. However, that choice seems to be missing from the menu in Management Studio: Tools>Options>Query Results>SQL Server. There is a Genereal tab, Results to Grid tab & Results to Text. What's up Tommy - In SQL Server Management Studio 2005, click on Query on the menu, Results To, then Results to File. ...Show All

• .NET Development CertMgr tool and PFX (PKCS #12) Certificates

  How can I import a PFX certificate into a System Store from a file. The following does not work: certmgr -add mycert.pfx -s my The error I recieve is: Failed to open the source store I think it has something to do with the encoding (-e) flag, but I can't find ANY documentation on this. You should be able to just run the file, just start mycert.pfx from the command line and a certificate import wizard ...Show All

• Visual Studio Tools for Office Where is my cursor?

  I have developed and outlook add-in that contains a custom task pane hosting a windows form user control inside it. The user control had a textbox and a button. The button has an event handler attached to it. When the end user enter some text in the textbox while compposing a new email and click the button, I want to insert the text from textbox into the body section of the email. The problem is that how can I identify where my cursor is current ...Show All

• .NET Development PLEASE SHOW ME THE STEPS TO RUN THIS CODE ON VISUAL STUDIO 2003?

  Hi All,            Just started learning XMLHTTP. I am trying to run the example code below on an ASP page on IIS server to retrieve a code behind the sourceforge.net recommended reading page. Will someone show me the steps involved in running this code using VISUAL STUDIO 2003 Thanks <html> <head> <title> XMLHTTP Example </title> </head> <bod ...Show All