Visual Basic

Re: How to Bind a label from a Join

29-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

Usharva30-Nov-07 0:27

Usharva

30-Nov-07 0:27

Hi

you can try the below code

lblCount.DataBindings.Add("Text", mdsCount.Tables(0), mdsCount.Tables(0).Columns("ColName").ColumnName)

Re: How to Bind a label from a Join

Vimalsoft(Pty) Ltd30-Nov-07 0:57

terminating VB6 application

30-Nov-07 0:57

i get an Error that says

Cannot find table 0.

Thanks

Tree Control

Sipder29-Nov-07 23:10

Sipder

29-Nov-07 23:10

I want ot use tree node in my application and want to check if a particular node is clicked. How to do so?

Re: Tree Control

Christian Graus29-Nov-07 23:12

Christian Graus

29-Nov-07 23:12

What have you tried ? Did you read the MSDN help ? Did you try google ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

"Ondra29-Nov-07 23:10

29-Nov-07 23:10

Hello,
I have a program consisting of four modules and three forms. When I try to terminate it using following sub:

Public Sub END_IT()
Unload Form1
Unload inicializace
Unload tech_krivka
MsgBox "applicaion terminated", vbInformation
End
End Sub

the MsgBox appear, but then the program get stuck and it's neccesary to quit it from TaskManager (where CPU usage 99% for the VB6.EXE is shown).
When made to .exe file, the situation is the same except CPU usage 0%.
thank you for your oppinion

Ondra Pokorny

Sipder29-Nov-07 23:15

Sipder

29-Nov-07 23:15

Why don't u write simply
"End"
insted of unloading all the forms?

Tell me if it works

"Ondra29-Nov-07 23:23

Re: terminating VB6 application [modified]

29-Nov-07 23:23

Because I've tried it and it was all the same. So I've looked in VB6 Help and:
"
The End statement provides a way to force your program to halt. For normal termination of a Visual Basic program, you should unload all forms. Your program closes as soon as there are no other programs holding references to objects created from your public class modules and no code executing.
"

Vimalsoft(Pty) Ltd30-Nov-07 0:43

30-Nov-07 0:43

hi Ondra

Simply hide your forms and use unload function of vb6 and your Application will be terminated. like this

unload(frmmain)

.

Hope it helps

Thanks

-- modified at 6:54 Friday 30th November, 2007

"Ondra30-Nov-07 1:59

30-Nov-07 1:59

I've tried:

unload(Form1)

but a window appeared "invalid property value"

Vimalsoft(Pty) Ltd30-Nov-07 2:43

30-Nov-07 2:43

ok, do it this way

forgive me, i dont know when last did i use Vb6, but let me give you a solution to that.

i assume you have a an MDI, a main Form. on every clsing exent or Dispose, make sure you put this code.

umload me

.

and it will be very Easy if you have one MDI and other forms as Children, when you unload the MDI and other Form will be terminated.

try it and tell me what is happening.

Thanks

"Ondra30-Nov-07 2:52

30-Nov-07 2:52

no sucess, situation is the same- but I assume that there is not problem in this (see my later comment-it's probably caused by timers). Anyway, thank you very much.

ChandraRam30-Nov-07 1:38

ChandraRam

30-Nov-07 1:38

1) Where is this sub defined?
2) Do you have any code in the event that is called when you unload any of these forms?

"Ondra30-Nov-07 2:05

30-Nov-07 2:05

1)it is defined in one of the module
2)I don't think so; Actually,I use two winAPI timers form winmm.dll and one VB timer in the program,but they are all stopped before terminating the application

another clue?

"Ondra30-Nov-07 2:18