Need Help, Database click event

[Fritztrocity1]

I need to have Labels pull up a row of information from my database when clicked on. Whats the most simple code to accomplish that?

[Hack]

What database are you using and what version of .NET are you using?

[formlesstree4]

Depends.

[Fritztrocity1]

VB 2012 and an access document

[formlesstree4]

VB 2012 and an access document

Did you do any searching online, say, Bing, Google, or Yahoo? Do you have any sample code?

[Fritztrocity1]

I have. I have some code for the label to click, but it doesnt pull up a window with the database information, and im pretty sure it wont just pull up the row i want, it will pull up the whole database which I dont want.

Private Sub Label1_Click(sender As Object, e As EventArgs) Handles Label1.Click

dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;"
dbSource = "Data Source = R:/DBASE/compn.mdb"

con.ConnectionString = dbProvider & dbSource

con.Open()

sql = "SELECT * FROM Computer"
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "compn")

End Sub

[formlesstree4]

Well yeah, your query is doing exactly what it's been told to do: Give me everything from 'Computer'. What are you expecting it to do?

[Fritztrocity1]

to pull a row with the matching number I click from the database

[kaliman79912]

I dont quite understand. Do you have a set of fixed labels with numbers, and when you click one of those you want to display the single record of the database that matches that number?

[Fritztrocity1]

yep thats what im looking for

[kaliman79912]

If you are coding it something like the example you gave, change the SQL Statement to include the WHERE clause. It would be something like;

SELECT * FROM Computer WHERE keyField = Label.Text

Of course this is just a direction to take, cant use controls inside the SQL Statement and you should use parameters. But following this could get you there.

[Fritztrocity1]

Do I need to add a MsgBox code in order for a window to pop up when i click the label?