Visual Basic

Code to close all child form

25-Oct-06 5:09

I can't follow this at all...

I'm guessing at what you want here... Datatable rows don't get children. You have to design your table so that each record has a field that points to a parent records primary key in the same table.

RecordID    bigint
Name        nvarchar(50)
ParentID    bigint

Each record has it's own unique RecordId. If a record has a parent, you set its ParentID to the RecordID number of the parent.

RecordID    Name            ParentID
------------------------------------
   1        Mike               0          (0 means "no parent")
   2        John               1          (John is a child of Mike)

Dave Kreskowiak
Microsoft MVP - Visual Basic

Mekong River24-Oct-06 19:00

Mekong River

24-Oct-06 19:00

Hi, I have an MDI form and has a child form. I want to write the command close all child form but I forget the code. As I remember I used to write in the similar code:

Dim Variable as Control<br />
<br />
For Each Control...<br />
Close all form...<br />
Next

I forget it and want to write its again when I click log off. I forget the code and if someone expereince to do the following behavior please send me this sample code. (I use vb.net 2003).

Re: Code to close all child form

Dave Kreskowiak25-Oct-06 4:58

Re: Code to close all child form

25-Oct-06 4:58

Easily done if you look at the MdiChildren property of your parent form.

For Each f As Form In Me.MdiChildren
    f.Close()
Next

Dave Kreskowiak
Microsoft MVP - Visual Basic

Mekong River27-Oct-06 18:00

Mekong River

27-Oct-06 18:00

Hi Dave, thank you very much for your help. This code is really help to me accomplish my work. Thank you Smile | :)

Accessing ports of a DVR card

W.A. Dilhara24-Oct-06 18:31

W.A. Dilhara

24-Oct-06 18:31

I need help on grabbing images from 4 analog color cameras connected to BNC ports of a DVR card (PCI).

How can I get the images to picture boxes in a VB6 program?

I do not require to record video or do motion detection. All I need is to grab still images in bmp or jpeg format on an user input. My problem is as simple as that!

I could not find any windows driver for this hardware but works only with supplied DVR software.

Thanks in advancce for your help!

Dilhara

Re: Accessing ports of a DVR card

Dave Kreskowiak25-Oct-06 3:23

Combo Properties & Events Help Please

25-Oct-06 3:23

Your stuck. Without ANY documentation on the card or an SDK kit from the manufacturer of that card, there is nothing you can do. If there is no driver, then there is no way you can get at that card without writing your own driver. And without knowing the ins and outs of that card, that's impossible.

Dave Kreskowiak
Microsoft MVP - Visual Basic

cgai24-Oct-06 10:14

cgai

24-Oct-06 10:14

I am using VB.NET 2005 and WinForms. I have a bound (dropdownlist) ComboBox who's selection list is based on another field (City) on the Form. The Combo part is a 1-field query (strName) and I am storing the exact same strName field in the database. My selection list is working OK.

PROBLEMS:
1. What property do I bind to (or both)? .Text or .SelectedValue ??
2. When to Fill the DataSource for the Combo list ?
(before combo displays ?) (before Combo Enter?) (after City changes?)
3. What property do I pass to my stored procedure, when updating Name ?
(.Text or .SelectedVAlue?)
4. The SelectedValueChanged event is firing many times, and it seems to change the value I have selected. How best to deal with this event ... also with the SelectedIndex ?

Where can I find some VERY definitive expanations of EXACTLY how the Combo properties and events work ?
Thanks much,

SMH

Dave Kreskowiak25-Oct-06 3:27

25-Oct-06 3:27

cgai wrote:
Where can I find some VERY definitive expanations of EXACTLY how the Combo properties and events work ?

cgai wrote:
1. What property do I bind to (or both)? .Text or .SelectedValue ??

You don't bind to anything...

cgai wrote:
2. When to Fill the DataSource for the Combo list ?
(before combo displays ?) (before Combo Enter?) (after City changes?)

After City changes. If you don't know the City, how are you going to know what to put in this second list?

cgai wrote:
3. What property do I pass to my stored procedure, when updating Name ?
(.Text or .SelectedVAlue?)

The ID of the record that you're updating, which is probably going to be supplied by SelectedValue, but that's entirely dependant on how you've written your code and what you've put into this ComboBox.

cgai wrote:
4. The SelectedValueChanged event is firing many times, and it seems to change the value I have selected. How best to deal with this event ... also with the SelectedIndex ?

If you've written your code correctly, and used the proper events, you shouldn't be seeing this problem.

http://msdn.microsoft.com[^]

Dave Kreskowiak
Microsoft MVP - Visual Basic

cgai25-Oct-06 5:11

cgai

25-Oct-06 5:11

Hi Dave, thank you for responding ...

Dave Kreskowiak wrote:
cgai wrote:
1. What property do I bind to (or both)? .Text or .SelectedValue ??

You don't bind to anything...

