SqlCommandBuilder 是干嘛用的? // 使用DataSet更新数据库
public int UpdateDataSet(DataSet targetDS, string QueryString, string tableName)
{
Database _db = LIFTGetConnection.LIFTConnectionString();
SqlCommand cmd = (SqlCommand)_db.GetSqlStringCommand(QueryString);
cmd.Connection = _db.CreateConnection() as SqlConnection;
SqlDataAdapter da = _db.GetDataAdapter() as SqlDataAdapter;
da.TableMappings.Add("Table", targetDS.Tables[tableName].TableName);
da.SelectCommand = cmd;
SqlCommandBuilder builder = new SqlCommandBuilder(da);
int retNum = -1;
if (targetDS.Tables[tableName].Rows.Count != 0)
{
retNum = da.Update(targetDS);
}
return retNum;
}
public int UpdateDataSet(DataSet targetDS, string QueryString, string tableName)
{
Database _db = LIFTGetConnection.LIFTConnectionString();
SqlCommand cmd = (SqlCommand)_db.GetSqlStringCommand(QueryString);
cmd.Connection = _db.CreateConnection() as SqlConnection;
SqlDataAdapter da = _db.GetDataAdapter() as SqlDataAdapter;
da.TableMappings.Add("Table", targetDS.Tables[tableName].TableName);
da.SelectCommand = cmd;
SqlCommandBuilder builder = new SqlCommandBuilder(da);
int retNum = -1;
if (targetDS.Tables[tableName].Rows.Count != 0)
{
retNum = da.Update(targetDS);
}
return retNum;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货