Dim DS as new DataSet
dim DA as new SqlDataAdapter
Dim DT As DataTable = New DataTable("aa")
Dim MyConnection As new SQLConnection
Dim MyCommand As new SQLCommand
dim strConn as string
'同数据库进行连接,采用sql server数据库
MyConnection = New SQLConnection("server=chen1;uid=sa;pwd=aabb;database=test")
'执行SQL操作
MyCommand = New SQLCommand("select * from Article",MyConnection)
DA=new SqlDataAdapter()
DA.selectCommand=MyCommand
DS = New DataSet()
DA.fill(DS)
MyConnection.close
'myCommand.FillDataSet(ds, "Article")
MyDataGrid.DataSource=ds
MyDataGrid.DataBind()
dim DA as new SqlDataAdapter
Dim DT As DataTable = New DataTable("aa")
Dim MyConnection As new SQLConnection
Dim MyCommand As new SQLCommand
dim strConn as string
'同数据库进行连接,采用sql server数据库
MyConnection = New SQLConnection("server=chen1;uid=sa;pwd=aabb;database=test")
'执行SQL操作
MyCommand = New SQLCommand("select * from Article",MyConnection)
DA=new SqlDataAdapter()
DA.selectCommand=MyCommand
DS = New DataSet()
DA.fill(DS)
MyConnection.close
'myCommand.FillDataSet(ds, "Article")
MyDataGrid.DataSource=ds
MyDataGrid.DataBind()
解决方案 »
- width:100px包含边框吗?
- 急急急!!config配置authorization 后,输入正确的用户名和密码也不能登录
- 关于Fckeditor拖拽的问题--------急急急
- 网页内部套网页的问题!
- 如何将用户提交的含有http://的文本直接转换成超链接啊
- 求一段无刷新的联动代码
- <div>表示什么?
- 担心asp.net的效率问题~发帖寻问/
- 请问ascx文件和ascx.cs文件的代码执行顺序是什么?
- SmtpMail.SmtpServer = ""?????????????????
- 请问:动态产生的列怎么参加排序?
- 在线等待!在一台机子上安装,下载的.net框架,有没有人数限制啊?
...
DA=new SqlDataAdapter()new过了就不必再new一次了吧。
MyDataGrid.DataBind()
dim DA as SqlDataAdapter
Dim MyConnection As SQLConnection
Dim MyCommand As SQLCommand
dim strConn as string
'同数据库进行连接,采用sql server数据库
MyConnection = New SQLConnection("server=chen1;uid=sa;pwd=aabb;database=test")
'执行SQL操作
MyCommand = New SQLCommand("select * from Article",MyConnection)
DA=new SqlDataAdapter()
DA.selectCommand=MyCommand
DS = New DataSet()
DA.fill(DS)
MyDataGrid.DataSource=DS.tables(0)
MyDataGrid.DataBind()
dim DA as new SqlDataAdapter
Dim DT As DataTable = New DataTable("aa")
Dim MyConnection As new SQLConnection
Dim MyCommand As new SQLCommand
////////////////////////////
改为
Dim DS as new DataSet
dim DA as SqlDataAdapter
Dim DT As DataTable
Dim MyConnection As SQLConnection
Dim MyCommand As SQLCommand
Dim MyConnection As SQLConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New SQLConnection("server=chen1;uid=sa;pwd=aabb;database=test")
MyCommand = New SqlDataAdapter("select * from Article",MyConnection)
DS = New DataSet()
MyCommand.Fill(DS, "Article")
MyDataGrid.DataSource=DS.Tables("Article").DefaultView
MyDataGrid.DataBind()
看楼下高人的了。
你是否写在了pageload里面??