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

Visual Basic

 
GeneralRe: How can we define a current path to fetch the database by OleDbConnection Pin
selvabsc6-Dec-07 0:55
selvabsc6-Dec-07 0:55 
Questionbinding an arry to listbox control Pin
balakpn30-Nov-07 0:10
balakpn30-Nov-07 0:10 
AnswerRe: binding an arry to listbox control Pin
Naji El Kotob30-Nov-07 10:05
Naji El Kotob30-Nov-07 10:05 
QuestionVSTO Pin
Tsepoz30-Nov-07 0:03
Tsepoz30-Nov-07 0:03 
QuestionSqlServerCe VISUAL STUDIO 2005 VISUAL BASIC help needed Pin
panagiotis_mallis29-Nov-07 23:27
panagiotis_mallis29-Nov-07 23:27 
AnswerCross-Post (3 forums) Pin
leckey30-Nov-07 3:15
leckey30-Nov-07 3:15 
AnswerRe: SqlServerCe VISUAL STUDIO 2005 VISUAL BASIC help needed Pin
Paul Conrad30-Nov-07 4:43
professionalPaul Conrad30-Nov-07 4:43 
QuestionHow to Bind a label from a Join Pin
Vimalsoft(Pty) Ltd29-Nov-07 23:16
professionalVimalsoft(Pty) Ltd29-Nov-07 23:16 
Good Afternoon All

i have this an SQl join, and in my Dataset like this

Dim strSQL As String = "select count(p1.Property_ID)from Property p1  " & _
                                   "  where Not Exists" & _
                                   "  (select 1 from  Attribute_codes_test p2  " & _
                                   "  where p2.Attrib_code = Substring(p1.Attrib_code, 1, 8)  " & _
                                   "  and p1.Active= 1) "
.

i want to display it in a label, but i cant convert it to intiger, because i i cannot convert a dataset to intiger, so through a dataset i manage to carry the results of the above to my form, but now, when i try to Display this like this

lblCount.DataBindings.Add("text", mdscount, "Property.??????")
.

on the Above code, i dont know what to put where ???? appears because this comes from join. and i try to put an Existing field in my table like this

lblCount.DataBindings.Add("text", mdscount, "Property.Lis_key")
.

i get this Error

Cannot create a child list for field Property.
.


Thanks




Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za


AnswerRe: How to Bind a label from a Join Pin
Usharva30-Nov-07 0:27
Usharva30-Nov-07 0:27 
GeneralRe: How to Bind a label from a Join Pin
Vimalsoft(Pty) Ltd30-Nov-07 0:57
professionalVimalsoft(Pty) Ltd30-Nov-07 0:57 
QuestionTree Control Pin
Sipder29-Nov-07 23:10
Sipder29-Nov-07 23:10 
AnswerRe: Tree Control Pin
Christian Graus29-Nov-07 23:12
protectorChristian Graus29-Nov-07 23:12 
Questionterminating VB6 application Pin
"Ondra29-Nov-07 23:10
"Ondra29-Nov-07 23:10 
AnswerRe: terminating VB6 application Pin
Sipder29-Nov-07 23:15
Sipder29-Nov-07 23:15 
GeneralRe: terminating VB6 application Pin
"Ondra29-Nov-07 23:23
"Ondra29-Nov-07 23:23 
GeneralRe: terminating VB6 application [modified] Pin
Vimalsoft(Pty) Ltd30-Nov-07 0:43
professionalVimalsoft(Pty) Ltd30-Nov-07 0:43 
GeneralRe: terminating VB6 application Pin
"Ondra30-Nov-07 1:59
"Ondra30-Nov-07 1:59 
GeneralRe: terminating VB6 application Pin
Vimalsoft(Pty) Ltd30-Nov-07 2:43
professionalVimalsoft(Pty) Ltd30-Nov-07 2:43 
GeneralRe: terminating VB6 application Pin
"Ondra30-Nov-07 2:52
"Ondra30-Nov-07 2:52 
AnswerRe: terminating VB6 application Pin
ChandraRam30-Nov-07 1:38
ChandraRam30-Nov-07 1:38 
GeneralRe: terminating VB6 application Pin
"Ondra30-Nov-07 2:05
"Ondra30-Nov-07 2:05 
Answeranother clue? Pin
"Ondra30-Nov-07 2:18
"Ondra30-Nov-07 2:18 
AnswerThere's problem with timers! Pin
"Ondra30-Nov-07 2:40
"Ondra30-Nov-07 2:40 
Questionhow to detect changes in system date Pin
eyes200729-Nov-07 22:35
eyes200729-Nov-07 22:35 
AnswerRe: how to detect changes in system date Pin
Christian Graus29-Nov-07 22:53
protectorChristian Graus29-Nov-07 22:53 

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.