ADO.NET VB2008 - Adding Text with ' in it.

[Wesley008]

Hmm, Oki, New Problem with the statement I used:

Heres my Code:

SQL = "INSERT INTO [Course_" & CourseName & "] (Gender, HomeRoom, StudentNumber) VALUES ('" & TempGender & "','" & DR("Home Room/Form") & "','" & DR("Special Use") & "')"
                        Command = New OleDbCommand(SQL, Connection)
                        Command.Parameters.AddWithValue("LastName", DR("Last Name"))
                        Command.Parameters.AddWithValue("FirstName", DR("First Name"))
                        Command.Connection.Open()
                        Command.ExecuteNonQuery()
                        Command.Connection.Close()

When I exit out of the Program & then Open it back Up, It then Loads up the Data in the DB File, But for some reason, their all

,

And For that Reason, its because its not Adding to Database, It adds everything else except the first and last name