I'm porting a VB6 / ADO application to VB/ADO.net and I'm running into
some ADO.Net problems.
I have a system that allows users to write and test their own SQL
statements, and then save them to the SQL Server in a table called

I was just reading the book "ADO.NET in a Nutshell".
In the chapter on the Command-Object (p. 36) it reads:
"A parameterized command won't improve performance as compared to the
original dynamic SQL statement. Unlike a stored procedure, a

It's MS Access database. Some table has a fields with default values, for
example, =Date().
But when I adding a row in DataGrid - the default values not displayed. If I
not fill this fields and then update dataset - in database all records added

hi ..
i am displaying 20 records using dataset in a datagrid.after displaying 20
company names from a table  a user need to select multiple companies and
send a email to particular manager. i want to insert checkbox dynamically

Good Day all,
I'm working on VisualStudio.net and on SQL Server 8.0
I'm using a WindowsForm with a ListBox, some TextBox, some buttons, a DataSet, an sqlDataAdapter and an SqlCommand.
I fill my DataSet normally with this command at the startup of my application

Error message: Argument 'Prompt' cannot be converted to type 'String' when I try to update a dataset.
Try
           OleDbDataAdapter1.Update(ds, "PatientSummaryTBL")
       Catch e As Exception

Let's say I have a stand alone app that was conceived/created decades
ago and has been updated through the years.  It's a basic CRUD
application with the data stored in a positional flat file.  After
data is entered, calculations are performed and are displayed to the

I have a database with some null columns.  I am creating a Typed dataset for it and understand that I should be using annotations with a typed dataset.  If for a field all reasonable values are positive then we could use codegen:nullValue="-1" to return a default other than ...

Is it possible to write a DataTable to SQL Server.
I would like to create new DataTable with some columns and records. Now I would like to store this DataTable to SQL Server as a new Table.
Can someone let me know if this possible?.
Thanks

Hi all, currently my application generates a DataSet object from a query issued to the database.
Then it uses some of the values from that DataSet object to send off further queries and so on.
However, I'm starting to wonder if it might be more efficient to use the "FindRows" ...

I am not sure if I believe this myself, but here is what's happening.  I created a query which pulls information from a table, and a date field is one of those fields.  I user the following to change the date into a string:
to_char(last_update_dttm, 'MM/DD/YYYY HH24:MI:SS') as ...

when I use the update method of a DataAdapter all added rowstates get
change. How can I make the DataAdapter let the rowstate unchanged, like the
AcceptChangesDuringFill property when filling.
Thank you

Is there a way that a connection pool can be explicitly deleted? E.g., using
the connection string, call some method that will close all the connections
in the pool?
Is there anyway to achieve this?

I can't seem to get the id of the child controls of my composite control. I
can get the unique id but the id when I try to access it via the controls
collection comes back null. Do I need to add a form tag within the control
rather  than on aspx parent page. Any ideas? Regards, ...

Can anyone tell me how to create a linked table in an
Access database, using ADO.NET?
Thanks
Iain