用SqlDataAdapter 的 Update()方法,先用select得到selectCommand在用SqlCommandBuilder创建 updateCommand和其他command,最后调用Update方法保存到数据库string connString="数据库连接字符串"; string sql="select * from 表 where 1>2"; //这点筛选出来的字段和datatable的字段一直 SqlConnection conn = new SqlConnection(connString); SqlDataAdapter ada = new SqlDataAdapter(sql, conn); SqlCommandBuilder cb = new SqlCommandBuilder(ada); ada.Update(myDataTable);
string connectionString,string queryString)
{
using (SqlConnection connection =
new SqlConnection(connectionString))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = new SqlCommand(
queryString, connection);
adapter.Fill(datatable);
return datatable;
}
}
{
DataTable strTab = new DataTable();
string sql = String.Empty;
foreach (DataRow dr in strTab)
{
sql = "INSERT(id,name) values({0},'{1}')";
sql = String.Format(sql, dr["id"], dr["name"]);
DataAccess.ExcuteCmd(sql);
}
}
string sql="select * from 表 where 1>2"; //这点筛选出来的字段和datatable的字段一直
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter ada = new SqlDataAdapter(sql, conn);
SqlCommandBuilder cb = new SqlCommandBuilder(ada);
ada.Update(myDataTable);