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

This article mainly introduces "ADO. NET state is what", in daily operation, I believe many people in ADO. NET state is what kind of problem there are doubts, small series consulted all kinds of information, sorted out simple and easy to use operation methods, hope to answer "ADO. NET state is what" doubts helpful! Next, please follow the small series to learn together!

ADO. NET state has a lot to learn, but first you must understand the function of ADO. NET state, and what ADO. NET state is, now there are three operations to change the state of the table:

Insert a new line

Delete an existing row

Update an existing row

For each of these critical operations, the ADO. NET state data adapter defines a custom command object that is exposed as a property. Such attributes include InsertCommand, DeleteCommand, and UpdateCommand. The programmer is responsible for assigning meaningful command objects to these attributes, such as the SqlCommand object.

The InsertCommand, DeleteCommand, and UpdateCommand properties alone represent a huge breakthrough from ADO to ADO. NET state. This property gives you control over how updates in memory are submitted to the database server. If you are not satisfied with the update code generated by ADO. NET state, you can now modify the update code without negating the overall nature of batch updates. With ADO, you have no control over SQL commands that the library generates silently.

While in ADO. NET state, with command objects exposed publicly, you can apply updates using custom stored procedures or SQL statements that better match user expectations. In particular, you can use batch update systems for cross-referenced tables, or even target non-SQL data providers such as Active Directory™ or Indexing Services.

The update command should be run for every row in the table that changes and must be very generic to accommodate different values. Command parameters are ideal for this kind of task, as long as you can bind them to values for database columns. The ADO. NET state parameter object exposes two properties for this binding.

For example, SourceColumn and SourceVersion. In particular, SourceColumn represents an indirect way of indicating parameter values. Instead of using the Value property, you can set the SourceColumn property using the column name and have the batch update mechanism fetch valid values from time to time

At this point, the study of "ADO. NET state is what" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

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.