Click here to Skip to main content
16,011,883 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: How to take file's condents Pin
somagunasekaran4-Jan-07 19:34
somagunasekaran4-Jan-07 19:34 
GeneralRe: How to take file's condents Pin
Christian Graus4-Jan-07 19:41
protectorChristian Graus4-Jan-07 19:41 
GeneralRe: How to take file's condents Pin
somagunasekaran4-Jan-07 19:54
somagunasekaran4-Jan-07 19:54 
GeneralRe: How to take file's condents Pin
Christian Graus4-Jan-07 20:00
protectorChristian Graus4-Jan-07 20:00 
GeneralRe: How to take file's condents Pin
somagunasekaran4-Jan-07 21:32
somagunasekaran4-Jan-07 21:32 
QuestionHiding rows in a datagridview Pin
steve_rm4-Jan-07 17:46
steve_rm4-Jan-07 17:46 
AnswerRe: Hiding rows in a datagridview Pin
EldieBongers10-Jan-07 22:09
EldieBongers10-Jan-07 22:09 
QuestionProblem Pin
amaneet4-Jan-07 17:18
amaneet4-Jan-07 17:18 
Sir/Madam,
I am facing the problem in the query implementation in vb.net.Like I have an id that is present in 5 tables(like table1,table2,table3,table4,table5).I have to pick those records from table1 which are not present in tabl15.I mean an id number 1 is present in table1,table2,table3,table4 .but the id number 1 is not present in table5.My final motive is i have to pick all the id like 1.
i am using the query in the following way.

dim str as string = "Select able1.field1,table2.field1,table3.field1,table4.field1
from table1,table2,table3,table4,table5
where
(table1.id<>table5.id and table2.id <> table5.id and table3.id <> table5.id
and table4.id<> table5.id)

it is showing those records that are not present in table5 but present in the remaining tables.
But the problem is , there occured duplicacy.I mean one record is iterating 24 times i the final result.
Please help.
Thanks and Regards
Pankaj
AnswerRe: Problem Pin
ChandraRam5-Jan-07 0:58
ChandraRam5-Jan-07 0:58 
GeneralRe: Problem Pin
amaneet6-Jan-07 0:20
amaneet6-Jan-07 0:20 
QuestionTextbox drop Focus on ENTER key Pin
roo4264-Jan-07 16:50
roo4264-Jan-07 16:50 
AnswerRe: Textbox drop Focus on ENTER key Pin
minhnguyen084-Jan-07 20:55
minhnguyen084-Jan-07 20:55 
GeneralRe: Textbox drop Focus on ENTER key Pin
roo4265-Jan-07 2:32
roo4265-Jan-07 2:32 
QuestionMulti-Tab Controlling Pin
MatrixCoder4-Jan-07 16:26
MatrixCoder4-Jan-07 16:26 
AnswerRe: Multi-Tab Controlling Pin
tosch4-Jan-07 21:04
tosch4-Jan-07 21:04 
GeneralRe: Multi-Tab Controlling Pin
MatrixCoder5-Jan-07 3:48
MatrixCoder5-Jan-07 3:48 
AnswerRe: Multi-Tab Controlling Pin
Enriad6-Jan-07 23:13
Enriad6-Jan-07 23:13 
GeneralRe: Multi-Tab Controlling Pin
MatrixCoder7-Jan-07 5:52
MatrixCoder7-Jan-07 5:52 
Questionhow to use marquee property in status bar? Pin
sararaj4-Jan-07 16:15
sararaj4-Jan-07 16:15 
AnswerRe: how to use marquee property in status bar? Pin
MatrixCoder4-Jan-07 16:28
MatrixCoder4-Jan-07 16:28 
GeneralRe: how to use marquee property in status bar? Pin
Enriad6-Jan-07 23:16
Enriad6-Jan-07 23:16 
QuestionFile Info Pin
CodingYoshi4-Jan-07 10:27
CodingYoshi4-Jan-07 10:27 
AnswerRe: File Info Pin
Yona Low4-Jan-07 11:48
Yona Low4-Jan-07 11:48 
AnswerRe: File Info Pin
Colin Angus Mackay4-Jan-07 11:48
Colin Angus Mackay4-Jan-07 11:48 
GeneralRe: File Info Pin
CodingYoshi5-Jan-07 6:20
CodingYoshi5-Jan-07 6:20 

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.