This stuff is so difficult to explain in text ... I probably was not clear. I'm using my "Name" combobox to enter/update a field in my database ... via a TableAdapter in a DataSet. This is a bound control, so I assume there has to be a binding property ... usually .Text or .SelectedValue (but I'm not sure when to use one or the other, or both).

Dave Kreskowiak wrote:
cgai wrote:
4. The SelectedValueChanged event is firing many times, and it seems to change the value I have selected. How best to deal with this event ... also with the SelectedIndex ?

If you've written your code correctly, and used the proper events, you shouldn't be seeing this problem.

I'm sure I have not written my VB code correctly, and might have not set properties & events correctly.

I wonder if you would be able to outline how you would design an implementation to my ComboBox scenario ? Any good references would also be appreciated.

Thank you again ...

SteveH

Dave Kreskowiak25-Oct-06 5:30

25-Oct-06 5:30

cgai wrote:
I wonder if you would be able to outline how you would design an implementation to my ComboBox scenario ?

I can't figure out what your ComboBox scenario is!!

Let's see... Are you saying that you have a ComboBox bound to a table that has a list of Names in it? The user picks a Name, then another ComboBox is supposed to fill with some other information, based on the Name picked??

Dave Kreskowiak
Microsoft MVP - Visual Basic

cgai25-Oct-06 6:36

cgai

25-Oct-06 6:36

Dave Kreskowiak wrote:
I can't figure out what your ComboBox scenario is!!

Let's see... Are you saying that you have a ComboBox bound to a table that has a list of Names in it? The user picks a Name, then another ComboBox is supposed to fill with some other information, based on the Name picked??

I'll try my best to outline the scenario:

I am updating a strContactName field (using a ComboBox cboName) in a tblCompany record. There is also a strCity field in the record which filters the list of possible names. There is a dt_tblContactNames DataTable in a dsLookups DataSet.

dt_tblContactNames Fill: "SELECT strContactName FROM tblContactNames WHERE strCity = (my city in this record)" (this is used for the ContactName dropdown list, and it works fine)

When the user clicks the Save button on the Form, the changes are written to the database via a stored procedure, for which I define and pass field values as parameters, in VB code. This technique works fine for all the other fields.

Some issues:

1. After the City and Name are entered, the Name needs to display in the ComboBox text whenever the record is retrieved. It seems like the dropdown list needs to be properly filled, otherwise the Name does not display.

2. I need to bind the cboName control to strContactName ... probably using .SelectedValue, but I don't see why .Text does not work as well ..

3. I need to know when to fill the dropdown list for the ComboBox. Yes, after the City changes, but also when the form is first displayed ...

I have set most of wiring in the Properties window for the ComboBox, but I Call the Fill for the dropdown, and the record Update, in VB code.

I hope that helps explain what I am trying to do ... probably a common scenario.

cgai:
I am using VB.NET 2005 and WinForms. I have a bound (dropdownlist) ComboBox who's selection list is based on another field (City) on the Form. The Combo part is a 1-field query (strName) and I am storing the exact same strName field in the database. My selection list is working OK.

SteveH

refresh a form

steve_rm24-Oct-06 7:22

steve_rm

24-Oct-06 7:22

Hello,

I want to refresh a form. The current finds sql servers on the network which it does. But sometimes it doesn't. I have put the function call in the form load, which calls the function to fill a list box of servers.

I have a button thats called refresh, which calls that function. However, even though it calls that function it does not work the same unless you close the form and open it again.

Is there some way to achieve something that refresh the form without closing and opening it again.

Many thanks in advance,

Steve

Re: refresh a form

Dave Kreskowiak24-Oct-06 7:45

Read an XML file as a datafile

24-Oct-06 7:45

Move your code that finds the servers to a seperate method and have it return an array of strings. Create another method that clears and refills the ListBox. That method will be the one to call the method that retrieves the server list. Your code can then be called from anywhere in your form code.

Private Sub Form_Load(blah, blah) blah...
    RefreshServerList()
End Sub
.
.
Private Sub Button1_Click(blah, blah) blah...
    RefreshServerList()
End Sub
.
.
Private Function GetSqlServers() As String()
    Dim Servers As String()
    ' Build your list of Sql Servers...
    Return Servers
End Sub
.
.
Private Sub RefreshServerList()
    Dim s As String() = GetSqlServers()
    ListBox1.DataSource = s
End Sub

Dave Kreskowiak
Microsoft MVP - Visual Basic

sybux200024-Oct-06 4:52

sybux2000

24-Oct-06 4:52

Hi,

I'm having an XML file which is an extraction of a database request. I'd like to read in it with VB.Net like I can do when using direct database connection with command such as datareader for example.

Thx
Sybux

Re: Read an XML file as a datafile

Dave Kreskowiak24-Oct-06 5:04

Re: Read an XML file as a datafile

24-Oct-06 5:04

