elahe1393
شنبه 05 مهر 1393, 16:37 عصر
این تابع وقتی اجرا میشه تو بخش ocm.ExecuteNonQuery(); خطای syntax error میده مشکل کجاست چندین بار کوئری رو از جهت syntax بررسی کردم مشکلی ندیدم!
public void InsertDataReport(string reportID, string patientCode, string date, string startTime, string endTime, string sportDeviceSetting)
{
OleDbConnection ocn = new OleDbConnection();
OleDbCommand ocm = new OleDbCommand();
ocn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + "\\SportDatabase.accdb";
ocm.Connection = ocn;
ocm.CommandText = "INSERT INTO Report(ReportID,PatientCode,Date,StartTime, EndTime, SportDeviceSetting) VALUES(reportID,patientCode,date,startTime, endTime, sportDeviceSetting)";
ocm.Parameters.Clear();
ocm.Parameters.AddWithValue("ReportID", reportID);
ocm.Parameters.AddWithValue("PatientCode", patientCode);
ocm.Parameters.AddWithValue("Date", date);
ocm.Parameters.AddWithValue("StartTime", startTime);
ocm.Parameters.AddWithValue("EndTime", endTime);
ocm.Parameters.AddWithValue("SportDeviceSetting", sportDeviceSetting);
ocn.Open();
ocm.ExecuteNonQuery();
ocn.Close();
ocm.Dispose();
ocn.Dispose();
}
public void InsertDataReport(string reportID, string patientCode, string date, string startTime, string endTime, string sportDeviceSetting)
{
OleDbConnection ocn = new OleDbConnection();
OleDbCommand ocm = new OleDbCommand();
ocn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Application.StartupPath + "\\SportDatabase.accdb";
ocm.Connection = ocn;
ocm.CommandText = "INSERT INTO Report(ReportID,PatientCode,Date,StartTime, EndTime, SportDeviceSetting) VALUES(reportID,patientCode,date,startTime, endTime, sportDeviceSetting)";
ocm.Parameters.Clear();
ocm.Parameters.AddWithValue("ReportID", reportID);
ocm.Parameters.AddWithValue("PatientCode", patientCode);
ocm.Parameters.AddWithValue("Date", date);
ocm.Parameters.AddWithValue("StartTime", startTime);
ocm.Parameters.AddWithValue("EndTime", endTime);
ocm.Parameters.AddWithValue("SportDeviceSetting", sportDeviceSetting);
ocn.Open();
ocm.ExecuteNonQuery();
ocn.Close();
ocm.Dispose();
ocn.Dispose();
}