Looping through controls using FOR EACH - Visual Basic Discussion Boards

Re: Database Issues: Can't save a thing!

Christian Graus26-Sep-06 12:30

26-Sep-06 12:30

Using the auto generated stuff, you give up a lot of control over your database. However, I notice one change :

Me.BindingSource1.EndEdit(me.MyCompanyDataSet1.Customer)

Me.GroupsBindingSource.EndEdit()

You're not passing in a dataset anymore. Should you be ?

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Database Issues: Can't save a thing!

The ANZAC26-Sep-06 23:18

The ANZAC

26-Sep-06 23:18

nah, somehow i managed to bind one binding source to another which was bound to a dataset, i fixed this issue. However, I run the program, change some values then save and i can actually see the values change, but when i stop running the program and run it again after some time, all my values are returned to defualt values that i first entered in my table.

Is this a normal thing, do i have to publish export and run my program before i see these changes. Or should they stay changed even after running and closing.

Posted by The ANZAC

Re: Database Issues: Can't save a thing!

Dave Kreskowiak27-Sep-06 2:22

Dave Kreskowiak

27-Sep-06 2:22

Then your changes were not written/commited to the table. There's still something wrong with your code.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Database Issues: Can't save a thing!

The ANZAC27-Sep-06 21:35

The ANZAC

27-Sep-06 21:35

Well I can't figure out what it is. I was wondering if you were able to outline the general structure needed to create an editable( e.g. New, Edit, Remove) database interface. Especially, I was wondering if you could outline exactly the normal code to save/update changes a database that is accessed through:

Binding Source Bound to DataSet bound to database.

Posted by The ANZAC

Re: Database Issues: Can't save a thing!

Dave Kreskowiak28-Sep-06 3:45

Dave Kreskowiak

28-Sep-06 3:45

If you're using the wizards to create all the objects, I really can't direct you. The wizards generate code all over the place that's difficult to locate, let alone support.

But basically, once the user wants to save changes back to the database, you do something like this:

    ' For VB.NET 2005
    DataAdapter1.AcceptChangesDuringUpdate = True
    DataAdapter1.Update(DataSet1)
 
    ' For VB.NET 2002 and 2003
    DataAdapter1.Update(DataSet1)
    DataSet1.AcceptChanges()

Dave Kreskowiak
Microsoft MVP - Visual Basic

Regardin displaying parent node

praveen kumar mahto26-Sep-06 11:30

praveen kumar mahto

26-Sep-06 11:30

hi
i am little new to VB.net windows application
i am using treeview which shows the hierarchy and next to it is a datagrid generally like our windows explorer.

the thing is that i want to display a list of all the parent node that i select with the depth level. where the tree is generated at the runtime from the database.

i am littlebit clueless please help to rectify it

Praveen Kumar

Re: Regardin displaying parent node

Dave Kreskowiak27-Sep-06 9:10

Dave Kreskowiak

27-Sep-06 9:10

I'm not seeing what your trying to describe. You mean you want to show a list of the parent nodes for each child node you click on?? Something like:

Parent1
    Parent2
        Parent3
            ClickedChildNode

Every TreeNode object, whether it's a Parent and/or Child, has a Parent property that returns the parent node of the current node. For example, above, if you clicked on ClickedChildNode, it's Parent property would return the Parent3 treenode. All you have to do is keep getting the parent of each parent node until Parent returns Nothing, meaning your at the top of the tree.

TreeNode.Parent[^] property docs.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Looping through controls using FOR EACH

MatthysDT26-Sep-06 5:34

MatthysDT

26-Sep-06 5:34

Hi, I need some help with the FOR EACH command, here is my code:

Dim b As New ToolStripMenuItem
        For Each b In Me.cmsTestList.Items
            Debug.Print(b.Name)
            Debug.Print(b.Tag)

            If b.CheckOnClick = True Then
                If b.Tag = "check" Then
                    b.Checked = True
                Else
                    b.Checked = False
                End If
            End If

        Next

