this method will triggered in when you type or anything you want to do with your textbox..ontext change then ?????? for example:
you type this code in your OnTextChanged.. ...
text1.text="sam ple"
when you pressed any key on the keyboard it will show a "sample" always...
Hope this will help you out....
redz
Last Activity: Mar 12 '14, 03:00 AM
Joined: Aug 13 '13
Location:
-
the field "name" is a reserved word in MYSQL but it never return an
error to me..
sometimes you have to checked what type of database server you are going to used. It unexpectedly returns an error when you used some reserved words.. It is only occurs in the name of the fieldsLeave a comment:
-
hi MKMK,
i used that query in MYSQL,
what type database server are you using?
here's the sample of my table according to your needs.
tbl1...
fields type length
matno int 10
name varchar 40
tbl2...
matno int 10
username varchar 40Leave a comment:
-
The Result
10 Jim u0500j2 o0600k2
20 Ken i0500a9
30 Jane o900j3Leave a comment:
-
here's the final query..
...Code:select a.matno,a.`name`,a.username1 as Username1,case when a.username2=b.username1 then '' else b.username1 end as Username2 from (select a.matno as matno,a.name,b.username as username1,b.username as username2 from (select * from tbl1) as a LEFT JOIN (select * from tbl2) as b on a.matno = b.matno) as a left join (select a.matno as matno,a.name,b.username
Leave a comment:
-
hi MKMK,
im not so sure but try this sample
...Code:select a.matno,a.`name`,a.username1,b.username2 from (select a.matno as matno,a.name,b.username as username1,b.username as username2 from (select * from tbl1) as a LEFT JOIN (select * from tbl2) as b on a.matno = b.matno) as a left join (select a.matno as matno,a.name,b.username as username1,b.username as username2 from (select
Last edited by Niheel; Aug 29 '13, 12:54 AM.Leave a comment:
-
Hi zmbd
thanks for editing my queryLeave a comment:
-
suggestion:
i think you have to use "Inno setup" to compile an exe fileLeave a comment:
-
what type of database are you using for?Leave a comment:
-
try this...
Code:select * from (SELECT * FROM IntroducerBasis WHERE IntroducerBasis.IntroducerCode ='AG' AND IntroducerBasis.BasisNumber=1) as a left join (select * from CommTypes) as b on a.commtypeid = b.idLeave a comment:
-
you have to read an excel file first before you bring it into another excel file like this...
...Code:dim op as new OpenFileDialog With op .Filter = "Excel File(*.xlsx*)|*.xlsx*|Excel File(*.xls*)|*.xls*" .Title = "Select Excel file" If .ShowDialog = DialogResult.Cancel Then MsgBox("User cancelled", vbInformation,Leave a comment:
-
what do you mean?
are you selecting a racord by searching in a textbox or something? try this..
you have to specify your query first..
select * from tablename where fieldname like '%" & textbox1.text & "%'
i am using crystal report for printing records..Leave a comment:
No activity results to display
Leave a comment: