Hi
I get the error in the title and the debugger points to Main.DA.Fill(Ma in.DT). I change the table in the query to another with similar format (ID-counter, Name-varchar) just for test, the code works. Given query also works independently in Access. What is it that I don't see?
Thanks
Code:
Main.Cmd.CommandText = "SELECT ID, NAME FROM NAMES;" Main.DA.SelectCommand = Main.Cmd Main.DT = New DataTable Main.DA.Fill(Main.DT) ComboBox3.DataSource = Main.DT ComboBox3.ValueMember = Main.DT.Columns.Item(0).ToString ComboBox3.DisplayMember = Main.DT.Columns.Item(1).ToString
Thanks