Ad:

VB.NET Discussion Thread
Marked Solved
Views: 3609

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Feb 3rd, 2009

Search value by textbox from .mdb file

Expand Post »

Hi Guys,

I'm really need help for this item, the situation is i got textbox1 as a input , button1 as searchbutton abd textbox2 to display the item that been enter in textbox1. All the table from .mdb

Can guide me plz

Similar Threads

IListSource does not contain any data sources in ASP.NET

kerek2

Reputation Points: 20

Solved Threads: 0

Junior Poster

Offline

113 posts
since Sep 2007

Permalink

Feb 3rd, 2009

Re: Search value by textbox from .mdb file

I really don't understand a thing about your question!

If you are asking for some help you really need to explain everything into details. We can't guess about what your goals are.....

Last edited by 4advanced; Feb 3rd, 2009 at 5:59 am.

4advanced

Reputation Points: 33

Solved Threads: 10

Junior Poster in Training

Offline

67 posts
since Nov 2008

Permalink

Feb 3rd, 2009

Re: Search value by textbox from .mdb file

Thank you for reply,

Actually i need do make one searchbox to search a data. It's make one textbox as inputbox, when click the button, it will refer to .mdb database table. and the result will display in another textbox. For inputbox just accept 10 character and the display will be name of person..can u guide me?

kerek2

Reputation Points: 20

Solved Threads: 0

Junior Poster

Offline

113 posts
since Sep 2007

Permalink

Feb 4th, 2009

Re: Search value by textbox from .mdb file

Do you already have your connection strings setup for the mdb? I will go with yes

are you sure that the search will only return one entry in the db? i would probably go with either a listbox or datagrid to display the returns.
this is a nice little tutorial for displaying data in a datagrid. http://www.vbdotnetheaven.com/Upload...aGridSamp.aspx all you will need to do is change the query.

vb.net Syntax (Toggle Plain Text)
Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select * from Customers", myConnection)
'to this
Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select * from Customers Where FirstName like " & me.txtsearch.text & "%", myConnection)
Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select * from Customers", myConnection)
'to this
Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select * from Customers Where FirstName like " & me.txtsearch.text & "%", myConnection)

ProfessorPC

Reputation Points: 31

Solved Threads: 29

Posting Whiz in Training

Offline

270 posts
since Dec 2007

Permalink

Feb 4th, 2009

Re: Search value by textbox from .mdb file

the connection string to mdb still stuck...i'm confuse where to start the coding...below button click or textbox?....plz help me

kerek2

Reputation Points: 20

Solved Threads: 0

Junior Poster

Offline

113 posts
since Sep 2007

Permalink

Feb 4th, 2009

Re: Search value by textbox from .mdb file

button click

ProfessorPC

Reputation Points: 31

Solved Threads: 29

Posting Whiz in Training

Offline

270 posts
since Dec 2007

Permalink

Feb 4th, 2009

Re: Search value by textbox from .mdb file

Then how to link from textbox to database.mdb?...plz can give me a sample for connection and search method?

kerek2

Reputation Points: 20

Solved Threads: 0

Junior Poster

Offline

113 posts
since Sep 2007

Permalink

Feb 4th, 2009

Re: Search value by textbox from .mdb file

At least you are pointing to the right directions at this moment. The questions you ask seem to me you are now in the right 'developer-mode' :=)

Professor can be right but it's up to you where to open the connection. In most cases, and esspecially for .Net, the connections are made when you want to query, update, insert or delete something from the database and close it when ready. Anyways, you still can open the connection whenever you want & close it whenever you want.

In the case of using Access as a backend database, you're out of many options. You got to remember that Access is a file-based database which means that if you query some tables, all the tables in the query are pulled over to the client and after that they are being queried (client side). With a lot of data, you can experience a lot of performance problems.

Pointing to your question: leave all database actions within the button_click, as ProfessorPC suggested. Take a look at this post http://www.daniweb.com/forums/thread172996.html and look for rapture's code examples on oledb connections etc....
Also ProfessorPC's example is a nice solution

Regards,
Richard
The Netherlands

4advanced

Reputation Points: 33

Solved Threads: 10

Junior Poster in Training

Offline

67 posts
since Nov 2008

Permalink

Feb 4th, 2009

Re: Search value by textbox from .mdb file

I'm already thry this code,but the result appear all the name,it not searching by id.....how to do that bro?....pls...

"Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

VB.NET Syntax (Toggle Plain Text)
'Create a connection to the database
Dim cn As OleDbConnection
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
Dim Sql As String
 
Try
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\Database1.mdb;")
'cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; _Data Source=D:\Database1.mdb;")
'provider to be used when working with access database
'cn.Open()
cmd = New OleDbCommand("SELECT * from UMP WHERE ", cn)
 
 
cn.Open()
 
 
 
 
dr = cmd.ExecuteReader
While dr.Read()
 
 
ListBox1.Items.Add(dr(2))
'TextBox1.Text = dr(2)
'TextBox2.Text = dr(1)
'TextBox3.Text = dr(2)
' loading data into TextBoxes by column index
End While
 
Catch ex As Exception
 
End Try
 
'dr.Close()
cn.Close()
 
End Sub
'Create a connection to the database
Dim cn As OleDbConnection
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
Dim Sql As String

Try
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\Database1.mdb;")
'cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; _Data Source=D:\Database1.mdb;")
'provider to be used when working with access database
'cn.Open()
cmd = New OleDbCommand("SELECT * from UMP WHERE ", cn)


cn.Open()




dr = cmd.ExecuteReader
While dr.Read()


ListBox1.Items.Add(dr(2))
'TextBox1.Text = dr(2)
'TextBox2.Text = dr(1)
'TextBox3.Text = dr(2)
' loading data into TextBoxes by column index
End While

Catch ex As Exception

End Try

'dr.Close()
cn.Close()

End Sub

Last edited by Ancient Dragon; Feb 5th, 2009 at 7:24 am. Reason: add code tags

kerek2

Reputation Points: 20

Solved Threads: 0

Junior Poster

Offline

113 posts
since Sep 2007

Permalink

Feb 4th, 2009

Re: Search value by textbox from .mdb file

use condition on your select statment.

Jx_Man

Reputation Points: 1182

Solved Threads: 392

Posting Sensei

Offline

3,138 posts
since Nov 2007

Page 1
2
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Datagrid MS Access and VB.Net

Next Thread in VB.NET Forum Timeline: DateTime field - How do I assign a time other than current?

DaniWeb Message

Cancel Changes

User Name
Password