gheysar14
یک شنبه 09 تیر 1387, 16:29 عصر
من میخوام اطلاعات یک جدول رو تو گریدویو نشون بدم . کنترل گریدویو رو تو صفحه انداختم ولی موقع لود شدن صفحه هیچ چیز نمایش داده نمیشه .
Dim objConnection As New SqlConnection("Data Source=.;Initial Catalog=SiteDB;User ID=sa; password=")
Dim objCommand As New SqlCommand()
Dim ds As New DataSet
objCommand.CommandText = "select * from tblNewsletter"
objConnection.Open()
Dim da As New SqlDataAdapter(objCommand)
objCommand.CommandType = CommandType.Text
objCommand.Connection = objConnection
da.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
GridView1.Visible = True
Dim objConnection As New SqlConnection("Data Source=.;Initial Catalog=SiteDB;User ID=sa; password=")
Dim objCommand As New SqlCommand()
Dim ds As New DataSet
objCommand.CommandText = "select * from tblNewsletter"
objConnection.Open()
Dim da As New SqlDataAdapter(objCommand)
objCommand.CommandType = CommandType.Text
objCommand.Connection = objConnection
da.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
GridView1.Visible = True