You can either load the XML file into a DataSet, which will treat it just like a DataSet returned from a database, or you can load it into an XmlDocument and use normal XML methods to manipulate it.

It sounds like all you want to do is iterate over a set of records so, to get your XML into a DataSet, all you have to do is:

Dim myData As New DataSet
myData.ReadXml(filepath)

There are various overloads of ReadXml, so use whatever is appropriate for your case.

Dave Kreskowiak
Microsoft MVP - Visual Basic

sybux200025-Oct-06 21:03

sybux2000

25-Oct-06 21:03

thx for help but I still have got a problem.

Here is an extract of my xml file :

< ?xml version = '1.0'?>
< PAGE>
   < DATA>
      < DATA>
         < seance i_seance="218765344" d_date="20060919" d_debut="13:30" d_fin="15:00" d_jour="mardi" n_semaine="38" type_seance="Enseignement">
            < x_remarques>Groupe A non bilingue et B</x_remarques>
            < ressource type="enseignant" libelle="MR X"/>
            < ressource type="volee" libelle="Information documentaire, 2006-2007, S1"/>
            < ressource type="matiere" code="7612F" libelle="Sociologie des organisations (Cours)"/>
            < ressource type="classe" libelle="ID1B"/>
            < ressource type="classe" libelle="ID1A Non bilingue"/>
            < ressource type="espace" libelle="C101"/>
         < /seance>
         < seance i_seance="218766590" d_date="20060919" d_debut="15:15" d_fin="16:45" d_jour="mardi" n_semaine="38" type_seance="Enseignement">
            < x_remarques>Groupes A non bilingue et B</x_remarques>
            < ressource type="enseignant" libelle="MR A"/>
            < ressource type="enseignant" libelle="MR B"/>
            < ressource type="volee" libelle="Information documentaire, 2006-2007, S1"/>
            < ressource type="matiere" code="7113F" libelle="Introduction � l&apos;archivistique (Cours)"/>
            < ressource type="classe" libelle="ID1B"/>
            < ressource type="classe" libelle="ID1A Non bilingue"/>
            < ressource type="espace" libelle="C101"/>
         < /seance>
      < /DATA>
   < /DATA>
< /PAGE>

I've written the following code but doesn't not display it well :

Sub Main()
        Dim myData As New DataSet
        Dim mDataRow, mdr As DataRow

        myData.ReadXml("test.xml")

        For Each mDataRow In myData.Tables(1).Rows
            System.Console.WriteLine("date : " & mDataRow("d_date"))
            System.Console.WriteLine("Heure début : " & mDataRow("d_debut"))
            System.Console.WriteLine("Heure fin : " & mDataRow("d_fin"))
            System.Console.WriteLine("Jour : " & mDataRow("d_jour"))
            System.Console.WriteLine("Type Séance : " & mDataRow("type_seance"))
            For Each mdr In myData.Tables(2).Rows
                System.Console.WriteLine(mdr(1) & " : " & mdr(2))
            Next
        Next
        System.Console.ReadLine()
    End Sub

Can some1 tell me where I'm wrong .

thx

One last hope

Pete Newman24-Oct-06 4:09

24-Oct-06 4:09

VS2005 (vb) and SQL2005
Sigh | :sigh:

ok im nearly beaten here... think its lack of sleep

I need a very very kind person to help me out as im totally losing the will to live

Ok i have an Default.aspx page with a textbox ( ID TXT1 ) and a Button. what i want to do, what ive been trying to do is when the button is clicked, it basicly does a a "Select count(*) from Table1.dbo.users where name = '" & TXT1.text & "'" and display the return value

ok to some its simple stuff but i have to start somewhere Sniff | :^)

, so please can you explain it in laymans terms

thank you

I really do need help..... all this computer stuff is way over my head !!

nlarson1124-Oct-06 4:15

nlarson11

24-Oct-06 4:15

Pete,

let's start slow...

1) are you able to establish a database connection from your webpage?

Pete Newman24-Oct-06 4:23

24-Oct-06 4:23

Hi,
Thanks for the reply. this is all new to me and im struggling like mad. Just for background, Im trying to create an Intra-net project... as a tester. I have my web.config file which has the connection string to the SQL server, and im presuming that if the connection string was incorrect there would be an error. as below

The only conponents i have added are the textbox and Button

section of web.config

<connectionstrings>
<remove name="LocalSqlServer">
<add name="LocalSqlServer"
="" connectionstring="Data Source=DevSQL2;Initial Catalog=TestDataBase;Integrated Security=True" providername="System.Data.SqlClient">

thanks Smile | :)

I really do need help..... all this computer stuff is way over my head !!

Pete Newman24-Oct-06 4:25

24-Oct-06 4:25

grrr sorry this is what was meant to be added

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer"
connectionString="Data Source=DevSQL2;Initial Catalog=TestDataBase;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

I really do need help..... all this computer stuff is way over my head !!

Pete Newman24-Oct-06 4:44