The second best thing about doing it correctly (use parameters, not concatenated strings) is that you don't have to worry about all the quotes and single quotes; and it makes it a lot cleaner and easier to check the values.
Five minutes of my time went into this parameterized version:
cmd = "INSERT into Patient values(@CourseID, @CourseName, @Description, @CreditHour)";
string CourseID = getCourseID();
string CourseName = getCourseName();
string Description = getDescription();
int CreditHour = getCreditHour();
OleDbDataAdapter2.InsertCommand.CommandText = cmd;
OleDbDataAdapter2.InsertCommand.Connection = OleDbConnection2;
OleDbDataAdapter2.InsertCommand.Parameters.AddWithValue("@CourseID", CourseID);
OleDbDataAdapter2.InsertCommand.Parameters.AddWithValue("@CourseName", CourseName);
OleDbDataAdapter2.InsertCommand.Parameters.AddWithValue("@Description", Description);
OleDbDataAdapter2.InsertCommand.Parameters.AddWithValue("@CreditHour", CreditHour);