{
SqlCommand mySqlCommand = new SqlCommand("select * from tbuser", con);
SqlDataAdapter mySqlAdapter = new SqlDataAdapter(mySqlCommand);
DataSet myDataSet = new DataSet();
mySqlAdapter.Fill(myDataSet);
DataTable publishersDataTable = new DataTable("tbuser"); // tbuser is our table name from database
mySqlAdapter.Fill(publishersDataTable);
int dataTableRowCount = publishersDataTable.Rows.Count;
if (dataTableRowCount > 0)
{
GridView1.DataSource = publishersDataTable;
GridView1.DataBind();
}
}