cmInsert = new OleDbCommand("INSERT INTO Предметы(subject_name_rus, subject_name_eng) VALUES(@subject_name_rus, @subject_name_eng)", coJDiploma);
cmInsert.Parameters.Add(new OleDbParameter("@subject_name_rus", OleDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "subject_name_rus", DataRowVersion.Original, null));
cmInsert.Parameters.Add(new OleDbParameter("@subject_name_eng", OleDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "subject_name_eng", DataRowVersion.Original, null));
cmUpdate = new OleDbCommand("UPDATE Предметы SET subject_name_rus=@subject_name_rus AND subject_name_eng=@subject_name_eng WHERE id=@id", coJDiploma);
cmUpdate.Parameters.Add(new OleDbParameter("@id", OleDbType.Integer, 10, ParameterDirection.Input, false, 0, 0, "id", DataRowVersion.Original, null));
cmUpdate.Parameters.Add(new OleDbParameter("@subject_name_rus", OleDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "subject_name_rus", DataRowVersion.Original, null));
cmUpdate.Parameters.Add(new OleDbParameter("@subject_name_eng", OleDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "subject_name_eng", DataRowVersion.Original, null));
cmDelete = new OleDbCommand("DELETE * FROM Предметы WHERE id=@id", coJDiploma);
cmDelete.Parameters.Add(new OleDbParameter("@id", OleDbType.Integer, 10, ParameterDirection.Input, false, 0, 0, "id", DataRowVersion.Original, null));
daJDiploma.InsertCommand = cmInsert;
daJDiploma.UpdateCommand = cmUpdate;
daJDiploma.DeleteCommand = cmDelete;
|