Hi, I have an application where a group of tables are updated.. one of the table (product) holds the latest product number .. to find the latest prod # i just use a sqlreader then when i find the latest # i add one to it. i then insert it via a dataadapter/dataset. i then go to execute the sq...more >>

Hi, My friend had a little confusion about the working of DataReader after reading an article from MSDN. Following is a message from him... <!-- Message starts --> I was going thru DataReader in ADO.NET in MSDN and there is a confusion regarding the buffering of data in case of DATAREADER....more >>

Hi=20 How to Create the WebService and How to test the it ? I paste the Code here, In that Code, What is Role of NameSapce? The NameSapce ref the = http://tempuri.org/, Why? How to Call the Method HelloWorld ? Imports System.Web.Services <WebService(Namespace :=3D "http://tempur...more >>

Hi NG members Has anyone out here tried to carry out some Stress test on dataadapter.fill() Guys try this Simple query with 1 or 2 join Tables not having more than 1K records Use da.Fill(ds Bind a table to some grid. No fancy stuff --- You will notice problems here as tables object itself is...more >>

Hi, A quick one: If you are forming a dynamic sql statement using parameters from a web form, you would normally double up any single inverted commas inputted by the user to stop sql injection. But if you are using command parameters to build the sql statement (as below), is this still nec...more >>

Which of the following codes is recommended? Is there any difference between them? If TypeOf dr("colname") Is DBNull Then ' Do work End If If IsDBNull(dr("colname")) Then ' Do work EndIf ...more >>

I've filled a DataSet,ds, with a table, State. The schema is similar to the following: State ============ ID CountryID StateAbrev StateName I've loaded the State table into the dataset, ds. The StateAbrev has all the state abreviations. How can I get the record number of a stat...more >>

Hi, I have an expression column (integer). This column gets populated correctly. I then have a Select, that is: dt.Select("Calc = " & dt.Compute("Min(Calc)", "") & "") Now, as you see, first I am computing the minimum value of the column, and then using that in the select. Now, this ...more >>

Hi All I want to synchronize a database table on SQL Server with MSDE on a client laptop. I have a web service on the server which returns the SQL table as XML. I save the XML to disk on the client and then load it into a dataset. I then want to replace the entire contents of a table on the loc...more >>

I have a Data Grid Binded. I want to implement search on Multiple column in the Grid. i.e. if the a required crieteria is found on the multiple columns of the grid, I move the pointer to that row in the grid and retrieve that selected datarow from the datatable. I would appreciate any web-resour...more >>

I would like to see the data in my datarow. what i am trying is for each datacolm in datatable.columns debug.writeline (drow.tostirng & " = " & HOW DO I GET THE VALUE of the row?? Next i created a watch and see that the info is in my itemArray list but there is no item.count for datar...more >>

I'm trying to understand ado.net transactions and am a bit lost. What I don't understand is, when I begin a transaction on a connection and obtain a transaction object, why I must then pass this transaction object to command objects that use the connection. I mean, doesn't the transaction belong ...more >>

Hi there, I am trying to get the value of an SQL bit field, to link it to an groupbox with 2 radiobuttons. but for some reason..the value of the bit field is NEVER 1/true code: if sqlfield=true radioYES.checked=true else radioNO.checked=true I've tried this if (data.tabe...more >>

I have a typed dataset that has 2 tables that are related using a DataRelation. I am displaying the data in 2 separate grids. I want to be able to select a record in the parent grid and only display the related child records in the child grid. I have read several posts that discuss binding to a ...more >>

I did this before in VB 6.0/5.0. But how do you programmatcally write code using VB.NET and ADO.NET to import Excel/Text files into a database? Eg., the Excel file/Text file has columns of Account Number and Amount and need to be imported to a Table with fields Account Number and Amount. I think I ...more >>

Hallo I have a very large dataset that I am inserting into an access database using INSERT Commands. The problem is that individually inserting row by row is too slow. What is the fastest way to insert a very large dataset (or flat file) into an access database via VB.NET? Thanks... Nigel.....more >>

Hi I am getting the 'Operation must use an updateable query' error when i am trying to insert some data into the access db! I have checked for the permissions, all the permissions are ok, at the same time i also changed the settings in machinge.config file from 'machine' to 'SYSTEM'. Any other ide...more >>