SqlDataAdapter .Update方法问题
请问SqlDataAdapter .Update方法可不可以对数据库插入数据,就是我有一个与数据库数据结构一样的DataRow,那怎么样把他插入到数据库中 --------------------编程问答--------------------
public DataSet CreateCmdsAndUpdate(DataSet dataSet, string connectionString,
string queryString)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand(queryString, connection);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
connection.Open();
DataSet customers = new DataSet();
adapter.Fill(customers);
//code to modify data in dataset here
//Insert new records from DataSet
DataRow[] rows = customers.Tables[0].Select(
null, null, DataViewRowState.Added);
adapter.Update(rows);
return customers;
}
}
http://msdn.microsoft.com/zh-cn/library/9ab5x5cd(v=VS.80).aspx
--------------------编程问答-------------------- SqlDataAdapter adapter = new SqlDataAdapter();
SqlCommand command = command = new SqlCommand(
"INSERT INTO Tb(ID, Name) " +
"VALUES (@ID, @Name)", connection);
command.Parameters.Add("@ID", SqlDbType.NChar, 5, "ID");
command.Parameters.Add("@Name", SqlDbType.NVarChar, 40, "Name");
adapter.InsertCommand = command;
补充:.NET技术 , ASP.NET