methods.InsertDeleteCmd("INSERT INTO Users Values($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11)");
methods.cmd.Parameters.Clear();
methods.cmd.Parameters.AddWithValue("$1", textBox1.Text.Trim());
methods.cmd.Parameters.AddWithValue("$2", textBox2.Text.Trim());
if (Convert.ToBoolean(dataGridView1[1, 0].Value) == true)
{
methods.cmd.Parameters.AddWithValue("$3", "True");
}
else
{
methods.cmd.Parameters.AddWithValue("$3", "False");
}
if (Convert.ToBoolean(dataGridView1[1, 1].Value) == true)
{
methods.cmd.Parameters.AddWithValue("$4", "True");
}
else
{
methods.cmd.Parameters.AddWithValue("$4", "False");
}
if (Convert.ToBoolean(dataGridView1[1, 2].Value) == true)
{
methods.cmd.Parameters.AddWithValue("$5", "True");
}
else
{
methods.cmd.Parameters.AddWithValue("$5", "False");
}
if (Convert.ToBoolean(dataGridView1[1, 3].Value) == true)
{
methods.cmd.Parameters.AddWithValue("$6", "True");
}
else
{
methods.cmd.Parameters.AddWithValue("$6", "False");
}
if (Convert.ToBoolean(dataGridView1[1, 4].Value) == true)
{
methods.cmd.Parameters.AddWithValue("$7", "True");
}
else
{
methods.cmd.Parameters.AddWithValue("$7", "False");
}
if (Convert.ToBoolean(dataGridView1[1, 5].Value) == true)
{
methods.cmd.Parameters.AddWithValue("$8", "True");
}
else
{
methods.cmd.Parameters.AddWithValue("$8", "False");
}
if (Convert.ToBoolean(dataGridView1[1, 6].Value) == true)
{
methods.cmd.Parameters.AddWithValue("$9", "True");
}
else
{
methods.cmd.Parameters.AddWithValue("$9", "False");
}
if (Convert.ToBoolean(dataGridView1[1, 7].Value) == true)
{
methods.cmd.Parameters.AddWithValue("$10", "True");
}
else
{
methods.cmd.Parameters.AddWithValue("$10", "False");
}
if (Convert.ToBoolean(dataGridView1[1, 8].Value) == true)
{
methods.cmd.Parameters.AddWithValue("$11", "True");
}
else
{
methods.cmd.Parameters.AddWithValue("$11", "False");
}
methods.cmd.Dispose();
MessageBox.Show("عملية الحفظ تمت بنجاح", "تسجيل مستخدم جديد", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);فلسطين .. سوريا ..بورما ......وماذا بعد ؟!
سابقا
medo_programming
موقعي : www.alkhayat-it.com
مواضيع مهمه
-----------------------------------------------: