Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2009-04-02
9
Medium Priority
?
645 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 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
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…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

618 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