Click here to Skip to main content
15,891,905 members

how to look for a field in different tables in vb.net using query

tacky0 asked:

Open original thread
I Have a query in which i want to search in all the table for a common field using query below ismy code----

VB
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
     Try
         'Dim da As OleDb.OleDbDataAdapter
         Dim dbprovider As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Taher\Documents\Visual Studio 2010\Projects\WindowsApplication1\WindowsApplication1\Database1.accdb;Persist Security Info=False;"
         Me.con = New OleDb.OleDbConnection
         Dim sqlquery As String = "SELECT * FROM **mba mca mscit** WHERE urno='" & TextBox2.Text & "';"
         Dim command As New OleDb.OleDbCommand(sqlquery, con)
         Dim reader As OleDb.OleDbDataReader
         con.ConnectionString = dbprovider
         con.Open()

         reader = command.ExecuteReader()
         reader.Read()
         TextBox1.Text = reader(1).ToString
         TextBox2.Text = reader(2).ToString
         TextBox3.Text = reader(3).ToString
         TextBox4.Text = reader(4).ToString
         TextBox5.Text = reader(5).ToString
     Catch ex As Exception
         MsgBox("Not Found")
         con.Close()
     End Try


i want to search for urno in all the tables which have the fields in them with the same name....?
Tags: Visual Basic, SQL

Plain Text
ASM
ASP
ASP.NET
BASIC
BAT
C#
C++
COBOL
CoffeeScript
CSS
Dart
dbase
F#
FORTRAN
HTML
Java
Javascript
Kotlin
Lua
MIDL
MSIL
ObjectiveC
Pascal
PERL
PHP
PowerShell
Python
Razor
Ruby
Scala
Shell
SLN
SQL
Swift
T4
Terminal
TypeScript
VB
VBScript
XML
YAML

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
  4. Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.
Let's work to help developers, not make them feel stupid.
Please note that all posts will be submitted under the http://www.codeproject.com/info/cpol10.aspx.



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900