后台
Partial Class Default2
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
If Not Page.IsPostBack Then
BindGrid()
End If
End Sub
Private Sub Bindcourse()
Me.GridView1.DataSource = SqlHelper.ExcuteReadApdater("course", CommandType.StoredProcedure, Nothing)
' GridView1.DataKeyField = "coursenum"
Me.GridView1.DataBind()
End Sub Private Sub BindGrid() Dim strWhre As String = "select * from c_course"
Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("cnn").ToString())
conn.Open()
Dim adt As New SqlDataAdapter(strWhre, conn)
Dim dataset As New DataSet
adt.Fill(dataset, "jobs")
Me.GridView1.DataSource = dataset.Tables("jobs").DefaultView
Me.GridView1.DataBind()
conn.Close()
End Sub
End Class前台
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
Partial Class Default2
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
If Not Page.IsPostBack Then
BindGrid()
End If
End Sub
Private Sub Bindcourse()
Me.GridView1.DataSource = SqlHelper.ExcuteReadApdater("course", CommandType.StoredProcedure, Nothing)
' GridView1.DataKeyField = "coursenum"
Me.GridView1.DataBind()
End Sub Private Sub BindGrid() Dim strWhre As String = "select * from c_course"
Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("cnn").ToString())
conn.Open()
Dim adt As New SqlDataAdapter(strWhre, conn)
Dim dataset As New DataSet
adt.Fill(dataset, "jobs")
Me.GridView1.DataSource = dataset.Tables("jobs").DefaultView
Me.GridView1.DataBind()
conn.Close()
End Sub
End Class前台
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>
select * from c_course这里有没有数据集。
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
If Not Page.IsPostBack Then
BindGrid()
End If
End Sub
Private Sub BindGrid() Dim con As New SqlConnection(ConfigurationManager.AppSettings("cnn"))
con.Open()
Dim sql As String = "select * from i_toolplan"
Dim ada As New SqlDataAdapter(sql, con)
Dim ds As New DataSet()
ada.Fill(ds, "temp")
GridView1.DataSource = ds.Tables("temp").DefaultView
GridView1.DataBind()
ada.Dispose()
con.Close()
End Sub
End Class为什么啊
中的cnn表示的是什么啊!你看一下你的SqlConnection是否是正确的呢?你的连接字符串SqlConnection是什么?你的后台数据库又是什么呢?
<add name="cnn" connectionString="server=HJSQL01\DEVELOP;uid=sa;pwd=sa;database=Training" providerName="System.Data.SqlClient"/>
</connectionStrings>
感觉代码没有问题.
<Columns>
<asp:BoundField DataField="id" HeaderText="id" />
<asp:BoundField DataField="title" HeaderText="title" />
<asp:BoundField DataField="message" HeaderText="message" /> </Columns>
没设置绑定列! 或者你可以勾上那个自动生成字段选项