Display data

[tigger]

Hi there,
I need to get values from Access database and bind it to ThresholdLabel. I could not use the drag and drop method because i want the data to be displayed during button click event, not when the form loads. I have a field called AC250L from Threshold Database. So how do i go about doing that?

[hariharanmca]

Hi there,
I need to get values from Access database and bind it to ThresholdLabel. I could not use the drag and drop method because i want the data to be displayed during button click event, not when the form loads. I have a field called AC250L from Threshold Database. So how do i go about doing that?

Is it possible to explain your problem in point by point..

[tigger]

Is it possible to explain your problem in point by point..

Hey sorry for not making myself clear. My main aim is to select a name from the combo box and when i click a button(getButton), it will display the threshold value for that particular person. I've managed to display the values on a label. Here's my code..

Imports System.Data
Imports System.Data.OleDb
Imports System.IO

Public Class DatabaseProject


Private Sub DatabaseProject_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'Actual_DatabaseDataSet.Threshold_Database' table. You can move, or remove it, as needed.
Me.Threshold_DatabaseTableAdapter.Fill(Me.Actual_D atabaseDataSet.Threshold_Database)

End Sub

Private Sub getButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles getButton.Click, AC250LLabel1.Click

Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As New OleDb.OleDbDataAdapter
Dim sql As String
Dim cmd As OleDb.OleDbCommand

con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\BIE\Actual Database.mdb;Jet OLEDB:Database Password=****"
sql = "SELECT * FROM ThresholdDatabase"

con.Open()

cmd = New OleDb.OleDbCommand(sql, con)
Dim dataAdapter As New OleDb.OleDbDataAdapter(cmd)
dataAdapter.Fill(ds, "YourTableName")

Me.NameComboBox.DataSource = ds.Tables("Threshold Database")

da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "Actual_Database")

con.Close()

thresholdLabel.Text = ds.Tables("Actual_Database").Rows(6).Item("AC250L" ) & "dB"

End Sub

End Class

However, when i display the data, i have to manually type which row and which item i want to retrieve it from. I don't know how to link it to my combo box. Thanks.

[hariharanmca]

Hey sorry for not making myself clear. My main aim is to select a name from the combo box and when i click a button(getButton), it will display the threshold value for that particular person. I've managed to display the values on a label. Here's my code..

Imports System.Data
Imports System.Data.OleDb
Imports System.IO

Public Class DatabaseProject


Private Sub DatabaseProject_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'Actual_DatabaseDataSet.Threshold_Database' table. You can move, or remove it, as needed.
Me.Threshold_DatabaseTableAdapter.Fill(Me.Actual_D atabaseDataSet.Threshold_Database)

End Sub

Private Sub getButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles getButton.Click, AC250LLabel1.Click

Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As New OleDb.OleDbDataAdapter
Dim sql As String
Dim cmd As OleDb.OleDbCommand

con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\BIE\Actual Database.mdb;Jet OLEDB:Database Password=****"
sql = "SELECT * FROM ThresholdDatabase"

con.Open()

cmd = New OleDb.OleDbCommand(sql, con)
Dim dataAdapter As New OleDb.OleDbDataAdapter(cmd)
dataAdapter.Fill(ds, "YourTableName")

Me.NameComboBox.DataSource = ds.Tables("Threshold Database")

da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "Actual_Database")

con.Close()

thresholdLabel.Text = ds.Tables("Actual_Database").Rows(6).Item("AC250L" ) & "dB"

End Sub

End Class

However, when i display the data, i have to manually type which row and which item i want to retrieve it from. I don't know how to link it to my combo box. Thanks.

I am not sure that you mean this. Let me assume

You want to select a particular name in combo box text area

so

sql = "SELECT * FROM ThresholdDatabase" 

just change this qry to

sql = "SELECT * FROM ThresholdDatabase where AC250L like ‘" & trim(ComboboxName.Text) & “’”

and

thresholdLabel.Text = ds.Tables("Actual_Database").Rows(0).Item("AC250L") & "dB"

[tigger]

I am not sure that you mean this. Let me assume

You want to select a particular name in combo box text area

so

sql = "SELECT * FROM ThresholdDatabase" 

just change this qry to

sql = "SELECT * FROM ThresholdDatabase where AC250L like ‘" & trim(ComboboxName.Text) & “’”

and

thresholdLabel.Text = ds.Tables("Actual_Database").Rows(0).Item("AC250L") & "dB"

Hey thanks for the reply. I tried putting in the query but it seems to have an error.
da.Fill(ds, "Actual_Database") is highlighted and it says "Syntax error in FROM clause."

[hariharanmca]

Hey thanks for the reply. I tried putting in the query but it seems to have an error.
da.Fill(ds, "Actual_Database") is highlighted and it says "Syntax error in FROM clause."

ThresholdDatabase is a table name?

because, the select Qurey will be like

select <field1>, <field2>, <field3>, <field4> from <Table Name> where <Condition>

[tigger]

ThresholdDatabase is a table name?

because, the select Qurey will be like

select <field1>, <field2>, <field3>, <field4> from <Table Name> where <Condition>

I've already managed to solve the problem. Thanks. But i faced another problem. Each time i select a name in the combo box, it will appear twice and the previous name disappears. For example, i select John and click a button to display a value. When i go back to the combo box and want to select another name, i realized that John's name will appear twice. And the name before John will disappear.

[hariharanmca]

I've already managed to solve the problem. Thanks. But i faced another problem. Each time i select a name in the combo box, it will appear twice and the previous name disappears. For example, i select John and click a button to display a value. When i go back to the combo box and want to select another name, i realized that John's name will appear twice. And the name before John will disappear.

I think the problem is with Load event of combo box. (if no problem, you can post it and let me Look-over to solve).

[tigger]

I think the problem is with Load event of combo box. (if no problem, you can post it and let me Look-over to solve).

I don't face the problem anymore. Thanks a lot for your help. Appreciate it =)

[Killer42]

I don't face the problem anymore. Thanks a lot for your help. Appreciate it =)

Could you fill us in briefly on how you resolved it? This could be useful if someone else comes along with the same problem. (Don't worry if it's something silly - we've all been there.)