Nicodemas

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim surname As DataColumn
Dim otherNames As DataColumn
Dim connection As SqlConnection = New SqlConnection("server=olaolu\SQLEXPRESS;database=D epartment Database;integrated security=true")
Try
Dim command As SqlCommand = New SqlCommand("INSERT INTO Student info ([SurName], [OtherNames]) VALUES (@SurName, @OtherNames)", connection)
command.Parameters.Add(New SqlParameter("@surname", surname.DataType))
command.Parameters.Add(New SqlParameter("@OtherNames", OtherNames.DataType))
connection.Open()
command.ExecuteNonQuery()
connection.Close()
Finally
If connection.State = ConnectionState.Open Then
connection.Close()
End If
End Try

a null reference exception results pls edit these codes 4 me.thanks