Reputation: 13
Gridview isn't visible in runtime, I haven't set visible property too.
Any suggestion?
My code is :
Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim sqlCnn As SqlConnection
Dim sqlCmd As SqlCommand
Dim sql As String
Dim sda As SqlDataAdapter
Dim connectionString As String = "Data Source=THERAIN\SQLEXPRESS;Initial Catalog=Ashok;User ID=sa;Password=Ashok"
sqlCnn = New SqlConnection(connectionString)
sql = "SELECT * FROM Income WHERE date>='" + TextBox1.Text.ToString + "' and date<='" + TextBox2.Text.ToString + "'"
sda = New SqlDataAdapter(sql, sqlCnn)
sqlCnn.Open()
Dim ds As New DataSet
Dim commandBuilder As SqlCommandBuilder = New SqlCommandBuilder(sda)
sda.Fill(ds)
GridView1.DataSource = ds.Tables("Income")
sqlCnn.Close()
GridView1.Visible = True
End Sub
Upvotes: 0
Views: 209