I think I have basic questions here, but maybe I'm on the right group.
Suppose I set the MinPoolSize of a connection to 10. Then I open and
close the connection for the first time in my application. When I
close the connection, will ado.net creates 10 connections in advance?

I have a fairly large dataset that has to be uploaded in to the SQL server
table. I use data adapters command update, and that seems to work pretty
well ( all records make in to the table and nothing gets left out). However,
this mechanism is pretty slow when it come to 80,000 ...

I'm using an ODBC driver for MySql and the ODBC classes
that come with .NET framework.
I don't know how to do the following tasks:
1. Determining if a table with a given name exists in the

How do you add a new row to the datagrid windows control one row at a time without overwriting the existing row
Thanks a lot
Obi

i have a status bar and a tabpage on my Windows Form. At runtime, form will not allow resize. how do i allow for resize of form? all options are unlocked..
thanks.

I am new to c# .net and also new to ado .net and databindings. In my
application i create a dataset from an xml file and then databind the
values to controls on my form. An interesting thing happens when i
update the values on the form and i am wondering if i am doing

I'm getting an error inserting data into Oracle: "ExecuteNonQuery requires
an open and available Connection. The connection's current state is Open,
Executing."
The "NonQuery" I'm trying to execute a simple INSERT statement (which

just want to know if there was a way to take the contents of an xml file and
stream it into a single column in an Access database.

I have to table on typed Dataset, one is master and tow is detail.
I add on DS designer a relation from master to detail.
Now when I fill the detail table, I get error (I get msg: constrain or
null). I try to avoid the

Hello,  I'm having a problem figuring out how to deal with some fairly
simple relations in my C# program.  My setup is as follows:
Table "A" has a one-to-many relationship with table "B", and table "C"
also has a one-to-many relationship with table "B".

Is there any possibility to access the detached rows in a datatable/dataset?
Thank you,
Peter

I posted this question here a while ago, but no one can answer it. don't
know if all the MVP are too busy answering some other questions.
anyway, I have this *bug* in my ado.net app, I have data fields from oracle
database in a winform binded to all kind of controls, but I am not

I have a table in sql server with the datatype "numeric". What would be the sqldbtype in the parameter object. I can't finf any numeric. Is there a SqlDbType.Numeric
Thanks

I have a DataSet with a DataTable and DataColumns that were created at
design time. If I call DataAdapter.Fill then DataSet.Clear then
DataAdapter.Fill again I get a constraint violation exception on the
second call to Fill.

My page includes a dataset with a dataadapter for the Contacts table, with
insert command that reads:
================================================================
   INSERT INTO Contact