• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 649
  • Last Modified:

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

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
PAMHART
Asked:
PAMHART
  • 5
  • 4
1 Solution
 
CodeCruiserCommented:
When do you want to validate? At what event? Would it be selected row only or for the whole data grid?
0
 
PAMHARTAuthor Commented:
row only
0
 
CodeCruiserCommented:
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
PAMHARTAuthor Commented:
error with selectrows not part of system window form datagrid1
0
 
CodeCruiserCommented:
Are you using DataGridView?
0
 
PAMHARTAuthor Commented:
no, i am using vb.net 2003 with just a datagrid on a window form.
0
 
CodeCruiserCommented:
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
 
PAMHARTAuthor Commented:
Thanks for the help.
0
 
CodeCruiserCommented:
My Pleasure.
0

Featured Post

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.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now