04-03-23, 03:46 PM
try
{
SqlCommand cmd = new SqlCommand("insert into tblResistor('" +
theNumberTextBox.Text + "','" +
martialNumberTextBox.Text + "','" +
rankIdComboBox.Text + "','" +
nameTextBox.Text + "','" +
cardNoTextBox.Text + "','" +
cardTypeIdComboBox.Text + "','" +
areaNameTextBox.Text + "','" +
streetNameTextBox.Text + "','" +
motherNameTextBox.Text + "','" +
mobile1TextBox.Text + "','" +
jobTextBox.Text + "','" +
addressTextBox.Text + "','" +
salaryTextBox.Text + "','" +
drillNameTextBox.Text + "','" +
drillStartDateTimePicker.Text + "','" +
drillEndDateTimePicker.Text + "','" +
drillSuitableCheckBox.Text + "','" +
drillNoteTextBox.Text + "','" +
stopedCheckBox.Text + "','" +
stopedReasonTextBox.Text + "','" +
bloodTypeComboBox.Text + "','" +
jobComboBox.Text + "','" +
GovernorateIDcomboBox.Text + "','" +
statusIDComboBox.Text + "','" +
stateIdComboBox.Text + "','" +
flagIdComboBox.Text + "','" +
DirectorialTextBox.Text + "','" +
detachmentIdComboBox.Text + "')", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("تم اضافة البيانات بنجاح ");
رسالة الخطاء هي '('lncorrect syntax near
{
SqlCommand cmd = new SqlCommand("insert into tblResistor('" +
theNumberTextBox.Text + "','" +
martialNumberTextBox.Text + "','" +
rankIdComboBox.Text + "','" +
nameTextBox.Text + "','" +
cardNoTextBox.Text + "','" +
cardTypeIdComboBox.Text + "','" +
areaNameTextBox.Text + "','" +
streetNameTextBox.Text + "','" +
motherNameTextBox.Text + "','" +
mobile1TextBox.Text + "','" +
jobTextBox.Text + "','" +
addressTextBox.Text + "','" +
salaryTextBox.Text + "','" +
drillNameTextBox.Text + "','" +
drillStartDateTimePicker.Text + "','" +
drillEndDateTimePicker.Text + "','" +
drillSuitableCheckBox.Text + "','" +
drillNoteTextBox.Text + "','" +
stopedCheckBox.Text + "','" +
stopedReasonTextBox.Text + "','" +
bloodTypeComboBox.Text + "','" +
jobComboBox.Text + "','" +
GovernorateIDcomboBox.Text + "','" +
statusIDComboBox.Text + "','" +
stateIdComboBox.Text + "','" +
flagIdComboBox.Text + "','" +
DirectorialTextBox.Text + "','" +
detachmentIdComboBox.Text + "')", con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("تم اضافة البيانات بنجاح ");
رسالة الخطاء هي '('lncorrect syntax near
