Working with a data grind in visual studio-Visual Basic 2008 with an SQL 2008 database.

                 Here’s the deal. This is a VB 2008 Windows Application project with an SQL 2008 database, and I am comparing what I can do with a “data grid view”, with what I can do in a “details view” from the data sources.
                  When I use the details view, I notice that the cells are actually text boxes which gives me access to their contents programmatically speaking. I could code in a multiplication function like

Dim Result_A As Integer
Result_A  =  textbox_A.Text * 110
Label_A = Result_A

                   Is there a way for me to get access to the contents of the cells in a row (record) if the view is a Data Grid View, and write functions similar to those in the Details view?                    
jampostGeneral MaanagerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
EYoungConnect With a Mentor Commented:
Are you trying to define your DataGridView control as a decimal value?  If yes, you can't do that.  You need to define the DGV as a DGV and the variable separately as a decimal.  That is why the RowCount is not a member.
0
 
EYoungCommented:
Yes.  Here is an example I have used that allows me to retrieve the contents of a particular DGV cell:


    Private Sub dgvMembers_and_Guests_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles dgvMembers_and_Guests.Click
        'First test for rows present then select the appropriate tab on the form based on the Membership Type
        If dgvMembers_and_Guests.RowCount > 0 Then
            mKey = Trim(dgvMembers_and_Guests.CurrentRow.Cells(0).Value)
            mMember_Type = Trim(dgvMembers_and_Guests.CurrentRow.Cells(1).Value)
            srFill_Screen()
        Else
            mKey = ""
            mMember_Type = ""
            srClear_Screen()
        End If

        btnExit.Focus()
    End Sub


This returns the values of the first and second cells on the current row that the user clicks in the Data Grid View.
0
 
jampostGeneral MaanagerAuthor Commented:
EYoung,
      Just wanted to let you know that I am working on this. So far I replaced your dgv name with mine, and I had ti declare mine.  I added:
Dim dgvCreditorAccounts As New dgvCreditorAccounts
Now I have to some how define dgvCreditorAccounts  I admit I am not a pro and I have to research things every now and then.  
 
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
jampostGeneral MaanagerAuthor Commented:
EYoung,
I am working with Dollars & Cents which means I need the Decimal data type. RowCount is not a member of Decimal. There probably is a way of getting around this though.
0
 
EYoungCommented:
Now sure why you want to use a RowCount as a member of Decimal.  I only use RowCount to confirm that there are rows in the DGV.

You can define a memory variable as a decimal, i.e.
Dim mDecimal_Value As Decimal

Then:
mDecimal_Value = Trim(dgvCreditorAccounts.CurrentRow.Cells(0).Value)
0
 
jampostGeneral MaanagerAuthor Commented:
EYoung,
 
As a way of declaring and defining I wrote:
Dim dgvCreditorAccounts As Decimal
If dgvCreditorAccounts .RowCount > 0 Then                  < problem on this line [Rowcount is not a member of Decimal]
Is there another type that will allow 2 decimal places to the right of the decimal point? The data will be money.
0
 
jampostGeneral MaanagerAuthor Commented:
Thank you for the help EYoung. I believe I know what to do on this one.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.