Shulou(Shulou.com)05/31 Report--

How to analyze DataSet objects and use, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

The concept of the DataSet object:

The DataSet object can be regarded as a (Catch). It can retain the data found in the database, or even temporarily store the entire database.

DataSet is the representation of data in memory

The online connection between the DataSet object and the data source is very short. We are disconnected from the data source immediately after we get the data, and we will not establish a connection until the data has been modified or when we want to manipulate the data in the data source.

The DataSet object contains a set of DataTable objects and DataRelation objects

DataTable object and its use

DataTable object is one of the important objects of DataSet, which represents a relational data table in memory.

Common properties of DataTable objects

TableName: gets or sets the name of the table

DataSet: indicates which DataSet the table belongs to

Rows (Add,InsertAt,Remove,RemoveAt): a collection of DataRow objects, that is, a collection of rows that represent this table

A collection of Columns:Data Columns objects, that is, a collection of columns that represent this table

Example:

DataSetds = new DataSet ()

DataTable student = new DataTable ("Student")

DataColumn sno = new DataColumn ("Sno")

Sno.DataType = typeof (string)

Sno.MaxLength = 8

DataColumn sname = new DataColumn ("Sname")

Sno.DataType = typeof (string)

Sno.MaxLength = 8

Student.Columns.Add (sno)

Student.Columns.Add (sname)

Ds.Tables.Add (student)

DataRow drl = student.NewRow ()

Drl ["Sno"] = "0125"

Drl ["Sname"] = "Li Shuang"

Student.Rows.Add (drl)

DataRow dr2 = student.NewRow ()

Drl ["Sno"] = "0125x"

Drl ["Sname"] = "x Li Shuang"

Student.Rows.Add (dr2)

GridView1.DataSource = ds.Tables [0]

GridView1.DataBind ()

After reading the above, have you mastered how to analyze DataSet objects and how to use them? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.