how to show data in datagridview

It's very easy way to bind the data to GridView from Database. Please, write below code and you can bind data to GridView:

SqlConnection cnn = new SqlConnection("Data Source=HOTH;Initial Catalog=Chintan;User ID=sa;Password=123");
cnn.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from tbl_data", cnn);
DataSet ds = new DataSet();
da.Fill(ds);
cnn.Close();

if (ds.Tables[0].Rows.Count != 0)
{
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}


Thank You..... :-)

SqlConnection con = new SqlConnection("Data Source=NONETF3SFRWS151;Initial Catalog=HealthPlus;User ID=sa;Password=sql");
            con.Open();
            SqlDataAdapter adp = new SqlDataAdapter("select * from login", con);
            DataSet ds = new DataSet();
            adp.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];