Visual Basic

i want to print the datagridview content when i press the pirnt button

27-Sep-06 2:31

It's not Ctrl-D and Ctrl-M, it's WindowsLey-D, and WindowsKey-M.

Both of these combinations are MEANT to minimize everything so the user can see the Desktop. Unless your application is running on a kiosk machine, I don't recommend trapping this.

Your handling the WM_SYSCOMMAND, but you're NOT handling the WM_SIZE and WM_SIZING messages. Try those and see what you get.

Dave Kreskowiak
Microsoft MVP - Visual Basic

vrk_raju26-Sep-06 18:12

vrk_raju

26-Sep-06 18:12

actually iam converting the datagridview content in to excel format and printing the excel sheet.

but i wnat to print the contents of datagridview directly pressing the print button..

pl help...

raju Smile | :)

Re: i want to print the datagridview content when i press the pirnt button

Dave Kreskowiak27-Sep-06 2:23

Re: i want to print the datagridview content when i press the pirnt button

27-Sep-06 2:23

A little Google goes a long way... "vb.net print datagridview[^]"

Dave Kreskowiak
Microsoft MVP - Visual Basic

Sourie23-Sep-08 6:53

Sourie

23-Sep-08 6:53

use these links:
http://www.codeproject.com/KB/printing/ControlPrint.aspx

http://www.codeproject.com/KB/printing/datagridviewprinter.aspx

Sourie

debugging a c# .dll

gooseman11226-Sep-06 16:20

gooseman112

26-Sep-06 16:20

Does anyone know how to debug a c# .dll that i have included in my vb.net project. Am using visual studio 2005.

thanks in advance Smile | :)

Christian Graus26-Sep-06 16:34

26-Sep-06 16:34

Did you write the dll ? If not, you're out of luck. If you build a debug version of the dll, you should just be able to step into it.

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

gooseman11226-Sep-06 16:41

gooseman112

26-Sep-06 16:41

nah i didnt write it, but ive got the source which has been compiled under debug
still not sure how you would step into it and how you would go about setting breakpoints etc from the new project...

Christian Graus26-Sep-06 16:44

26-Sep-06 16:44

You may need to put the dll project into yuor solution, but I don't think so. If yo uset a break point at a call to the dll, I think F11 will step in. If you want breakpoints within the dll, yes, you will need to make the project part of the solution.

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

Database Issues: Can't save a thing!

gooseman11226-Sep-06 17:12

gooseman112

26-Sep-06 17:12

thanks christian for your help.. have stepped into the c# code from adding it to the solution.
many thanks.
now the fun begins...

The ANZAC26-Sep-06 11:45

The ANZAC

26-Sep-06 11:45

Im using vs 2005 to design a database driven program. I went through a video tutorial and designed a database example that worked fine, so i used the exact same structure to design my own.
I have a list box that recieves the list of Groups(Its for a field trip schedule), then each control on the form, the list box, text boxes for group member names etc. is databound to a binding source, this binding source is in turn, bound to the instance of my dataset.

In the tutorial we used this code to save the data:

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

and it worked fine, i have added this code, but changed the names to my own:

Me.GroupsBindingSource.EndEdit()
Me.GroupsTableAdapter1.Update(Me.GroupsDataSet1.Groups)

but it still doesn't work. When I load the form i fill the instance of the table adapter that's on my form via:

Me.GroupsTableAdapter1.Fill(Me.GroupsDataSet1.Groups)

Which in turn fills my Listbox and controls. When I change something in runtime, eg Group Name, the change shows on my onscreen data, but when i close and reopen the data its all back to the default and nothing has been permanently saved.

Thanks in advance for your help.

Posted by The ANZAC

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

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

Dave Kreskowiak27-Sep-06 2:22

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

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

Dave Kreskowiak28-Sep-06 3:45

Regardin displaying parent node

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

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

Looping through controls using FOR EACH

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

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