Click here to Skip to main content
15,898,134 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Windows XP remote connection limit. Pin
Dave Kreskowiak20-Aug-07 2:19
mveDave Kreskowiak20-Aug-07 2:19 
QuestionSorting Pin
CyberSamuraiii19-Aug-07 22:26
CyberSamuraiii19-Aug-07 22:26 
AnswerRe: Sorting Pin
originSH19-Aug-07 22:32
originSH19-Aug-07 22:32 
GeneralRe: Sorting Pin
CyberSamuraiii19-Aug-07 23:00
CyberSamuraiii19-Aug-07 23:00 
GeneralRe: Sorting Pin
originSH20-Aug-07 0:06
originSH20-Aug-07 0:06 
QuestionCrystal report Pin
sweehin1819-Aug-07 21:22
sweehin1819-Aug-07 21:22 
AnswerRe: Crystal report Pin
Sipder19-Aug-07 23:48
Sipder19-Aug-07 23:48 
Questionhow can i select two tables in a datagride [modified] Pin
magedhv19-Aug-07 21:11
magedhv19-Aug-07 21:11 
cmd.CommandText = "select * from reglz where fatrname LIKE '%" & TextBox1.Text & "%' "
DataGridView1.Refresh()

ad.SelectCommand = cmd
ad.Fill(ds, "reglz")
DataGridView1.DataSource = ds.Tables("reglz")

this code for the table that called reglz

what i want to do is how can i make this sql statement on 2 tables together at the same time in a datagride

in other words i wanna see the 2 tables in the datagride with me condition that i have made in sql statement in reglz which is (where fatrname LIKE '%" & TextBox1.Text & "%' ")



then i want to save another word instead of the current one in database

and here my working code

Dim x As String

x = "'" & TextBox2.Text & "'"



Call conn()

cmd.CommandText = "update reglz set fatrname = " & x & " where fatrname LIKE '%" & TextBox1.Text & "%' "

DataGridView1.Refresh()

ad.SelectCommand = cmd

ad.Fill(ds, "dd")

DataGridView1.DataSource = ds.Tables("dd")

but how can i apply this code to the 2 table



SO what i want is :-

how can i select 2 tables to show them in a datagrid

how can i save any word for the two tables accroding to my condition .

plz help me

and thanks
AnswerRe: how can i select two tables in a datagride Pin
Vimalsoft(Pty) Ltd21-Aug-07 21:45
professionalVimalsoft(Pty) Ltd21-Aug-07 21:45 
QuestionHow can i create syntax tree to check the grammar of a string Pin
Ajay_developer19-Aug-07 18:26
Ajay_developer19-Aug-07 18:26 
AnswerRe: How can i create syntax tree to check the grammar of a string Pin
Dave Kreskowiak20-Aug-07 2:13
mveDave Kreskowiak20-Aug-07 2:13 
QuestionRe: How can i create syntax tree to check the grammar of a string [modified] Pin
Ajay_developer20-Aug-07 18:30
Ajay_developer20-Aug-07 18:30 
Questiontime attendance Pin
saraswathy14319-Aug-07 17:05
saraswathy14319-Aug-07 17:05 
AnswerRe: time attendance Pin
Christian Graus19-Aug-07 17:55
protectorChristian Graus19-Aug-07 17:55 
QuestionList box selection Pin
sa_runner19-Aug-07 15:26
sa_runner19-Aug-07 15:26 
AnswerRe: List box selection Pin
Christian Graus19-Aug-07 17:59
protectorChristian Graus19-Aug-07 17:59 
GeneralRe: List box selection Pin
sa_runner19-Aug-07 18:47
sa_runner19-Aug-07 18:47 
JokeRe: List box selection Pin
Luc Pattyn19-Aug-07 23:22
sitebuilderLuc Pattyn19-Aug-07 23:22 
GeneralRe: List box selection Pin
Christian Graus19-Aug-07 23:56
protectorChristian Graus19-Aug-07 23:56 
GeneralRe: List box selection Pin
sa_runner20-Aug-07 6:46
sa_runner20-Aug-07 6:46 
AnswerRe: List box selection Pin
The ANZAC20-Aug-07 0:08
The ANZAC20-Aug-07 0:08 
GeneralRe: List box selection Pin
sa_runner20-Aug-07 6:45
sa_runner20-Aug-07 6:45 
AnswerRe: List box selection Pin
satheesh.a20-Aug-07 0:14
satheesh.a20-Aug-07 0:14 
QuestionStatus Bar Text Pin
ejaz_pk19-Aug-07 11:58
ejaz_pk19-Aug-07 11:58 
AnswerRe: Status Bar Text Pin
Dave Kreskowiak19-Aug-07 12:27
mveDave Kreskowiak19-Aug-07 12:27 

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.