void SetDGV()
{
dgv_Add_job_card.Columns.Add("Column1", "Column1");
dgv_Add_job_card.Columns.Add("Column2", "Column2");
dgv_Add_job_card.Columns.Add("Column3", "Column3");
dgv_Add_job_card.Columns.Add("Column4", "Column4");
dgv_Add_job_card.Columns.Add("Column5", "Column5");
dgv_Add_job_card.Columns.Add("Column6", "Column6");
dgv_Add_job_card.Columns.Add("Column7", "Column7");
dgv_Add_job_card.Columns.Add("Column8", "Column8");
dgv_Add_job_card.Columns.Add("Column9", "Column9");
dgv_Add_job_card.Columns.Add("Column10", "Column10");
dgv_Add_job_card.Columns.Add("Column11", "Column11");
dgv_Add_job_card.Columns.Add("Column12", "Column12");
dgv_Add_job_card.Columns.Add("Column13", "Column13");
this.dgv_Add_job_card.RowHeadersWidth = 30;
this.dgv_Add_job_card.Columns[0].Width = 70;
this.dgv_Add_job_card.Columns[1].Width = 103;
this.dgv_Add_job_card.Columns[2].Width = 103;
this.dgv_Add_job_card.Columns[3].Width = 103;
this.dgv_Add_job_card.Columns[4].Width = 108;
this.dgv_Add_job_card.Columns[5].Width = 110;
this.dgv_Add_job_card.Columns[6].Width = 120;
this.dgv_Add_job_card.Columns[7].Width = 115;
this.dgv_Add_job_card.Columns[8].Width = 115;
this.dgv_Add_job_card.Columns[9].Visible = false;
this.dgv_Add_job_card.Columns[10].Visible = false;
this.dgv_Add_job_card.Columns[11].Visible = false;
this.dgv_Add_job_card.Columns[12].Visible = false;
dgv_Add_job_card.ColumnHeadersDefaultCellStyle.Font = new
Font(dgv_Add_job_card.Font, FontStyle.Bold);
}
void DisplayData()
{
string s1 = "Your Query";
using (SqlDataAdapter sDA = new SqlDataAdapter(s1, clsVar.con))
{
DataTable dt = new DataTable();
sDA.Fill(dt);
foreach (DataRow item in dt.Rows)
{
int n = dgv_Add_job_card.Rows.Add();
dgv_Add_job_card.Rows[n].Cells[0].Value =
item[0].ToString();
dgv_Add_job_card.Rows[n].Cells[1].Value =
item[1].ToString();
dgv_Add_job_card.Rows[n].Cells[2].Value =
item[2].ToString();
dgv_Add_job_card.Rows[n].Cells[3].Value =
item[3].ToString();
dgv_Add_job_card.Rows[n].Cells[4].Value =
item[4].ToString();
dgv_Add_job_card.Rows[n].Cells[5].Value =
item[5].ToString();
dgv_Add_job_card.Rows[n].Cells[6].Value =
item[6].ToString();
dgv_Add_job_card.Rows[n].Cells[7].Value =
item[7].ToString();
dgv_Add_job_card.Rows[n].Cells[8].Value =
item[8].ToString();
dgv_Add_job_card.Rows[n].Cells[9].Value =
item[8].ToString();
dgv_Add_job_card.Rows[n].Cells[9].Value =
item[8].ToString();
dgv_Add_job_card.Rows[n].Cells[10].Value =
item[10].ToString();
dgv_Add_job_card.Rows[n].Cells[11].Value =
item[11].ToString();
dgv_Add_job_card.Rows[n].Cells[12].Value =
item[12].ToString();
}
}
}
replace item[1] with item[columnName] and so on for all columns