New to the .Net party here, so please forgive the basic nature of my
questions.  I have to query SQL Server and generate csv or Excel files when
all is said and done, from a VB .Net client app.
   I've been reading up on DataSources, DataSets, DataGrids and ado.net

Got a databound DataGrid,
add a record, update the undelaying database (single user/single session),
make a change on de newly created record
try to update: error "Concurrency Violation"

I want to delete a specific record in a dataset based on its primary key
which I can get from a the value of a dropdown menu. I tried using the
select method to filter the datatable on the primary key and as this table
should only contain 1 record I should be deleting the right ...

I'm building an XmlDataDocument list this:
XmlDataDocument xmlDocResults = new XmlDataDocument( dsResults );
XmlNodeList nodes1 = xmlDocResults.SelectNodes(
"//RPDCY_TDataSet/RPDCY_T" );

What are the most common errors that  come up when ADO.NET is used to connect to a database for eg SQL Server 2000 or Oracle?

Can anyone tell me how to convert a the time portion of Date into OleDB.DBTime? My time field in Access is of type DBTime and I keep getting casting errors. I know that the DBTime is a TimeSpan but I can't seem to get it. Does anyone have any ideas how I can successfully write ...

I have a windows form with a DataGrid, and I want to bind a dataset to it.  But I also have a combobox on my form,  When the user chooses a number in the combobox, I want the datagrid bound to a query with the value from the combobox.  Example, if the user chooses 2 in the ...

i have a table data of 3 millions. When i try to populate the dataset from sqlcommand object or dataadapter it gives my following error
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.   at System.Data.SqlClient ...

I am using sqlcommand object to execute a stored procedure. And i populate a dataset fro sqldataadapter. When i run it for the first time it works fine when try to go to the next page it gives the following error
Error Message :Timeout expired.  The timeout period elapsed prior to ...

I'm finding that even when pooling=false, a connection remains in my
connection pool connected to my database (it seems to quite quickly timeout
though - say 30 seconds).
My connection string:

In C# how can I lock a record (on SQL Server) while being processed by my
program so that I prevent other users from accessing it at the same time???
I'd highly appreciate your kind help,
Veszko

My application is using OleDB provider and I want to
control the connection pool. I know if I want the same
thing with SQL Server provider, all I need is doing
something like "...Pooling=true;Enlist=false;Max Pool

I have encountered a very strange problem
On a PC there is a VB.NET application that connects with an Access database on a Windows Server 2003
The connection to the server was very slow, because the DNS-address and the workgroup was different. So, now it should be faster than it ...

I've got a strongly typed DataSet where I want to: traverse the rows in a
table and do a check.  If the check is successful, I want to duplicate the
row, tweak a column, then add it to the same table in the DataSet.
What's the most efficient way to do this?

When running the program, I recieved the following error
"Exception Details: System.Data.SqlClient.SqlException: Login failed for
user 'sa'."
In web.config file, the connection setting is below: