VB.NET

Welcome to Dream.In.Code
	Become a VB.NET Expert! Join 308,429 VB.NET Programmers for FREE! Get instant access to thousands of VB.NET experts, tutorials, code snippets, and more! There are 3,226 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a VB.NET Expert

help vb window mobile

dingo190	14 Oct, 2008 - 10:10 PM Post #1
New D.I.C Head Joined: 26 Feb, 2008 Posts: 6	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
	This Post Was Helpful!