Click here to Skip to main content
15,867,686 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: windows service, event log message file Pin
Eddy Vluggen10-Oct-14 8:12
professionalEddy Vluggen10-Oct-14 8:12 
AnswerRe: windows service, event log message file Pin
Richard Deeming9-Oct-14 22:47
mveRichard Deeming9-Oct-14 22:47 
GeneralRe: windows service, event log message file Pin
jkirkerx10-Oct-14 7:10
professionaljkirkerx10-Oct-14 7:10 
AnswerRe: windows service, event log message file, the mc file [SOLVED] Pin
jkirkerx14-Oct-14 10:56
professionaljkirkerx14-Oct-14 10:56 
QuestionHow to search and show with Text Box from Access Database in VB.Net 2010? Pin
Kelven DeJaVu8-Oct-14 16:14
Kelven DeJaVu8-Oct-14 16:14 
AnswerRe: How to search and show with Text Box from Access Database in VB.Net 2010? Pin
Richard MacCutchan8-Oct-14 21:45
mveRichard MacCutchan8-Oct-14 21:45 
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 

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.