dataadapter
Database concurrency issue in .NET application
If userA deleted OrderA while userB is modifying OrderA, then userB saves OrderA then there is no order in the database to be updated.My problem is there is no error!The SqlDataAd开发者_运维知识库apte[详细]
2022-12-30 13:55 分类:问答Saving and retrieving image in SQL database from C# problem
I used this code for inserting records in a person table in my DB System.IO.MemoryStream ms = new System.IO.MemoryStream();[详细]
2022-12-30 09:17 分类:问答What is the difference between a DataSource and DataAdapter?
What is the differe开发者_运维百科nce between a DataSource and DataAdapter? I\'m trying to decide if I should descend from IDataSource or IDataAdapter for code to be shared between Winforms and WebFor[详细]
2022-12-29 03:59 分类:问答C# SQL Data Adapter System.Data.StrongTypingException
I get my data from SQL to Dataset with Fill. It\'s just one table with two columns (CategoryId (int) an开发者_如何学Cd CategoryName (varchar)).[详细]
2022-12-28 02:20 分类:问答Updating Database From Dataset?
I wanna update my database from my dataset. mydataadapter = new MySqlDataAdapter(\"SELECT * FROM table0; SELECT * FROM table1; SELECT * FROM table2;\", con);[详细]
2022-12-27 19:08 分类:问答What do these .NET auto-generated table adapter commands do? e.g. UPDATE/INSERT followed by a SELECT
I\'m working with a legacy application which I\'m trying to change so that it can work with SQL CE, whilst it was originally written against SQL Server.[详细]
2022-12-26 17:02 分类:问答DataTable identity column not set after DataAdapter.Update/Refresh on table with "instead of"-trigger (SqlServer 2005)
Within our unit tests we use plain ADO.NET (DataTable, DataAdapter) for preparing the database resp. checking the results, while the tested components themselves run under NHibernate 2.1. .NET version[详细]
2022-12-25 18:45 分类:问答Problem with filling dataset
This is a small portion of my code file. Each time my debugger reaches the line \'NewDA.Fill(NewDS);\' at runtime it jumps to the catch. I\'m positive the daynumber variable gets a value that\'s prese[详细]
2022-12-19 05:34 分类:问答Is DataAdapter a reliable way to Insert data into an SQL Server Database
Yesterday My colleague told me that using data adapter to insert data into an sql server database is not reliable, because it does not guarantee that data are inserted properly. He also told me that i[详细]
2022-12-18 00:56 分类:问答How can I add multiple tables to dataset with Fill using IDataAdapter?
Refering to How can I read multiple tables into a dataset? My App has a db factory. Can i use \'da.Fill(ds)\' [with IDataAdapter implementation] for multiple tables开发者_运维问答? Or how can i add mo[详细]
2022-12-13 10:10 分类:问答