?
Solved

vb.net 2003 datagrid validate current cell against another dataset value

Posted on 2009-04-02
9
Medium Priority
?
643 Views
Last Modified: 2012-08-14
I have a datagrid that fills from a load button then  we will scan a barcode label in the first column of the datagrid i want it to validate that value against DSBC1 dataset to see if it is valid. how do i get the current cell value and validate that value.


here is my load code for the datagrid.
  Private Sub LoadBtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LoadBtn.Click
        Me.SqlSelectCommand1.Parameters("@Cuttxt").Value = Me.CutIdtxt.Text
        Me.lblmarker.DataBindings.Clear()
        Me.lblmarker.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.CutDetailsDS1, "VwCutTicketDetails.Actual Marker"))
        Me.SqlSelectCommand2.Parameters("@Cuttxt").Value = Me.CutIdtxt.Text
        Me.ScrapDS1.ScrapTable.Columns("CutID").DefaultValue = Me.CutIdtxt.Text
        Me.SqlDataAdapter1.Fill(Me.ScrapDS1)
       
 
        Me.SqlDataAdapter2.Fill(Me.CutDetailsDS1)
        Me.ScrapDS1.ScrapTable.Columns("Item").DefaultValue = Me.lblfab.Text
        Me.lblfab.ForeColor = System.Drawing.Color.Red
        If Me.lblmarker.Text = Me.ToString.Empty Then
            Me.lblmarker.DataBindings.Clear()
            Me.lblmarker.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.CutDetailsDS1, "VwCutTicketDetails.Marker"))
        End If
 
        Me.DataGrid1.Focus()
 
    End Sub

Open in new window

0
Comment
Question by:PAMHART
[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
  • 4
9 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 24058527
When do you want to validate? At what event? Would it be selected row only or for the whole data grid?
0
 

Author Comment

by:PAMHART
ID: 24059877
row only
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 24059936
I do not understand your code fully but here is an example. I hope you can modify it according to your requirements.

btnValidate.Press:

if grid1.Selectedrows.count = 1 Then
   DSBC1.tables(0).defaultview.rowfilter = "ClientID=" & grid1.SelectedRows(0).Cells(0).Value
   if DSBC1.Tables(0).DefaultView.Count > 0 then
      'The ClientID exists
   Else
      'The ClientID does not exist
   End if
   DSBC1.Tables(0).DefaultView.RowFilter = ""
End If
0
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.

 

Author Comment

by:PAMHART
ID: 24077205
error with selectrows not part of system window form datagrid1
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 24077542
Are you using DataGridView?
0
 

Author Comment

by:PAMHART
ID: 24077659
no, i am using vb.net 2003 with just a datagrid on a window form.
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 2000 total points
ID: 24077706
Try this then

if grid1.CurrentRowIndex >= 0 Then
   DSBC1.tables(0).defaultview.rowfilter = "ClientID=" & grid1.Item(Grid1.CurrentRowIndex, 0)
   if DSBC1.Tables(0).DefaultView.Count > 0 then
      'The ClientID exists
   Else
      'The ClientID does not exist
   End if
   DSBC1.Tables(0).DefaultView.RowFilter = ""
End If
0
 

Author Closing Comment

by:PAMHART
ID: 31565980
Thanks for the help.
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 24077959
My Pleasure.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

800 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