category = 1
Dim sqlCon As New SqlConnection(Web.Configuration.WebConfigurationManager.ConnectionStrings("enrollmentdbConnectionString").ToString)
Dim sqlDA As New SqlDataAdapter
Dim sqlDt As New DataTable sqlDA.SelectCommand = New SqlCommand
sqlDA.SelectCommand.Connection = sqlCon sqlDA.SelectCommand.CommandType = Data.CommandType.StoredProcedure
sqlDA.SelectCommand.CommandText = "sp_SelectCategory"
sqlDA.SelectCommand.Parameters.Add("@CategoryName", SqlDbType.Int)
sqlDA.SelectCommand.Parameters(0).Value = category Try
sqlCon.Open()
sqlDA.Fill(sqlDt)
sqlCon.Close()
Catch ex As Exception
sqlCon.Close()
End Try Me.Label3.Text = sqlDt.Rows(0).Item(1).ToString
Me.GridView1.DataSource = sqlDt
Me.GridView1.DataBind()
---------------------------------
为什么label3显示确实sqldt中已经有数据,就是不能在gridview中显示出?
Dim sqlCon As New SqlConnection(Web.Configuration.WebConfigurationManager.ConnectionStrings("enrollmentdbConnectionString").ToString)
Dim sqlDA As New SqlDataAdapter
Dim sqlDt As New DataTable sqlDA.SelectCommand = New SqlCommand
sqlDA.SelectCommand.Connection = sqlCon sqlDA.SelectCommand.CommandType = Data.CommandType.StoredProcedure
sqlDA.SelectCommand.CommandText = "sp_SelectCategory"
sqlDA.SelectCommand.Parameters.Add("@CategoryName", SqlDbType.Int)
sqlDA.SelectCommand.Parameters(0).Value = category Try
sqlCon.Open()
sqlDA.Fill(sqlDt)
sqlCon.Close()
Catch ex As Exception
sqlCon.Close()
End Try Me.Label3.Text = sqlDt.Rows(0).Item(1).ToString
Me.GridView1.DataSource = sqlDt
Me.GridView1.DataBind()
---------------------------------
为什么label3显示确实sqldt中已经有数据,就是不能在gridview中显示出?
Me.GridView1.DataMember = sqlDt.TableName;
看看
webform.
换成dataset也不行啊。
是不是绑定的时候,他读的是另一个sqlDt的值。
你编译的时候看一下有没有警告,有的话看看警告的信息
郁闷!