我NewRow的行 老是得不到我的赋值Database db = DatabaseFactory.CreateDatabase("StrConn");
System.Text.StringBuilder strSql = new System.Text.StringBuilder();
strSql.Append("select Language_name,Language_code ");
strSql.Append(" FROM LanguageCode ");
DataSet ds= db.ExecuteDataSet(CommandType.Text, strSql.ToString());
DataRow dr = ds.Tables[0].NewRow();
dr["Language_name"] = "中文11";
dr["Language_code"] = "zh-cn11";
ds.Tables[0].Rows.Add(dr);
ds.Tables[0].TableName = "LanguageCode";
DbCommand insertCommand = db.GetStoredProcCommand("LanguageCode_ADD");
db.AddInParameter(insertCommand, "Language_name", DbType.String, DataRowVersion.Current);
db.AddInParameter(insertCommand, "Language_code", DbType.String, DataRowVersion.Current); DbCommand deleteCommand = db.GetStoredProcCommand("LanguageCode_Delete");
db.AddInParameter(deleteCommand, "Language_code", DbType.String, DataRowVersion.Current); DbCommand updateCommand = db.GetStoredProcCommand("LanguageCode_Update");
db.AddInParameter(updateCommand, "Language_name", DbType.String, DataRowVersion.Current); int i = db.UpdateDataSet(ds, "LanguageCode", insertCommand, updateCommand, deleteCommand, Microsoft.Practices.EnterpriseLibrary.Data.UpdateBehavior.Standard); if (i == 0)
{
Response.Write("no");
}
System.Text.StringBuilder strSql = new System.Text.StringBuilder();
strSql.Append("select Language_name,Language_code ");
strSql.Append(" FROM LanguageCode ");
DataSet ds= db.ExecuteDataSet(CommandType.Text, strSql.ToString());
DataRow dr = ds.Tables[0].NewRow();
dr["Language_name"] = "中文11";
dr["Language_code"] = "zh-cn11";
ds.Tables[0].Rows.Add(dr);
ds.Tables[0].TableName = "LanguageCode";
DbCommand insertCommand = db.GetStoredProcCommand("LanguageCode_ADD");
db.AddInParameter(insertCommand, "Language_name", DbType.String, DataRowVersion.Current);
db.AddInParameter(insertCommand, "Language_code", DbType.String, DataRowVersion.Current); DbCommand deleteCommand = db.GetStoredProcCommand("LanguageCode_Delete");
db.AddInParameter(deleteCommand, "Language_code", DbType.String, DataRowVersion.Current); DbCommand updateCommand = db.GetStoredProcCommand("LanguageCode_Update");
db.AddInParameter(updateCommand, "Language_name", DbType.String, DataRowVersion.Current); int i = db.UpdateDataSet(ds, "LanguageCode", insertCommand, updateCommand, deleteCommand, Microsoft.Practices.EnterpriseLibrary.Data.UpdateBehavior.Standard); if (i == 0)
{
Response.Write("no");
}
DataRow dr = dt.NewRow(); dr[0] = = "中文11";
dt.Rows.Add(dr);
DataSet ds= db.ExecuteDataSet(CommandType.Text, strSql.ToString());
ds.Tables[0].TableName = "LanguageCode";
// 从DataSet中得到DataTable
table = ds.Tables["LanguageCode"];
DataRow dr = table.NewRow();
dr[0] = "中文11";
table.Rows.Add(dr);