vb.net to access connection HELP

[timosilver]

Hello,

i have an access database (wwtbamDB.mdb) with Question1to5table, the table have the ID,Questions,Ans1,Ans2,Ans3,Ans4 column.
i want to display the content on the appropriate button on a windows form in vb.net.
Thanks for you help.

Public Class Form1 : Inherits System.Windows.Forms.Form    Dim cn As OleDbConnection
    Dim cmd As OleDbCommand
    Dim dr As OleDbDataReader
End Class


'to open and retrieve


 Try
            cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;_Data Source=C:\Users\Timosoft\Documents\wwtbamDB.mdb;")
            'provider to be used when working with access database
            cn.Open()
            cmd = New OleDbCommand("select * from Question1to5table", cn)
            dr = cmd.ExecuteReader
            While dr.Read()
                Main1.QuestnBTN1.Text = dr(Questions)
                Main1.Answerbtn1.Text = dr(Answer1)
                Main1.Answerbtn2.Text = dr(Answer2)
                Main1.Answerbtn3.Text = dr(Answer3)
                Main1.Answerbtn1.Text = dr(Answer4)
                ' loading data into TextBoxes by column index
            End While
        Catch
        End Try

[June7]

This is not an Access issue. You might post question in a .net forum. Consider: http://forums.aspfree.com/ or http://www.developerbarn.com/forum.php

[orange]

The ans1, ans2.... fields indicate you also have a table design issue.

[timosilver]

thanks for your reply am finally able to connect my access db to my vb.net project.
now i need help on how to fill the data item() at random to each of the buttons.


Answerbtn1
Answerbtn2
Answerbtn3
Answerbtn4


Main1.QuestnBTN1.Text = ds.Tables("QuestionsandAnswers").Rows(0).Item(1)


Main1.Answerbtn1.Text = ds.Tables("QuestionsandAnswers").Rows(0).Item(2)
Main1.Answerbtn2.Text = ds.Tables("QuestionsandAnswers").Rows(0).Item(4)
Main1.Answerbtn3.Text = ds.Tables("QuestionsandAnswers").Rows(0).Item(3)
Main1.Answerbtn4.Text = ds.Tables("QuestionsandAnswers").Rows(0).Item(5)

[June7]

Again, a VB.net, not Access, question.

Shouldn't data go in data controls (textbox, combobox, listbox), not a command button? Have no idea what you are trying to do.

[timosilver]

ok thanks