I have a SqlDataAdapter that is being populated with 21 rows of data (4 columns). The sproc that drives it returns in a couple seconds in SQL Mgmt Studio, but the .Fill() takes 5 minutes. ArrayLi...

Which would be quicker. 1) Looping a datareader and creating a custom rows and columns based populated datatable 2) Or creating a dataAdapter object and just (.Fill)ing a datatable. Does the per...

I'm sure there is an extremely simple reason that this one line isn't working, but it has evaded for the past week, so I'm hoping someone else will notice my fault. I have been working on this pro...

I want to fill a DataGridView control using DataAdapter. But I don't know how to do it since I'm using a stored procedure with parameter. Can someone cite an example please?

This code snippet is throwing an error: Update unable to find TableMapping['Table'] or DataTable 'Table'.) on adapter.Update(ds); line Why it is throwing this type of error? SqlConnection con...

I am trying to insert categories and subcategories from Excel into a database table. I have 1 Excel file which contains some data and from this Excel file I am creating dataset which contains lots...

I am pretty new with ado.net and currently working with inserting datatable records to my database tables. I have 1 Excel file which contains some data and from this Excel file I am creating a dat...

This is my table: Student:StudentId int PK autoincrement,Name varchar(20) When i am trying to update last added records then i am geting error: Error: Concurrency violation: the UpdateCommand af...

If I fill a DataTable with DataAdapter.Fill(DataTable); and then make changes to a row in the DataTable with something simple like this: DataTable.Rows[0]["Name"] = "New Name"; how can I easily sav...

Given the following code, I have a few questions about best practices: string connectionString = @"Server=(local)\sqlexpress; Database=master; Integrated Security=true;"; using (SqlConnection con...

What does the method adapter.notifyDataSetInvalidated() accomplish? There is no documentation on it. I am trying to reload a ListView and notifyDataSetChanged or notifyDataSetInvalidated don't see...

how to refresh datagridview after making changes on the database from another form, after closing child form i tried to refresh the datagridview with click event but it's not working, do i have to...

I am trying to use MySqlDatAdapter to update a MySql table. But, the table never updates!!! I did this before but with SQL server. Is there anything else that is specific to MySql that I am missing...

I've been reading through the MSDN resources and several forums and still don't understand what's the difference between those two dataAdapter.Fill() and dataAdapter.Update(), I tried to use both o...

I am using DataAdapter.FillSchema to retrieve tables' schema from MS SQL. Unfortunately this doesn't return the default value for the columns. Is there a way to retrieve this value as part of the s...

I try to use DataAdapter in C#.net. and still I do not understand something about DataAdapter. I read many article and blogs about DataAdapter and DataReader. I understood DataAdapter will open a...

Is there any difference between these two methods? Both return an opened SQLiteDatabase. Both can create a database if one doesn't exist. SQLiteOpenHelper also has getWriteableDatabase when read/wr...

I have read from many places that it is possible to fill a DataSet with multiple tables using a DataAdapter. It also does not say whether a single Update call can update all the tables in the DataS...

I get my data from SQL to Dataset with Fill. It's just one table with two columns (CategoryId (int) and CategoryName (varchar)). When I look at my dataset after fill method, CategoryId Columns see...

I have a .NET application that is merging two datatables with a lot of rows (10,000+). There is a good chance of having a large number of update/inserts to perform to the SQL table when using the D...

My project that I am working on is almost finished. I am loading a .MDB file, displaying the contents on a DataGrid and attempting to get those changes on the DataGrid and save them back into the ....

For example if I run the following query: select * from table1 select * from table2 And run it with a DB adapter (C#) I get a dataset with two tables. How can I define the names for the result t...