Пример #1
0
        private void button3_Click(object sender, EventArgs e)
        {
            string name  = tbName.Text,
                   birth = dtpBirth.Value.ToString("yyyy-MM-dd"),
                   tab   = textBox3.Text,
                   inn   = tbInn.Text,
                   snils = tbSnils.Text,
                   dep   = cbDep.SelectedValue.ToString(),
                   post  = cbPost.SelectedValue.ToString(),
                   pasp  = tbPasp.Text,
                   query = string.Format(@"insert into Employee (name,birth,inn,snils,pasp,post_id,dep_id,tabNumber) 
                        values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}');", name, birth, inn, snils, pasp, post, dep, tab);

            if (!ret)
            {
                DBConnect.ExecuteNonQuery(query);
            }
            else
            {
                query += "SELECT CAST(scope_identity() AS int)";
                worker = Convert.ToInt16(DBConnect.ExecuteScalar(query));
            }
            Close();
        }