Ashton G
Ashton G

Reputation: 13

Gridview isn't visible in runtime

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

Answers (1)

Magnus
Magnus

Reputation: 46909

Yes do a:

GridView1.DataBind()

After the datasource set.

Upvotes: 2

Related Questions