gridview

//First make the connection

SqlConnection ObjConnection = new SqlConnection(" Connection string");

SqlDataAdapter ObjDataAdapter= new SqlDataAdapter("Select * from Table Name",ObjConnection);  //Give the table name from where you want to fetch data

DatSet ObjDataSet= new ObjDataSet();

ObjDataAdapter.Fill(ObjDataset,"Dataset table Name"); //Store data into dataset table by any Name

GridView1.DataSource=ObjDataSet.Tables["DataSet Table Name"];

GridView1.Databind();

DataSet ds = GetAllRecord();
if(ds.Rows.Count >0)
{
    GridView1.DataSource = ds;
}
else
{
        GridView1.DataSource = null;
}

    GridView1.Databind();

DataSet ds = GetAllRecord();
if(ds.Rows.Count >0)
{
    GridView1.DataSource = ds;
}
else
{
        GridView1.DataSource = null;
}

    GridView1.Databind();

            Dim dataTable As New DataTable

            dataTable  = GetRecords()  ' function
            If (dataTable.Rows.Count > 0) Then
               GridView.DataSource = dataTable.DefaultView
                GridView.DataBind()                
            Else
                ErrorLabel.Visible = True
                ErrorLabel.Text = "No records found"
               .DataSource = Nothing
            End If

Hi,

u can bind the table to gridview

gridview.DataSource = dt;

gridview.Databind();