试试这样:Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim cnn As New OleDb.OleDbConnection()
Dim cnstr As String = "Provider = SQLOLEDB.1;Password=mvb1234;Persist Security Info=True;User ID=sa;Initial Catalog=tfmsdb;Data Source=mvb"
Dim dc As OleDb.OleDbDataAdapter
Dim ds As New DataSet()
Dim dr As DataRow
Dim mytable As DataTable
cnn.ConnectionString = cnstr
cnn.Open()
dc = New OleDb.OleDbDataAdapter("select top 20 * from person", cnstr)
dc.Fill(ds, "person")
mytable = ds.Tables("person")
DataGrid1.DataSource = ds.Tables("person")
DataGrid1.DataBind()
DataGrid1.DataMember = mytable.TableName
mytable.Clear()
End Sub
Dim cnn As New OleDb.OleDbConnection()
Dim cnstr As String = "Provider = SQLOLEDB.1;Password=mvb1234;Persist Security Info=True;User ID=sa;Initial Catalog=tfmsdb;Data Source=mvb"
Dim dc As OleDb.OleDbDataAdapter
Dim ds As New DataSet()
Dim dr As DataRow
Dim mytable As DataTable
cnn.ConnectionString = cnstr
cnn.Open()
dc = New OleDb.OleDbDataAdapter("select top 20 * from person", cnstr)
dc.Fill(ds, "person")
mytable = ds.Tables("person")
DataGrid1.DataSource = ds.Tables("person")
DataGrid1.DataBind()
DataGrid1.DataMember = mytable.TableName
mytable.Clear()
End Sub
解决方案 »
- Process 进程调用 Uri 输入字符串的格式不正确
- 求教 跳转问题
- 关于asp.net后台调用前台刷新问题
- 做了一个分类显示页面,但是不知道怎么才能显示
- SESSION的问题
- 页面中有个ifrmae,在page_load时设置src。浏览时,在iframe中找不到此页,但是此页在IE中又能打开,这是为什么?
- 给100,水晶报表如何显示数据库里的图片
- 急!如何在visio 2002版里面由.Net生成的代码生成UML图?
- 请问ASP。NET中怎么实现<%# DataBinder.Eval(Container.DataItem, "netname")==<%=myname%>?"自己购买":"赠送"%>
- 如何用aspx接收发向cgi的request?
- 什么属性可以得到DATAGRID或DATASET.table的记录总数??????
- 数据库连接问题求教。
DataGrid1.DataBind
去掉
mytable.Clear()
DataGrid1.DataBind()
去掉
mytable.Clear()
DataGrid1.DataBind()
去掉
mytable.Clear()
dc.Fill(ds, "person")
dim dv as new dataview(ds.tables("person"))
DataGrid1.DataSource = dv
datagrid1.databind()
DataGrid1.Visible = True