DataGrid中插入新行的问题,已经好几天没解决了,求助!!!
下面是我的代码:
public DataSet CreateDataSet()
{
sql = "Select * FROM People";
DataSet cachedDataSet = (DataSet)Session["MyData"];
if (!(cachedDataSet == null))
{
return cachedDataSet;
}
DataSet ds = new DataSet();
try
{
SqlConnection conn = new SqlConnection(strCnn);
SqlDataAdapter db_sqladaptor = new SqlDataAdapter(sql,conn);
db_sqladaptor.Fill(ds,"MyDataResult");
Session["MyCalendarData"] = ds;
}
catch (Exception e)
{
//ErrorMessage.Text = e.Message;
ds = null;
}
return ds;
}
public void ROW_Add(object sender, EventArgs e)
{
sql = "Select * FROM People";
DataSet ds= CreateDataSet();
DataRow newRow;
newRow = ds.Tables["MyDataResult"].NewRow();
newRow["FirstName"] = "";
newRow["LastName"] = "";
ds.Tables["MyDataResult"].Rows.Add(newRow);
Session["MyData"] = null;
People.DataSource = CreateDataSet();
People.DataBind();
People.EditItemIndex = People.Items.Count-1;
People.DataSource = CreateDataSet();
People.DataBind();
}
----------------------------------------------------------------------
我怎么看也不知道上面这段代码有什么问题!我每次运行的时候,不能插入新行,只能在最后一行里显示为编辑状态,不知为什么新行总是插入不进去?
请高手帮忙!!!
问题点数：10、回复次数：6Top
1 楼net_lover（【孟子E章】）回复于 2003-12-02 22:42:34 得分 1
http://xml.sz.luohuedu.net/xml/ShowList.asp?id=1Top
2 楼maohbao2（）回复于 2003-12-02 23:01:14 得分 0
高手帮我看看这段代码有什么总问题啊?Top
3 楼dub（dub）回复于 2003-12-02 23:10:48 得分 2
你插入新行时只插入到DataSet中，并没有真正插入到数据库中。
再次绑定数据源的时候，你又是在数据库中查询出结果来赋给DataSet的。所以DataSet还是原来的数据记录Top
4 楼maohbao2（）回复于 2003-12-02 23:14:31 得分 0
to: dub(dub)
那该怎么办啊?Top
5 楼superch0054（竹君子）回复于 2003-12-03 00:04:26 得分 3
这里
public static DataSet ds
People.DataSource = CreateDataSet();－－－－》People.DataSource＝ds
People.DataBind();
People.EditItemIndex = People.Items.Count-1;
People.DataSource = CreateDataSet();--------->People.DataSource=ds
People.DataBind();
Top
6 楼dub（dub）回复于 2003-12-03 09:21:59 得分 4
DataSet ds= CreateDataSet();
DataRow newRow;
newRow = ds.Tables["MyDataResult"].NewRow();
newRow["FirstName"] = "";
newRow["LastName"] = "";
ds.Tables["MyDataResult"].Rows.Add(newRow);
Session["MyData"] = null; //把这行改为：Session["MyData"] = ds;
People.DataSource = CreateDataSet();
People.DataBind();
People.EditItemIndex = People.Items.Count-1;
People.DataSource = CreateDataSet();
People.DataBind();Top
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
