?
Solved

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

Posted on 2010-11-08
7
Medium Priority
?
355 Views
Last Modified: 2012-05-10
                 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?                    
0
Comment
Question by:jampost
[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
  • 4
  • 3
7 Comments
 
LVL 7

Expert Comment

by:EYoung
ID: 34089177
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
 

Author Comment

by:jampost
ID: 34089356
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
 

Author Comment

by:jampost
ID: 34089395
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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 7

Expert Comment

by:EYoung
ID: 34089476
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
 

Author Comment

by:jampost
ID: 34089720
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
 
LVL 7

Accepted Solution

by:
EYoung earned 2000 total points
ID: 34090426
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
 

Author Closing Comment

by:jampost
ID: 34091213
Thank you for the help EYoung. I believe I know what to do on this one.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

801 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