Sql Server Stored Procedures, Just One Thing After Another

 In a previous post, someone helped me with creating stored procedures, and I am grateful because I am transitioning from the Access World.

Anyway, I get an error at .ExecuteNonQuery in visual studio 2005 when I run the following code: 

Dim strsql As String
        Dim strconn As String
        strsql = "sp_Roster"
        strconn = "server=xxxx; user=xxxx; pwd=xxxx; database=xxxx;"
        With comm
            .Connection = New SqlConnection(strconn)
            .CommandText = strsql
            .CommandType = CommandType.StoredProcedure
            With .Parameters.Add("TeacherID", SqlDbType.Char)
                .Value = "DawsMark@aol.com"
            End With
            With .Parameters.Add("ClassID", SqlDbType.Int)
                .Value = classid
            End With
            With .Parameters.Add("sID", SqlDbType.Int)
                .Value = ssID
            End With
            With .Parameters.Add("sLastName", SqlDbType.Char)
                .Value = lastname
            End With
            With .Parameters.Add("sFirstName", SqlDbType.Char)
                .Value = firstname
            End With
            With .Parameters.Add("sMiddleName", SqlDbType.Char)
                .Value = middlename
            End With
            With .Parameters.Add("Student", SqlDbType.Char)
                .Value = fullname
            End With
            With .Parameters.Add("Password", SqlDbType.Char)
                .Value = password
            End With
            .Connection.Open()
            .ExecuteNonQuery()
            With comm.Connection
                If .State = ConnectionState.Open Then
                    .Close()
                End If
            End With
        End With

The error was:  Error converting data type char to int.

The stored procedure in sql server was as follows 

CREATE PROCEDURE sp_Roster
    -- Add the parameters for the stored procedure here
@TeacherID varchar(50),

@ClassID  int,

@sID int,

@sLastName varchar(50),

@sFirstName varchar(50),

@sMiddleName varchar(50),

@Student varchar(50),

@Password varchar(50)

AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    INSERT INTO Roster (TeacherID, ClassID, sID, sLastName, sFirstName, sMiddleName, Student, Password) VALUES (@TeacherID, @ClassID, @sID, @sLastName, @sFirstName, @sMiddleName, @Student, @Password)
END
GO

The error also says "sqlexception was unhandled by user code.

This is strange because this code worked perfectly when connecting to Access and when I used oledb. 

So how is it the code's problem?  Is the stored procedure causing the error or the code.  Can someone please help. thanks.
 

<Edited by Dinakar Nethi>

Please mask your useird/pwd info in the connection string when posting to a public forum like this

</Edit>