DataGrid1.DataSource = MyDr
==>
DataGrid1.DataSource = MyDr.Tables("article")try it.
==>
DataGrid1.DataSource = MyDr.Tables("article")try it.
解决方案 »
- 怎么合理处理系统中的文件?
- 奇怪,这个gridview点击编辑为什么没反应?
- prototype ajax 提示效果
- 各位老大,救命呀
- asp.net多人开发时的合作问题?(大家都来讨论呀!)
- 如何让真实的url不显示出来??
- 关于服务器控件在Table运行的问题
- HttpRuntime.Cache怎么动不动就失效了?2.0,1.1的时候都不会啊
- 大家来看呀?.net的严重问题!
- asp.net 网站 怎么打包为android 系统
- 刚开始学习,请问如何在本地用sql语句删除远程服务器的表?先谢谢了!!!
- 有什么办法可以在页面初始化之后获得页面的焦点所在的控件。注:在*.aspx.cs文件中实现。
Dim mySource As DataView=MyDr.Tables("article").DefaultView
DataGrid1.DataSource=mySource
或一句搞定:
DataGrid1.DataSource = MyDr.Tables("article").DefaultView希望可以 ^_^
Inherits System.Web.UI.Page
Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid#Region " Web 窗体设计器生成的代码 " '该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() End Sub Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub#End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
End Sub Private Sub DataGrid1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataGrid1.SelectedIndexChanged
Dim ConStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("db1.mdb")
Dim MyConn As New OleDb.OleDbConnection(ConStr)
MyConn.Open()
Dim Sqlstr As String = "select * from article"
Dim MyAdp As New OleDb.OleDbDataAdapter(Sqlstr, MyConn)
Dim MyDr As New DataSet()
MyAdp.Fill(MyDr, "article")
DataGrid1.DataSource = MyDr
DataGrid1.DataBind() MyDr.Dispose()
MyAdp.Dispose() MyConn.Close()
MyConn = Nothing End Sub Private Sub SqlConnection1_InfoMessage(ByVal sender As System.Object, ByVal e As System.Data.SqlClient.SqlInfoMessageEventArgs) End Sub
End Class
if not IsPostBack then
Dim ConStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("db1.mdb")
Dim MyConn As New OleDb.OleDbConnection(ConStr)
MyConn.Open()
Dim Sqlstr As String = "select * from article"
Dim MyAdp As New OleDb.OleDbDataAdapter(Sqlstr, MyConn)
Dim MyDr As New DataSet()
MyAdp.Fill(MyDr, "article")
DataGrid1.DataSource = MyDr
DataGrid1.DataBind() MyDr.Dispose()
MyAdp.Dispose() MyConn.Close()
MyConn = Nothing
end if
End Sub
早知道我也说清楚一点
也谢谢你热情的帮忙!!我的问题多的不得了!希望你能帮忙!