Solved

help using dataviewgrid for selected items on form

Posted on 2010-09-22
8
256 Views
Last Modified: 2012-05-10
Hi,
   I am creating an EPOS system and I have a series of buttons on my form.  When someone clicks a button I want the following to be added under columns on the dataviewgrid1 component:

Description
Quantity
Price
Vat

Then when another button is clicked, on another line the new item etc

How can I do this?

Thanks
0
Comment
Question by:damianb123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33733594
Hi.
You mean DatagridView?
0
 

Author Comment

by:damianb123
ID: 33733611
Yup - sorry!!!
0
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33733692
try this in form LoadEvent...(if i understand well)
 Dim txt1, txt2, txt3, txt4 As New DataGridViewTextBoxColumn
        txt1.Name = "Description"
        txt2.Name = "Quantity"
        txt3.Name = "Price"
        txt4.Name = "Vat"

        Me.DataGridView1.Columns.Insert(0, txt1)
        Me.DataGridView1.Columns.Insert(1, txt2)
        Me.DataGridView1.Columns.Insert(2, txt3)
        Me.DataGridView1.Columns.Insert(3, txt4)

Open in new window

0
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

Author Comment

by:damianb123
ID: 33733767
jtoutou,
    that works great, thanks.  Now what i need to do is have the system so that when a button is clicked the details are added to the form.....  This is the code I used on a previous project, however the description was only piped to a txt box and not multiple columns.  
Multiple buttons need to be capable of adding multiple rows.....

Thanks
0
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33734462
Sorry for the delay .....ok we have the column ....now for the cells....
 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim dgvRow As New DataGridViewRow
        Dim dgvCell As DataGridViewCell

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomeDescription"
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomeQuantity"
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomePrice"
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomeVat"
        dgvRow.Cells.Add(dgvCell)

        DataGridView1.Rows.Add(dgvRow)

    End Sub

Open in new window

0
 
LVL 18

Accepted Solution

by:
John (Yiannis) Toutountzoglou earned 500 total points
ID: 33734919
And just a note:Rows cannot be added programatically to the datagridview's collection when control is databound!!!!!we are talking now about custom Datagridview.....


in this case lets say we have to buttons....just do the same job with defferent text...
 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim dgvRow As New DataGridViewRow
        Dim dgvCell As DataGridViewCell

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomeDescription"
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomeQuantity"
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomePrice"
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomeVat"
        dgvRow.Cells.Add(dgvCell)

      
        Me.DataGridView1.Rows.Add(dgvRow)

    End Sub

    Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
        Dim dgvRow As New DataGridViewRow
        Dim dgvCell As DataGridViewCell

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomeDescription2"
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomeQuantity2"
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomePrice2"
        dgvRow.Cells.Add(dgvCell)

        dgvCell = New DataGridViewTextBoxCell()
        dgvCell.Value = "SomeVat2"
        dgvRow.Cells.Add(dgvCell)


        Me.DataGridView1.Rows.Add(dgvRow)
    End Sub

Open in new window

0
 

Author Closing Comment

by:damianb123
ID: 33781408
This worked perfectly, thanks very much for all your help!
0
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33782052
very welcome.....very glad helping you
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

697 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question