Comments by ManjIndian (Top 34 by date)

private void Form1_Load(object sender, EventArgs e)
{
SqlConnection con=new SqlConnection(@"Data Source=SA;Initial Catalog=bookStore;Integrated Security=True");
con.Open();
SqlCommand com = new SqlCommand("Select * from b", con);//("select title,author,genre from b",con);
SqlDataReader dr =com.ExecuteReader();
DataTable dt=new DataTable();
dt.Load(dr);
dataGridView1.DataSource = dt;
if (dataGridView1.Rows.Count < 20)
{
int r = 20 - dataGridView1.Rows.Count;
for (int i = 0; i < r; i++)
{
AddARow(dt);
}
}
dataGridView1.DefaultCellStyle.BackColor = Color.SkyBlue;
dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.White;

}
private void AddARow(DataTable table)
{

DataRow newRow = table.NewRow();


table.Rows.Add(newRow);
}

What you are edited?

thanks for the valuable suggestion..

thanks for the valuable suggestion..