| Код |
String str = "Provider=Microsoft.JET.OLEDB.4.0; Data Source=" + Form1.s + "\\Data1.mdb;Jet OLEDB:Database ";
OleDbConnection conn = new OleDbConnection(str);
conn.Open();
OleDbCommand thisCommand = conn.CreateCommand();
thisCommand.CommandText = "INSERT INTO TClient(id_c,CName,CInfo,OrderNum) VALUES("+Form1.id+",'" + Client.Text + "','" + textBox17.Text + "','"+Order.Text+"')";
thisCommand.ExecuteNonQuery();
thisCommand.CommandText = "INSERT INTO TOrders(id_c,Price,Club,date1,date2,NumberOfWeeks,doc_date,mem) VALUES("+Form1.id+","+textBox2.Text+",'"+Club.Text+"','"+From.Value.ToShortDateString()+"','"+To.Value.ToShortDateString()+"',"+textBox3.Text+",'"+DateTime.Today.Date.ToShortDateString()+"',"+0+")";
thisCommand.ExecuteNonQuery();
thisCommand.CommandText = "INSERT INTO TSecClient(id_c,sc_pass,sc_date,sc_mar,sc_tel,sc_job,sc_name) VALUES("+Form1.id+",'"+textBox12.Text+"','"+dateTimePicker4.Value.ToShortDateString()+"','"+textBox11.Text+"',"+textBox9.Text+",'"+textBox10.Text+"','"+textBox13.Text+"')";
thisCommand.ExecuteNonQuery();
OleDbCommand thisCommand2 = conn.CreateCommand();
thisCommand2.CommandText = "INSERT INTO TFamily(id_c,FName,BirthDate,FPass) VALUES("+Form1.id+",'"+textBox15.Text+"','"+dateTimePicker7.Value.ToShortDateString()+"','"+textBox16.Text+"')";
thisCommand2.ExecuteNonQuery();
if (textBox20.Text != "")
{
thisCommand2.CommandText = "INSERT INTO TFamily(id_c,FName,BirthDate,FPass) VALUES(" + Form1.id + ",'" + textBox20.Text + "','" + dateTimePicker6.Value.ToShortDateString() + "','" + textBox19.Text + "')";
thisCommand2.ExecuteNonQuery();
}
if (textBox23.Text != "")
{
thisCommand2.CommandText = "INSERT INTO TFamily(id_c,FName,BirthDate,FPass) VALUES(" + Form1.id + ",'" + textBox23.Text + "','" + dateTimePicker5.Value.ToShortDateString() + "','" + textBox22.Text + "')";
thisCommand2.ExecuteNonQuery();
}
thisCommand.CommandText = "INSERT INTO TClientData(id_c,PassNum,BirthDate,MarStatus,Tel,Job) VALUES(" + Form1.id + ",'" + textBox5.Text + "','" + dateTimePicker3.Value.ToShortDateString() + "','" + textBox6.Text +"','"+textBox8.Text+"','"+textBox7.Text+"')";
thisCommand.ExecuteNonQuery();
conn.Close();
|
Собственно само место где ошибка вываливается. Помогите пожалуйста разобраться. |