cmsTestList is of the type Windows.Forms.ContextMenuStrip
and
cmsTestList.Items returns a Windows.Forms.ToolStripItemCollection

I was under the impression that the object "b" will always be of the type: ToolStripMenuItem since I specified explicitly FOR EACH ToolStripMenuItem.

But the code tries looping through other items in my menu such as 'System.Windows.Forms.ToolStripTextBox'. This is not a ToolStripMenuItem as far as I know!

So resultingly the code breaks with the error:
Unable to cast object of type 'System.Windows.Forms.ToolStripTextBox' to type 'System.Windows.Forms.ToolStripMenuItem'.

I would never have thought that type casting will be necessary for this kind of implementation of the FOR EACH x IN command Mad | :mad:

, and I don't know how to deal with this type casting either. Confused | :confused:

What I need to do is to loop through only the ToolStripMenuItems and not through all the other ToolStripItems as well!

Any ideas?

Kind Regards

you can't forget something you never knew...

"Watching Migthy Joe Young made me hate my life..................................I want a gorilla!" A. Havemann

Re: Looping through controls using FOR EACH

mr_lasseter26-Sep-06 6:53

mr_lasseter

26-Sep-06 6:53

It doesn't work the way you are thinking. The for each does not limit the type of controls in the collection. You need to do something like the following:

<br />
for each item as ToolStripItem in cmsTestList.Items<br />
     if  item.Type is GetType(ToolStripMenuItem) then<br />
        'do your work here<br />
     end if<br />
next<br />

Mike Lasseter

Playing MP3 file

mido1326-Sep-06 4:37

mido13

26-Sep-06 4:37

i'm using VB6
im about to finish my proj
it must play both of MP3 and WAV files
i need to play mp3 file from my proj without any control
just play it
Sniff | :^)

thanx alot

Re: Playing MP3 file

Christian Graus26-Sep-06 12:32

Christian Graus

26-Sep-06 12:32

You need to use the Windows Media Player control, and you can set it to not display anything.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

vertical tab control

tatapower26-Sep-06 4:02

tatapower

26-Sep-06 4:02

hi...
i am trying to create a vertical tab control in vb.net but could not manage to keep the alignment horizontal. What i want is that the tab should come in vertical but should be placed horizontally as in the startup property page of a project in vb.net.

anyone could please help me.

thanks

NEVER_Minimizable form

K ^edar V26-Sep-06 3:34

K ^edar V

26-Sep-06 3:34

I want to make my form NEVER_Minimizable
to do that.....i;ve done this:--

Protected Overloads Overrides Sub WndProc(ByRef msg As Message)
If msg.Msg = WM_SYSCOMMAND Then
If msg.WParam.ToInt32 = SC_MINIMIZE Then
Else
MyBase.WndProc(msg)
End If

BUT, This never handles Windows + D (Show Desktop) keys..
How to handle that ??

"You can do any thing you set to your mind" - theGhost_k8

Re: NEVER_Minimizable form

Dave Sexton26-Sep-06 5:02

Dave Sexton

26-Sep-06 5:02

Try removing the control box/minimize button/form border to make it impossible for the user to minimize.

Re: NEVER_Minimizable form

K ^edar V26-Sep-06 19:58

K ^edar V

26-Sep-06 19:58

Here aint a NewBie stuff.....
I've said cancel d effect of Ctrl + M / Ctrl + D

"You can do any thing you set to your mind" - theGhost_k8

datagrid columnheader alignment

Smithers-Jones26-Sep-06 3:16

Smithers-Jones

26-Sep-06 3:16

vb.net

when i set alignment of a datagrid's columnheader to right, then the headertext's last letter on the right is halfway hidden. how can i avoid that?

Re: datagrid columnheader alignment

Dave Sexton26-Sep-06 5:04

Dave Sexton

26-Sep-06 5:04

Increase the column width.

Re: datagrid columnheader alignment

Smithers-Jones27-Sep-06 3:28

Smithers-Jones

27-Sep-06 3:28

