01.sb.Remove(0, sb.Length);
02. sb.Append("select*from in_goods where fg_code ='" + textBox1.Text + "'");
03. string sqlingoods = sb.ToString();
04. da = new SqlDataAdapter(sqlingoods, con);
05. DataTable dt = new DataTable();
06. da.Fill(dt);
07.
08. this.dataGridView1.DataSource = dt;
09. this.dataGridView1.Columns.Clear();
10. var wiht1 = dataGridView1.ColumnHeadersDefaultCellStyle;
11. wiht1.BackColor = Color.Navy;
12. wiht1.ForeColor = Color.White;
13. wiht1.Font = new Font(dataGridView1.Font, FontStyle.Bold);
14. DataGridViewTextBoxColumn colomn1 = new DataGridViewTextBoxColumn();
15.
16. colomn1 = new DataGridViewTextBoxColumn();
17. colomn1.DataPropertyName = "ou_code";
18. colomn1.HeaderText = "บริษัท";
19. colomn1.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
20. colomn1.Width = 100;
21. this.dataGridView1.Columns.Add(colomn1);
22.
23. colomn1 = new DataGridViewTextBoxColumn();
24. colomn1.DataPropertyName = "fg_code";
25. colomn1.HeaderText = "รหัสสินค้า";
26. colomn1.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
27. colomn1.Width = 100;
28. this.dataGridView1.Columns.Add(colomn1);
29.
30. colomn1 = new DataGridViewTextBoxColumn();
31. colomn1.DataPropertyName = "fg_name";
32. colomn1.HeaderText = "รายละเอียด";
33. colomn1.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
34. colomn1.Width = 100;
35. this.dataGridView1.Columns.Add(colomn1);
36.
37. colomn1 = new DataGridViewTextBoxColumn();
38. colomn1.DataPropertyName = "old_price";
39. colomn1.HeaderText = "ราคาป้าย";
40. colomn1.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
41. colomn1.Width = 100;
42. this.dataGridView1.Columns.Add(colomn1);
43.
44. colomn1 = new DataGridViewTextBoxColumn();
45. colomn1.DataPropertyName = "u_price";
46. colomn1.HeaderText = "ราคาขาย";
47. colomn1.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
48. colomn1.Width = 100;
49. this.dataGridView1.Columns.Add(colomn1);
50.
51. colomn1 = new DataGridViewTextBoxColumn();
52. colomn1.DataPropertyName = "cost";
53. colomn1.HeaderText = "ราคาต้นทุน";
54. colomn1.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
55. colomn1.Width = 100;
56. this.dataGridView1.Columns.Add(colomn1);
