Shulou(Shulou.com)06/02 Report--

This article focuses on "what are the ADO.NET programming skills", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn what ADO.NET programming skills are.

May I ask a question first? My software environment is: windows xp,office xp,visual studio.net Enterprise structure Edition, sql server 2000 Development Edition.

I would like to ask what is the meaning of the "use Open concurrency" and "Refresh dataset" options in the "Advanced Properties" page of "generate sql statements" in the data Adapter configuration Wizard, and does it affect the update operations (modify, delete, add) of the corresponding database tables?

And I set up an asp.net web application, use the oADO.NET programming configuration wizard to establish a connection with the access database, and generate a typed dataSet, place datagrid on the page, and fill the dataset in Page_Load with oleDbDataAdapter's fill method, and bind the dataset with datagrid's databind method. All ready, a run program appears "Microsoft Jet database engine can not open the file'E:\ FPNWIND.MDB'. It has been opened exclusively by another user, or does not have permission to view data, where the stack trace information is:

[OleDbException (0x80004005): the Microsoft Jet database engine cannot open the file'E:\ FPNWIND.MDB'. It has been opened exclusively by another user, or does not have permission to view data.] System.Data.OleDb.OleDbConnection.ProcessResults (Int32 hr) System.Data.OleDb.OleDbConnection.InitializeProvider () System.Data.OleDb.OleDbConnection.Open () System.Data.Common.DbDataAdapter.QuietOpen (IDbConnection connection, ConnectionState& originalState) System.Data.Common.DbDataAdapter.Fill (Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill (DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill (DataSet dataSet) WebApplication2.WebForm1.Page_Load (Object sender, EventArgs e) System.Web.UI.Control.OnLoad (EventArgs e) System.Web.UI.Control.LoadRecursive () System.Web.UI.Page.ProcessRequestMain () "so far" I believe that you have a deeper understanding of what ADO.NET programming skills are, so you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.