 |  |  |  |  |  |  |  |
search code not working!!!
Please support our VB.NET advertiser: Intel Parallel Studio Home
 |
any1 help, basically iv wrote the code to search for a client name in a database(in access) and this is the code: but it underlines the "OleDbDataAdapter1" in the but i dont know why as that is what my dataAdapter is called??
please help, id be very grateful!!!!!
•
•
•
•
Private Sub BtnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
'search
If txtSearch.Text = "" Then MsgBox("Please type Client Name", MsgBoxStyle.Critical, "Enter Text") : Exit Sub
Dim MYDA As OleDbDataAdapter1 = New OleDbDataAdapter()
Dim MYDS As DataSet = New DataSet()
RS = New ADODB.Recordset()
RS.Open("SELECT * FROM CLIENT WHERE NAME LIKE '" & txtSearch.Text & "%' ", CN, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic)
MYDA.Fill(MYDS, RS, "NAME")
DataGrid1.DataSource = MYDS.Tables(0)
End Sub
End Class
•
•
•
•
Dim MYDA As OleDbDataAdapter1 =. .......
please help, id be very grateful!!!!!
Last edited by shelly121; Mar 1st, 2005 at 10:49 am. Reason: mistype
•
•
Join Date: Mar 2005
Posts: 65
Reputation: 
Solved Threads: 0
Junior Poster in Training
Try adding these imports statements at the top before anything else:
Imports System()
Imports System.Data()
Imports System.Data.Oledb()
If you do not add those imports statements, then when you declare your dataadapter you will have to do something like this:
Dim MYDA As System.Data.Oledb.OleDbDataAdapter1 = New OleDbDataAdapter()
Chester
Imports System()
Imports System.Data()
Imports System.Data.Oledb()
If you do not add those imports statements, then when you declare your dataadapter you will have to do something like this:
Dim MYDA As System.Data.Oledb.OleDbDataAdapter1 = New OleDbDataAdapter()
Chester
hey thanks CPOPHAM for replyin, i have actually sorted out all of the problems i had, but am grateful fo ya help anyway!!
•
•
Join Date: Mar 2005
Posts: 65
Reputation:
Solved Threads: 0
Junior Poster in Training
I am glad that you got everything to work out. I just joined the forums.
Chester
Chester
•
•
•
•
Originally Posted by shelly121 
any1 help, basically iv wrote the code to search for a client name in a database(in access) and this is the code:
but it underlines the "OleDbDataAdapter1" in the but i dont know why as that is what my dataAdapter is called??
please help, id be very grateful!!!!!
in your adodc properties, find the tab that contains the cmdunknown, i can't remember exactly where that place is...
then check SQl and type:
Select * from (name of table of the database)
ex Select * from emp
this makes the form connected to the database...
then create a textbox which you will input the search word
next, create a search command button...
type this command to be executed...
"Select * from (name of table) where (name of data to be seached eg. REG_NO) like '" & txtSEARCH.Text & "%" & "'"
this makes the program search the word which contains the words or letters that is in the text box...
i hope i helped you...
|
Similar Threads
- Search code in a database (Visual Basic 4 / 5 / 6)
- CHECKBOX VAILDATION CODE not working (PHP)
- ADODC Search code (Visual Basic 4 / 5 / 6)
- I would liike to multiply two matrices but my code is not working..help me out! (C++)
- Can some one help me with this code plz (Visual Basic 4 / 5 / 6)
- search bar not working (Windows NT / 2000 / XP)
Other Threads in the VB.NET Forum
- Previous Thread: Plese Help me in Threading
- Next Thread: locating remote machine name
| Thread Tools | Search this Thread |
Latest VB.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for VB.NET
.net .net2008 2008 access advanced application array basic beginner browser button buttons center click client code combo convert cuesent data database datagrid datagridview date datetimepicker designer dissertation dissertations dissertationtopic eclipse excel exists fade filter forms function html images input lib listview map mobile module monitor msaccess net number objects open panel pdf picturebox picturebox2 port position print printing problem read regex remove right-to-left save search serial settings shutdown socket sorting sqldatbase sqlserver survey temperature textbox timer timespan transparency txttoxmlconverter user usercontol validation vb vb.net vb2008 vba vbnet visual visualbasic visualbasic.net visualstudio.net visualstudio2008 web webbrowser winforms winsock wpf wrapingcode xml year
