i'd been trying and still can't find out what is wrong with this... need help from you guys.. i am useing combo box..
{} = where the error is
Error" = The column name is not valid. [ Node name (if any) = ,Column name = S9021292C ]"
CODE
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
conn.Open()
Dim sql As String = "SELECT * FROM Data123 WHERE [NRIC]=" & ComboBox1.Items(ComboBox1.SelectedIndex)
Dim cmd As New SqlCeCommand(sql, conn)
Dim { reader As SqlCeDataReader = cmd.ExecuteReader }
While reader.Read()
txtfirstname.Text = reader.Item("Firstname")
txtlastname.Text = reader.Item("Lastname")
txtage.Text = reader.Item("Age")
txtdob.Text = reader.Item("DOB")
txtaddress.Text = reader.Item("Address")
txtpostalcode.Text = reader.Item("PostalCode")
txtcontact.Text = reader.Item("Contact")
txtemail.Text = reader.Item("Email")
End While
conn.Close()
End Sub
This post has been edited by dingo190: 14 Oct, 2008 - 10:23 PM
| 