Casting Error?? [RESOLVED]

[SaitStudent]

What i am trying to do is load a combo box on a form frmStudents. The way i am going about doing it is my frmstudent on load event has this code

Private stu As Student
    Private Sub frmDisplayStudent_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        stu = New Student
        cboStudents.DataSource = stu.GetStudents
        cboStudents.DisplayMember = "FIRSTNAME"
    End Sub

stu calls to class Student which as a function of GetStudents which does this

Public Function GetStudents() As ArrayList
 
        conn = New SqlConnection(connstring)
        Dim sql As String = "SELECT * FROM Student"
        comm = New SqlCommand(sql, conn)
        Dim stu As New Student
        Dim students As New ArrayList
 
        conn.Open()
        Dim reader As SqlDataReader = comm.ExecuteReader(CommandBehavior.CloseConnection)
 
        Do While reader.Read
            stu = New Student(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), _
                                reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7))
            students.Add(stu)
        Loop
        reader.Close()
        conn.Close()
 
        Return students
    End Function

When i try to load the form it says i have a casting error? specifically "Specified cast is not valid."

[SaitStudent]

o and i am using sqlServer 2005 and visual studio 2005, code is in VB

[disruptivehair]

o and i am using sqlServer 2005 and visual studio 2005, code is in VB

Hmm...this is just a guess since I don't use VB.NET but maybe you're using .GetString on something that isn't a string, or .GetInt32 on something that isn't an integer. I'd check the data types of the 'Student' table against your code to make sure you're using the right methods, though I've found .GetString doesn't seem to care about the data type so I may just be talking out of my rear end.

[SaitStudent]

Yes it was thank you i was using int32 instead of int64

[disruptivehair]

Yes it was thank you i was using int32 instead of int64

Woo, yay! Can you mark the thread as resolved?