How to show access database value in textbox

[gayzlein]

Hello, i need a code to show data from database into textbox
i have this request
"select count(*) from table"
i work with access database andi want show the result in textbox
pleaase help

[kRod]

Have you written anything yet? You should read this post http://www.daniweb.com/software-development/vbnet/threads/460782/help-with-accessing-data-from-an-ms-access-database-with-vb

[G_Waddell]

Hi
You should look up the OLEDBConnection Class to find out how to run SQL against a Database through OLEDB (as opposed to SQL Server).

To connect to the Access database through the OLEDBConnection Class, you will need a connection string to connect to Access

This should get you started - there are loads of examples of code both in MSDN and other VB.NET sites as well as examples and snippits on this very forum.

[gayzlein]

thank you kRod, G WAddel, i know how to link vb.net with access database, but i can't show data from database into textbox, since i can show data in datagreadview.thank you for help

[kRod]

What value are you trying to put into the textbox? What column and row in the underlying dataSource is it in ? Do you need to search the dataSource for the value or does your query select a single value --- 'Command.ExecuteScalar' As you can see there is a lot of info we would need to answer your question. Showing the code that retrieves the data would help alot....

[gayzlein]

my database contains a table of products with five columns: ID, Reference, quantity,the turnover, and categories, I want to show in textboxes the number of references that match a category, the sum of quantities.ofcourse my query select a single value.
I just write the class of connection I have not write any code for textboxes

[kRod]

TextBox1.Text = Cstr(Value from the Query)

[gayzlein]

Hello kRod, I found the solution, that's it: the message box return the result of my query, but the problem that i can't retrieve this result in my texbox, when my program is running, an error message appears: "impossible to change the property Connection String"

Private Sub TextBox4_TextChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox4.TextChanged
        dbProvider = "Provider=Microsoft.ACE.OLEDB.12.0;"
        dbSource = "Data Source=C:\Users\Gayzlein\Documents\Gestion.accdb"
        con.ConnectionString = dbProvider & dbSource
        con.Open()
               Dim cmd As New OleDb.OleDbCommand("select count(*) from Categories1 where classe='A'", con)
        Dim count As Int32 = CInt(cmd.ExecuteScalar)
        MsgBox(count)
        TextBox4.Text = cstr(count)
    con.Close()

Thanks kRod

[gayzlein]

Yes, I found it, I just have to write the same code in "private sub form_load.." Thanks for help.