//Заполнение таблицы Заказы
private void customer_form_Load(object sender, EventArgs e)
{
var column1 = new DataGridViewColumn();
column1.HeaderText = "№";
column1.Width = 100;
column1.ReadOnly = true;
column1.Name = "id";
column1.Frozen = true;
column1.CellTemplate = new DataGridViewTextBoxCell();
var column2 = new DataGridViewColumn();
column2.HeaderText = "Дата заказа";
column2.Name = "name";
column2.CellTemplate = new DataGridViewTextBoxCell();
column2.ReadOnly = true;
var column3 = new DataGridViewColumn();
column3.HeaderText = "Название заказа";
column3.Name = "count";
column3.CellTemplate = new DataGridViewTextBoxCell();
column3.ReadOnly = true;
var column4 = new DataGridViewColumn();
column4.HeaderText = "Продукт";
column4.Name = "price";
column4.CellTemplate = new DataGridViewTextBoxCell();
column4.ReadOnly = true;
var column5 = new DataGridViewColumn();
column5.HeaderText = "Заказчик";
column5.Name = "sum";
column5.CellTemplate = new DataGridViewTextBoxCell();
column5.ReadOnly = true;
var column6 = new DataGridViewColumn();
column6.HeaderText = "Менеджер";
column6.Name = "status";
column6.CellTemplate = new DataGridViewTextBoxCell();
column6.ReadOnly = true;
var column7 = new DataGridViewColumn();
column7.HeaderText = "Цена";
column7.Name = "count";
column7.CellTemplate = new DataGridViewTextBoxCell();
column7.ReadOnly = true;
var column8 = new DataGridViewColumn();
column8.HeaderText = "Дата завершения";
column8.Name = "price";
column8.CellTemplate = new DataGridViewTextBoxCell();
column8.ReadOnly = true;
var column9 = new DataGridViewColumn();
column9.HeaderText = "Примеры работ";
column9.Name = "sum";
column9.CellTemplate = new DataGridViewTextBoxCell();
column9.ReadOnly = true;
var column10 = new DataGridViewColumn();
column10.HeaderText = "Статус";
column10.Name = "status";
column10.CellTemplate = new DataGridViewTextBoxCell();
column10.ReadOnly = true;
dataGridView1.Columns.Add(column1);
dataGridView1.Columns.Add(column2);
dataGridView1.Columns.Add(column3);
dataGridView1.Columns.Add(column4);
dataGridView1.Columns.Add(column5);
dataGridView1.Columns.Add(column6);
dataGridView1.Columns.Add(column7);
dataGridView1.Columns.Add(column8);
dataGridView1.Columns.Add(column9);
dataGridView1.Columns.Add(column10);
// TODO: данная строка кода позволяет загрузить данные в таблицу "projekt2DataSet.order". При необходимости она может быть перемещена или удалена.
//this.orderTableAdapter.Fill(this.projekt2DataSet.order);
SqlConnection conn = DBUtils.GetDBConnection();
conn.Open();
string query = "SELECT * FROM [order] WHERE customer=\'" + label1.Text + "\'";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
List <string[]> data = new List <string[]>();
while (reader.Read())
{
data.Add(new string[10]);
data[data.Count - 1][0] = reader[0].ToString();
data[data.Count - 1][1] = reader[1].ToString();
data[data.Count - 1][2] = reader[2].ToString();
data[data.Count - 1][3] = reader[3].ToString();
data[data.Count - 1][4] = reader[4].ToString();
data[data.Count - 1][5] = reader[5].ToString();
data[data.Count - 1][6] = reader[6].ToString();
data[data.Count - 1][7] = reader[7].ToString();
data[data.Count - 1][8] = reader[8].ToString();
data[data.Count - 1][9] = reader[9].ToString();
}
reader.Close();
conn.Close();
foreach (string[] s in data)
{
dataGridView1.Rows.Add(s[0], s[1], s[2], s[3], s[4], s[5], s[6], s[7], s[8], s[9]);
}
for (int i = 0; i < dataGridView1.Rows.Count; ++i)
{
for (int j = 0; j < dataGridView1.Columns.Count; ++j)
{
object o = dataGridView1[j, i].Value;
}
}
}
