DaveVance's Q&A profile

• .NET Development how to keep connection live while using httpwebrequest?

  hi i am using httpwebrequest and httpwebresponse to send request and get response respectively. i want to keep connection live after sending one request in order to send another request using same channel. so plz help me. HTTPWEBREQUEST.KEEPALIVE = TRUE is not working. Hi I got stuck up with the same thing as what kavitha told .. but the scenario is somewhat different. As the connection is not per ...Show All

• SQL Server Looping through an excel spreadsheet

  Being new to SSIS I wish to loop through a series of excel spreadsheets and within each workbook loop through each sheet. I am aware of the For Each container but how can the each sheet in the workbook be referenced Steve Thanks Jamie, my problem is for each spreadsheet I loop through how do I reference each sheet / tab within the spreadsheets returned by the For EachLoop. Thanks Steve ...Show All

• SQL Server Can I use DSN for OLE DB connection?

  Hello all, I am relatively new to SQL and Database. Your help is greatly appreciated! Thanks in advance! Recently, I joined a company that uses MS SQL Server. Our team, which is located in Toronto, has been maintaining and updating a database. The following is some information on the connection string that we are currently using. Dim con As ADODB.Connection Set con = New ADODB.Connection con.Open "Provider=SQLOLEDB.1;Integ ...Show All

• Windows Forms pb building a button custom column in my datagrid

  I m using .net 1.1 for a Windows form application. In my datagrid, I bind couple columns to related fields in my database table. But I need to add another custom column that has a checkBox and a button beside it (in the same column). The checkBox is bound to a column in my database but I need to place the button beside it as well.. The purpose for this is: In the custom column, If the checkBox is checked, the user clicks the button beside it ...Show All

• SQL Server CONVERT() FUNCTION

  i want a datetime format as mm/dd/yyyy in dataset i am getting AcquisitionDate="2005-05-05T00:00:00+05:30" if i used convert(datetime,AcquisitionDate) function ,the sql is throwing error convertion failed to datetime as character string any other way to convert this guide me please SQL Server's datetime does not store timezone as part of the datetime format. To store this data, you can either strip off the time zone ...Show All

• Visual Studio Express Editions Cannot see my sql servers or databases in Express edition

  Hi In visual studio 2005 express edition: When I add a datasource (new connection) I do not see any of my Sql servers. It only asks me for a database name. Also I do not see A server explorer in the view menu. If I use my visual studio 2003, I am able to see all instances of SQL's Why is this happening Thanks Robert The express editions don't support connections to SQL server, just to a local SQL Express databas ...Show All

• Visual C# Opening Forms inside another form

  Hi, Is it possible to open a form inside another form Can it be opened in a panel My application should not open more then one form. Thanks, Rafael Sancho All the controls are private to the form. You can write your own properties to access them if thats what you want to do. i.e something like Public string TextBoxXValue { get{return txtBoxX.Text;} set{txtBoxX.Text=value;} } then F_child.TextBoxXValue=&qu ...Show All

• Windows Forms jscript.net

  Hi, ive started to use jscript .net in my grid. is there any downsides to this if i use it to "Evaulate" expressions , will it fill my memory with new assemblies i know if you compile say c# code to an in mem assembly , you cann ...Show All

• Visual Studio Extending with a new Platform / Device.

  How can I introduce a new device / platform into visual studio I'm talking about the integration you see with SmartPhones, XBOX, etc. Is it even public the interface to integrate stuff like that There's another example, altho a little bit different - F#. It has source code and all, except for the imteresting part - the integration. I think it's interesting because it's using another compiler - an exe file. I dont really understand why this part ...Show All

• .NET Development Search and copy strings from steam in txt file

  HI, i made program that download html page as .txt file and open .txt file as steam in C#. Now i need to search this .txt file which i could load with streamReader, find the words i need to and paste them to the new file or database.. But i dont know how to use indexOf /to search the file/ with stream Could you help me please IndexOf(....) will give you the starting index of the word you are search ...Show All

• Visual Studio Team System Process Templates

  The only process template I can access in the Beta 2 is the MSF Agile, am I missing something or is this all that is currenlty available in Beta 2 I was primarly interested in the XP process template, or I guess I can design my own if I need to. Cheers Tim Seaward I've made a first attempt at a XP Methodology Template which can be downloaded from http://workspaces.gotdotnet.com/bsdagile your feedback would be ap ...Show All

• Visual Basic data grid question

  I hav 2 questions. 1. How do I change the datagrid's Column headings the problem is when I load the gris it shows the tables's column names. e.g. If in database Table the column name is "EmployeeID", then I want to show it as "Purchased By" . How to do that 2. How do i export data from a datagrid to a Excel file Anyone help. Thnx in advance. Hi, I guess you should clean up all activeX objects before quitting ...Show All

• Visual C++ XML reader for native C++

  Hi! I'm looking for a small C++ XML SAX reader, similar to XmlTextReader in .NET. The most important thing is that the library is small can be statically linked. Can anybody recommend me anything Thanks in advance! Just look at www.codeproject.com and search for MSXML. You find enough samples there! Also search in the MSDN for MSXML and sample, also there is enough stuff. ...Show All

• Windows Forms Data change not being saved if control not exited before clicking Save button

  How do I get my form to update a record if I only edit data in one control (say a textbox), then click the Save button that I added to the BindingNavigator As I haven't tabbed out of the textbox, the validation event doesn't fire and so the BindingSource doesn’t pass on the changes I made. If I tab out of the control first and then click Save it works fine. My code is: Private Sub UspWorkOrderBindingNavigatorSaveItem_Click(ByVal se ...Show All

• Windows Forms Showing property values as dropdownlist

  Hi, is there a method to show a custom control property values as a dropdownlist (like ControlToValidate property) I know thet declaring an enum type property is a solution. Is there another Thanks Marco It doesnt need to be anywhere near this complicated. Try this instead: return new StandardValuesCollection((context.Instance as Control).Page.Controls); ...Show All