it's not depending from the column header's width. the last letter is cut anyway.

Cannot show multiple values for combobox DisplayMember?

Rashar26-Sep-06 3:15

Rashar

26-Sep-06 3:15

Hello,

I'm trying to populate my ID and Dealername in my combobox, but when I try the below scripts, I'm only seeing the ID at runtime... How can I show both the ID and DealerName in my combobox?

      <br />
Me.cboSelectDealer.DataSource = ReportDS.Tables("tblCall_Reports")<br />
Me.cboSelectDealer.DisplayMember = "UID" & "-" & " DealerName"<br />
Me.cboSelectDealer.ValueMember = "UID"<br />

      <br />
Me.cboSelectDealer.DataSource = ReportDS.Tables("tblCall_Reports")<br />
Me.cboSelectDealer.DisplayMember = "UID" + "-" + " DealerName"<br />
Me.cboSelectDealer.ValueMember = "UID"<br />

Thanks in advance.

Re: Cannot show multiple values for combobox DisplayMember?

Coding1234566-Apr-09 18:18

Coding123456

6-Apr-09 18:18

I realise this is an old post but it might help someone else out.
I needed to do a similar thing but I didn't want to concatinate fields in the sql used to fill the datatable as it was contained in an existing stored procedure. So I filled the datatable with the records I wanted then basically added another column in the datatable which was my concatinated display value. I then used this new column as the DisplayMember.

assuming we have a datatable which is populated with "AccountCode" and corresponding "AccountName"
eg "ABC" , "Freds workshop"
"XYZ" , "Bills Lighting"

'Add a new calculated column to the datatable
        Dim DataCol As DataColumn = New DataColumn("Display")
        DataCol.DataType = System.Type.GetType("System.String")
        DataCol.Expression = "AccountCode + (' - ') + AccountName"
        dt.Columns.Add(DataCol)

'Now setup the combobox
        cmbAvailableCompanies.DataSource = dt
        cmbAvailableCompanies.DisplayMember = "Display"
        cmbAvailableCompanies.ValueMember = "AccountsCode"

It will now display "ABC - Freds Workshop" and "XYZ - Bills Lighting" in the combobox.

The only issue I have found is if I turn sorting of the combobox on the SelectedValue of the combobox gets out of sync with the Displayed value. I haven't worked this out yet but for the time being I can live with it.

Reload main form?

cstrader23226-Sep-06 2:07

cstrader232

26-Sep-06 2:07

Hi!

How do I allow the user to reload the main form of the application? In essence, I want a button that closes the whole program and opens it again, starting from scratch.

thanks

Re: Reload main form?

Christian Graus26-Sep-06 12:33

Christian Graus

26-Sep-06 12:33

Write a method that sets the initial state of your controls and variables, call it in your form load ( so it always works the same ) and call it again from a button event.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Send emails from windows form

Nikhil Bandekar26-Sep-06 2:03

Nikhil Bandekar

26-Sep-06 2:03

Hii Friends

I have a form in my software in which if user is connected to internet can send an querry to my id, myid@gmail.com. Two textboxes one for sender email id will be written and another for subject, And the main querry in the multiple lines text box. i have a smptp and pop3 account with gmail.com as smtp.gail.com and pop.gmail.com . How can i do this which namespace i have to import for tat and the code is required.

I have been tryin on this

Please share if u have N E idea.

Thanks

Nikhil Bandekar
Mumbai,
India

Re: Send emails from windows form

Christian Graus26-Sep-06 12:34

Christian Graus

26-Sep-06 12:34

This[^] works for me.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Storing Mails recieved in ms outlook into sql database

gauravjee26-Sep-06 0:39

gauravjee

26-Sep-06 0:39

Dear all
i am trying to find out a way to store any mails recieved in MS outlook into a MSSQL database located remotely

can anyone help with this

the database has the following fields From_ID <varchar(40)> To_ID <varchar(30)> Subject <varchar(50)> Message <varchar(1600)> Date <datetime>

Its pretty urgent
Please Help

Gaurav

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.