如何通过填写数据在C＃中设置ado.net

Question

朋友你好 任何机构可以告诉如何填补在C＃中的数据集或数据表，什么是DataAdapter的

Answer 1

你可以尝试下面的下面。我建议你在网上做更多的阅读以获得更好的理解，也许会举几个例子。

// Assumes that customerConnection is a valid SqlConnection object. 
// Assumes that orderConnection is a valid OleDbConnection object. 
SqlDataAdapter custAdapter = new SqlDataAdapter(
    "SELECT * FROM dbo.Customers", customerConnection); 
OleDbDataAdapter ordAdapter = new OleDbDataAdapter(
    "SELECT * FROM Orders", orderConnection); 

DataSet customerOrders = new DataSet(); 

custAdapter.Fill(customerOrders, "Customers"); 
ordAdapter.Fill(customerOrders, "Orders"); 

DataRelation relation = customerOrders.Relations.Add("CustOrders", 
customerOrders.Tables["Customers"].Columns["CustomerID"], 
customerOrders.Tables["Orders"].Columns["CustomerID"]); 

foreach (DataRow pRow in customerOrders.Tables["Customers"].Rows) 
{ 
    Console.WriteLine(pRow["CustomerID"]); 
    foreach (DataRow cRow in pRow.GetChildRows(relation)) 
    Console.WriteLine("\t" + cRow["OrderID"]); 
} 

从MSDN

Answer 2

Populating a DataSet from a DataAdapter (ADO.NET)

// Assumes that connection is a valid SqlConnection object. 
string queryString = 
    "SELECT CustomerID, CompanyName FROM dbo.Customers"; 
SqlDataAdapter adapter = new SqlDataAdapter(queryString, connection); 

DataSet customers = new DataSet(); 
adapter.Fill(customers, "Customers");