Click here to Skip to main content
15,887,477 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: How to search and show with Text Box from Access Database in VB.Net 2010? Pin
Maciej Los9-Oct-14 11:10
mveMaciej Los9-Oct-14 11:10 
AnswerRe: How to search and show with Text Box from Access Database in VB.Net 2010? Pin
Otekpo Emmanuel9-Oct-14 14:16
Otekpo Emmanuel9-Oct-14 14:16 
Try this out!
At the top most of your code window, type these name spaces
Import System.Data
Import System.Data.Oledb
double click on the search button and type or copy the below code
Dim con As New Oledb.OledbConnection("Provider=Microsoft.Ace.Oledb.12.0; Data Source = theDatabasePath")
Dim cmd As New Oledb.OledbCommand("select * from tblname where srchName = @srchName", con)
cmd.Parameters.AddWithValue("@srchName", txtsrch.Text)
Dim dr As Oledb.OledbDataReader = cmd.ExecuteReader
if dr.HasRows Then
dr.Read()
txtresult.Text = dr("srchName")
else
MsgBox("Name not found")
End if
dr.Close
cmd.Dispose
con.Dispose
con.Close
//////
Explanation
the srchName, I assumed to be your field name.
Table name is the name you gave your table at the backend
databasepath is the path that lead to your database. You can get the db path by right clicking on the database tehen select properties
GeneralRe: How to search and show with Text Box from Access Database in VB.Net 2010? Pin
Kelven DeJaVu11-Oct-14 6:08
Kelven DeJaVu11-Oct-14 6:08 
QuestionDataAnnotations - Multiple Acceptable Values Pin
Dominick Marciano8-Oct-14 7:32
professionalDominick Marciano8-Oct-14 7:32 
AnswerRe: DataAnnotations - Multiple Acceptable Values Pin
Richard Deeming9-Oct-14 22:45
mveRichard Deeming9-Oct-14 22:45 
GeneralDroptiles Pin
KokDavy8-Oct-14 4:58
KokDavy8-Oct-14 4:58 
GeneralRe: Droptiles Pin
Tim Carmichael8-Oct-14 7:27
Tim Carmichael8-Oct-14 7:27 
QuestionCompare tables and show the difference Pin
byka8-Oct-14 2:35
byka8-Oct-14 2:35 
AnswerRe: Compare tables and show the difference Pin
Praneet Nadkar8-Oct-14 2:51
Praneet Nadkar8-Oct-14 2:51 
GeneralRe: Compare tables and show the difference Pin
byka8-Oct-14 3:08
byka8-Oct-14 3:08 
GeneralHighchart server side settings and update Pin
KokDavy6-Oct-14 13:09
KokDavy6-Oct-14 13:09 
GeneralRe: Highchart server side settings and update Pin
Dave Kreskowiak6-Oct-14 17:43
mveDave Kreskowiak6-Oct-14 17:43 
QuestionThe state value of an object ? Pin
dilkonika4-Oct-14 16:52
dilkonika4-Oct-14 16:52 
AnswerRe: The state value of an object ? Pin
Dave Kreskowiak4-Oct-14 18:53
mveDave Kreskowiak4-Oct-14 18:53 
GeneralRe: The state value of an object ? Pin
dilkonika5-Oct-14 3:39
dilkonika5-Oct-14 3:39 
GeneralRe: The state value of an object ? Pin
Dave Kreskowiak5-Oct-14 5:00
mveDave Kreskowiak5-Oct-14 5:00 
QuestionAdding records and save changes simultaneosly for 2 tables Pin
dilkonika3-Oct-14 11:04
dilkonika3-Oct-14 11:04 
AnswerRe: Adding records and save changes simultaneosly for 2 tables Pin
Eddy Vluggen3-Oct-14 12:49
professionalEddy Vluggen3-Oct-14 12:49 
AnswerRe: Adding records and save changes simultaneosly for 2 tables Pin
Eddy Vluggen6-Oct-14 9:12
professionalEddy Vluggen6-Oct-14 9:12 
Questioni want add/edit/delete access table in database on vb2010 Pin
Member 105203861-Oct-14 1:01
Member 105203861-Oct-14 1:01 
AnswerRe: i want add/edit/delete access table in database on vb2010 Pin
Richard MacCutchan1-Oct-14 4:37
mveRichard MacCutchan1-Oct-14 4:37 
SuggestionRe: i want add/edit/delete access table in database on vb2010 Pin
ZurdoDev2-Oct-14 5:00
professionalZurdoDev2-Oct-14 5:00 
QuestionMove a file according to a name inside the file itself. Pin
val566230-Sep-14 19:08
val566230-Sep-14 19:08 
AnswerRe: Move a file according to a name inside the file itself. Pin
Eddy Vluggen2-Oct-14 4:44
professionalEddy Vluggen2-Oct-14 4:44 
QuestionProblem with entity objects after refreshing model from database Pin
dilkonika30-Sep-14 11:34
dilkonika30-Sep-14 11:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.