Solved

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

Posted on 2009-04-02
9
641 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 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