用 GridView1绑定数据,但是页面运行却什么都没有显示????急死了!
也就是 数据没有绑定到用 GridView1上,
代码如下!!
请帮我瞧瞧!!Imports System.Data
Imports System.Data.OleDbPartial Class back_edit
Inherits System.Web.UI.Page
Dim ds As DataSet
Dim dt As DataTable
Public Sub edit()
Dim conn As New OleDbConnection
Dim comm As New OleDbCommand
Dim AP As New OleDbDataAdapter
Dim ds As New DataSet
conn.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & Server.MapPath("~\App_data\webdata.mdb")
comm.Connection = conn
conn.Open()
comm.CommandText = "SELECT * FROM collection"
comm.ExecuteNonQuery()
AP.SelectCommand = comm
AP.Fill(ds, "dt")
GridView1.DataSource = dt
GridView1.DataMember = "ds"
conn.Close()
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
edit()
End Sub
End Class
也就是 数据没有绑定到用 GridView1上,
代码如下!!
请帮我瞧瞧!!Imports System.Data
Imports System.Data.OleDbPartial Class back_edit
Inherits System.Web.UI.Page
Dim ds As DataSet
Dim dt As DataTable
Public Sub edit()
Dim conn As New OleDbConnection
Dim comm As New OleDbCommand
Dim AP As New OleDbDataAdapter
Dim ds As New DataSet
conn.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" & Server.MapPath("~\App_data\webdata.mdb")
comm.Connection = conn
conn.Open()
comm.CommandText = "SELECT * FROM collection"
comm.ExecuteNonQuery()
AP.SelectCommand = comm
AP.Fill(ds, "dt")
GridView1.DataSource = dt
GridView1.DataMember = "ds"
conn.Close()
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
edit()
End Sub
End Class
comm.ExecuteNonQuery()
comm.ExecuteReader()--------
说错了别怪。
GridView1.DataMember = "dt"
comm.CommandText = "SELECT * FROM collection"
//comm.ExecuteNonQuery()
// AP.SelectCommand = comm
// AP.Fill(ds, "dt")
GridView1.DataSource = comm.ExecuteReader()//dt
GridView1.DataBind()
// GridView1.DataMember = "ds"
conn.Close()
GridView1.Refresh
GridView1.DataSource = dt
GridView1.Refresh
comm.Connection = conn
comm.CommandText = "SELECT * FROM collection"
AP.SelectCommand = comm
AP.Fill(ds, "dt")
GridView1.DataSource = ds
GridView1.DataBind()
End Sub建议楼主还是好好把基础的东西看一看
string sqlQuery="select * from collection";
DataSet Ds=new DataSet();
OleDbAdapter Da=new OleDbAdapter(sqlQuery,Conn);
Da.Fill(Ds,"table");
GridView.DataSource=Ds;
GridView.DataBind();
Conn.Close();
简单明了