142
for (int i = 0; i < Program.f1.Grid.Rows.Count - 1; i++)
{
comboBox2.Items.Add(Program.f1.Grid.Rows[i].Cells[0].Value.ToString());
}
};
}
private void Form3_Shown(object sender, EventArgs e)
{
}
private void Form3_FormClosed(object sender, FormClosedEventArgs e)
{
Application.Exit();
}
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
string strSQL = "INSERT INTO Users (Id_менеджера, ФИО, Пароль,
Категория) VALUES ("+ (Program.f1.Grid.RowCount+1) + ", N'"+textBox1.Text+
"', '" + textBox2.Text + "', '" + comboBox1.SelectedItem + "')";
DataSet ds = new DataSet();
143
using (SqlConnection cn = new SqlConnection(Program.f1.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
da.Fill(ds, "Users");
}
if (Program.f1.Grid.RowCount <1 ) { Application.Exit(); }
}
private void button2_Click(object sender, EventArgs e)
{
string str = "DELETE FROM Users WHERE(ФИО LIKE
N'"+comboBox2.SelectedItem+"')";
DataSet ds = new DataSet();
using (SqlConnection cn = new SqlConnection(Program.f1.strConn))
{
SqlDataAdapter da = new SqlDataAdapter(str, cn);
da.Fill(ds, "Users");
}
}
private void button3_Click(object sender, EventArgs e)
{
Form2 Form02 = new Form2();
Form02.ShowDialog();
}
}
}
