datatable 为何无法批量更新
public bool Updatatable(string StrSql, DataTable datatable,string ConnString)
{
SqlConn = new SqlConnection(ConnString);
SqlConn.Open();
System.Data.SqlClient.SqlCommand sqlCmd = new SqlCommand(StrSql, SqlConn);
System.Data.SqlClient.SqlDataAdapter sqlAdap = new SqlDataAdapter(sqlCmd);
System.Data.SqlClient.SqlCommandBuilder sqlBuild = new SqlCommandBuilder(sqlAdap);
sqlAdap.Update(datatable);
SqlConn.Close();
}