Data Grid view cell content click error

Question

3.00/5 (1 vote)

See more:

I have created 2 forms 1.EmpPerInfo 2.Search, When user click on "Search" button of EmpPerInfo form then Search form will be open. Then user will put EmpNo. & click on find button.Then matched row/record will be displayed in Gridview.

Code for above mentioned steps are working fine.but Now I want when user click on Name column of Data Grid View system will show that record in "EmpPerInfo" form for this i have written below mentioned code.

VB

Private Sub DataGridView1_CellContentClick(sender As System.Object, e As System.Windows.Forms.DataGridViewCellEventArgs) Handles EmployeeGrid.CellContentClick
       If (e.ColumnIndex <> -1) Then
           If (e.RowIndex > -1) Then
               EmpNo = e.RowIndex

               EmpPerInfo.txtSrn.Text = dt.Rows(EmpNo).ItemArray(0).ToString()
               EmpPerInfo.txtFullName.Text = dt.Rows(EmpNo).ItemArray(2).ToString()
               EmpPerInfo.Show()

               
           End If
       End If
   End Sub

but "EmpPerInfo.txtSrn.Text = dt.Rows(EmpNo).ItemArray(0).ToString()" at this statement system throws an error "There is no row at position 0"

.

Posted 22-Dec-13 20:33pm

Yogi ,Pune

Updated 22-Dec-13 22:29pm

v2

Add a Solution

Comments

jackspero18 23-Dec-13 2:39am

ok now when you click on row then you want the info on the EmpperInfo of the selected row..??

Yogi ,Pune 23-Dec-13 2:45am

Yes

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-12-23T04:10:00

First of all, searching algorithm is inefficient. Rather then looping through the collection of rows, filter data using SELECT method[^].
Here is another method: DataGridView Filter[^]

Second of all, there are few ways to pass data between forms:
Passing Data Between Objects in an Application[^]
Walkthrough: Passing Data Between Windows Forms[^]
Pass values between windows forms[^]

Mr.TMG · Answer 2 · 2013-12-23T04:06:00

There is no position 0 in data grid view.
When the user clicks on the column name, It counts as a click event. Since A row was not clicked the row is set to 0.

Try this

VB

Private Sub DataGridView1_CellContentClick(sender As System.Object, e As System.Windows.Forms.DataGridViewCellEventArgs) Handles EmployeeGrid.CellContentClick
       
           If (e.RowIndex > 0) Then
               EmpNo = e.RowIndex
 
               EmpPerInfo.txtSrn.Text = dt.Rows(EmpNo).ItemArray(0).ToString()
               EmpPerInfo.txtFullName.Text = dt.Rows(EmpNo).ItemArray(2).ToString()
               EmpPerInfo.Show()
 
               
           End If
      
   End Sub

Data Grid view cell content click error

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0