我先定义了mystring为连接字符串,myselectquery为查询字符串
Dim myconnection As New Sqlconnection(mystring)
dim myadapter as new sqldataadapter()
myadapter.SelectCommand = New SqlClient.SqlCommand(myselectquery, myconnection)
这样以后,我想定义一个dim abc as dataset
然后想把查询结果写入dataset这个数据集
然后显示所查询的表,显示在datagrid1里面,各位大侠,帮忙写出代码。
如果方便,再写一下,如果我在datagrid1里修改了数据以后,应如何更新数据库。
先谢谢了,满分求助
myadapter.fill(abc);
datagrid1.DataSource=abc.tables(0)
Dim myconnection As New Sqlconnection(mystring)
dim myadapter as new sqldataadapter(myselectquery,myconnection)
dim abc as dataset=new dataset()
myadapter.fill(abc)
datagrid1.DataSource=abc.tables(0)
datagrid1.DataBind()
http://expert.csdn.net/Expert/icView1.asp?id=1521284
看一下Quickstart
—————————————————————————————————
网速太慢。