 |
|


Code (C#)
private void Save()
{
string strSQL;
strSQL = "Select Officer_ID,Officer_Card,Officer_Name,Officer_HouseNo,Officer_Village,Officer_District,Officer_Prefecture,Officer_Province,Officer_PostalCode,Officer_Phone,Officer_Position from Officer order by Officer_ID";
sqlCMD = new SqlCommand(strSQL, objconn.conns);
sqlDR = sqlCMD.ExecuteReader();
if (sqlDR.Read())
{
strSQL = "Update Officer set Officer_Card = '" + maskedTextBox3.Text + "'";
strSQL += ",Officer_Name = '" + textBox10.Text + "'";
strSQL += ",Officer_HouseNo = '" + textBox3.Text + "'";
strSQL += ",Officer_Village = '" + textBox4.Text + "'";
strSQL += ",Officer_District = '" + textBox5.Text + "'";
strSQL += ",Officer_Prefecture = '" + textBox6.Text + "'";
strSQL += ",Officer_Province = '" + textBox7.Text + "'";
strSQL += ",Officer_PostalCode = '" + maskedTextBox1.Text + "'";
strSQL += ",Officer_Phone = '" + maskedTextBox2.Text + "'";
strSQL += ",Officer_Position = '" + comboBox1.Text + "'";
strSQL += "where Officer_ID = '" + textBox1.Text + "'";
button2.Enabled = true;
}
else
{
strSQL = "Insert into Officer(Officer_ID,Officer_Card,Officer_Name,Officer_HouseNo,Officer_Village,Officer_District,Officer_Prefecture,Officer_Province,Officer_PostalCode,Officer_Phone,Officer_Position)";
strSQL += "Values('" + textBox1.Text + "','" + maskedTextBox3.Text + "','" + textBox10.Text + "'";
strSQL += ",'" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "'";
strSQL += ",'" + textBox6.Text + "','" + textBox7.Text + "','" + maskedTextBox1.Text + "'";
strSQL += ",'" + maskedTextBox2.Text + "','" + comboBox1.Text + "'";
button2.Enabled = true;
}
sqlDR.Close();
sqlCMD = new SqlCommand(strSQL, objconn.conns);
int numRec = sqlCMD.ExecuteNonQuery();
if (numRec > 0)
{
DialogResult save = MessageBox.Show("คุณต้องการบันทึกข้อมูลใช่หรือไม่ ?", "บันทึกข้อมูล", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
{
if (save == DialogResult.Yes)
{
MessageBox.Show("บันทึกข้อมูลเรียนร้อยแล้ว");
}
else
{
}
}
}
else
{
MessageBox.Show("ไม่สามารถบันทึกข้อมูลได้", "บันทึกข้อมูล", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Tag : Ms SQL Server 2012, VS 2012 (.NET 4.x), C
|
|
 |
 |
 |
 |
Date :
2013-10-04 10:41:51 |
By :
coutiho |
View :
1167 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
 |