保存问题

[czh402]

刚接触VB.NET请问一下，对datagridview中的数据修改之后存盘应该如何写代码，以下是我的代码，帮忙看一下
Private Sub 保存SToolStripButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles 保存SToolStripButton.Click
dim conn as sqlclient.sqlconnection("data source=(local);initial catalog=human;user id=sa,pwd=")
dim str as string
str="select * from dengji"
dim dad as sqlclient.sqldataadapter=new sqlclient.sqldataadapter(str,conn)
dim ds as dataset=new dataset ,dt as new datatable
dad.fill(ds,"dengji")
dt=ds.tables("dengji")

dim changedst as new dataset
changedst =ds
if not changedst is nothing then
dim com as new sqlclient.sqlcommandbuilder(dad)
try
dad.update(ds.tables("dengji"))
catch err as sqlclient.sqlexception
messagebox.show(err.message)
end try
end if
end sub

后台数据库无法更新。

[hmilj245216]

你这个"dengji"不是dataSet的名字吗？这么又变成了dataTable的名字了？？不明白LZ的想法

[lx_lhy]

SqlConnection cn=Data.Connection();
SqlDataAdapter da=new SqlDataAdapter("select * from [user]",cn);
DataSet ds=(DataSet)Cache["my"];
SqlCommandBuilder cb = new SqlCommandBuilder(da); //加入这一句
da.Update(ds);
cn.Close();

[akenny0423]

还要datagridview.endedit()
datagridview.updata
da.updata(ds,biaoming)