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

This article mainly explains "ADO.NET parameter example analysis", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "ADO.NET parameter example analysis" it!

Let's assume that the structure of the data is as follows (the database set is Oracle10g):

Create table S_Admin (UserName varchar (60) not null, Password varchar (60) not null, Remarkvarchar (50) null, Mail varchar (120) not null, AddDate datetime null default GETDATE (), LoginDatedatetime null default GETDATE (), LoginIP varchar (50) null, Activesmallint null default 1, LoginCount intnull default 1, Power intnull default 0, Departid intnull default 0, constraint PK_S_ADMIN primary key nonclustered (UserId)) go

It should be noted that in addition to Access, operations on other databases can be performed correctly without necessarily adding parameters in the order in which they appear in the SQL statement, but in Access, parameters must be added in the order in which columns are inserted, because "the OLE DB.NET Framework data provider uses a question mark (?). Instead of using named parameters (MSDN), so add parameters and assign values in the order of the columns.

At this point, I believe that you have a deeper understanding of the "ADO.NET parameter example analysis", might as well come to the actual operation of it! 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.