https://jingyan.baidu.com/article/fd8044fa180c055031137a08.html

private void show_data(DataGridView DG)
{
SqlCommand cmd = new SqlCommand("select ship_no,c_name,ship_date,p_no,p_name,p_spc1,p_qty,s_price,add_price,p_kg from tship where ship_no='" + textBox1.Text + "'", login.share_cls.conn);
SqlDataAdapter dpt = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
//DataTable dt = new DataTable();
dpt.Fill(ds);
DataTable dtb = ds.Tables[0];
//DataGridViewTextBoxColumn mg = new DataGridViewTextBoxColumn();
//DG.Columns.Add(mg);
DG.DataSource = dtb;
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.Columns["Column1"].DataPropertyName = dtb.Columns["ship_no"].ToString();
this.dataGridView1.Columns["Column2"].DataPropertyName = dtb.Columns["c_name"].ToString();
this.dataGridView1.Columns["Column3"].DataPropertyName = dtb.Columns["ship_date"].ToString();
this.dataGridView1.Columns["Column4"].DataPropertyName = dtb.Columns["p_no"].ToString();
this.dataGridView1.Columns["Column5"].DataPropertyName = dtb.Columns["p_name"].ToString();
this.dataGridView1.Columns["Column6"].DataPropertyName = dtb.Columns["p_spc1"].ToString();
this.dataGridView1.Columns["Column7"].DataPropertyName = dtb.Columns["s_price"].ToString();
this.dataGridView1.Columns["Column8"].DataPropertyName = dtb.Columns["add_price"].ToString();
this.dataGridView1.Columns["Column9"].DataPropertyName = dtb.Columns["p_kg"].ToString();