C# ADO.NET中的DataSet使用技巧

1. 創(chuàng)建一個(gè)新的DataSet對(duì)象

DataSet dataSet = new DataSet();

2. 為DataSet添加一個(gè)新的DataTable

DataTable dataTable = new DataTable("TableName");
dataSet.Tables.Add(dataTable);

3. 給DataTable添加列

dataTable.Columns.Add("ColumnName", typeof(int));

4. 給DataTable添加行

DataRow row = dataTable.NewRow();
row["ColumnName"] = 1;
dataTable.Rows.Add(row);

5. 從數(shù)據(jù)庫(kù)中填充DataSet

string connectionString = "Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=True";
string query = "SELECT * FROM TableName";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlDataAdapter adapter = new SqlDataAdapter(query, connection);
    adapter.Fill(dataSet, "TableName");
}

6. 更新數(shù)據(jù)庫(kù)中的數(shù)據(jù)

using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlDataAdapter adapter = new SqlDataAdapter(query, connection);
    SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
    
    adapter.Update(dataSet, "TableName");
}

7. 使用DataSet中的數(shù)據(jù)

foreach (DataRow row in dataSet.Tables["TableName"].Rows)
{
    Console.WriteLine(row["ColumnName"]);
}

8. 清空DataSet中的數(shù)據(jù)

dataSet.Clear();

9. 保存DataSet中的數(shù)據(jù)到XML文件

dataSet.WriteXml("data.xml");

10. 從XML文件中加載數(shù)據(jù)到DataSet

dataSet.ReadXml("data.xml");

這些是一些基本的DataSet的使用技巧，可以幫助你在C# ADO.NET中更好地操作數(shù)據(jù)集。