string userid = this.TextBox1.Text ;
string sqlmy = "select top 2 newsid,title from v_News where newsid='" + userid + "' order by newsid desc";
sqldate db = new sqldate();
SqlCommand ds = db.Creatcommand(sqlmy);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = ds;
DataSet daset = new DataSet("ceshi");
adapter.Fill(daset);
string UPSQL = "UPDATE v_News SET title='KFC' WHERE newsid = '" + userid + "'";
SqlCommand dd = db.Creatcommand(UPSQL);
adapter.UpdateCommand = dd;
adapter.Update(daset);
for (int i = 0; i < daset.Tables[0].Rows.Count; i++)
{
for (int j = 0; j < daset.Tables[0].Columns.Count; j++) {
Page.Response.Write(daset.Tables[0].Rows[i].ItemArray[j] + "<br />");
}
}
//string sqltitle = daset.Tables[0].Rows[0].ItemArray[2].ToString();
//this.lblDisplay.Text = sqltitle;
db.Close();
string p = "<p id='pp'>aaaaaaaaaabbbbbbbb</p> ";
text2.InnerHtml = p;我是新学的所以想做一个测试。
取得一个ID更新后显示出来。
问题是SELECT出数据后我装到dateset按照书上写的。
我用适配器进行UPDATE后TITLE数据应该变成'KFC'可是现在原有数据不变。。
思路不是很清晰大家帮帮忙
string sqlmy = "select top 2 newsid,title from v_News where newsid='" + userid + "' order by newsid desc";
sqldate db = new sqldate();
SqlCommand ds = db.Creatcommand(sqlmy);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = ds;
DataSet daset = new DataSet("ceshi");
adapter.Fill(daset);
string UPSQL = "UPDATE v_News SET title='KFC' WHERE newsid = '" + userid + "'";
SqlCommand dd = db.Creatcommand(UPSQL);
adapter.UpdateCommand = dd;
adapter.Update(daset);
for (int i = 0; i < daset.Tables[0].Rows.Count; i++)
{
for (int j = 0; j < daset.Tables[0].Columns.Count; j++) {
Page.Response.Write(daset.Tables[0].Rows[i].ItemArray[j] + "<br />");
}
}
//string sqltitle = daset.Tables[0].Rows[0].ItemArray[2].ToString();
//this.lblDisplay.Text = sqltitle;
db.Close();
string p = "<p id='pp'>aaaaaaaaaabbbbbbbb</p> ";
text2.InnerHtml = p;我是新学的所以想做一个测试。
取得一个ID更新后显示出来。
问题是SELECT出数据后我装到dateset按照书上写的。
我用适配器进行UPDATE后TITLE数据应该变成'KFC'可是现在原有数据不变。。
思路不是很清晰大家帮帮忙
daset.AcceptChanges();