Ad:

VB.NET Discussion Thread
Unsolved
Views: 1711

Oct 3rd, 2008

Data grid urgent help....very urgent

Expand Post »

hello,
I get my values displayed in the datagrid on the click of search button.
In that datagrid there are several fields....among them one is the ID field....
When i click on the ID field that id should get displayed in the ID TEXT FIELD...
Well, below is the code for the same which i have wrote on the Cell click event
Help with Code Tags
(Toggle Plain Text)

Dim i = e.RowIndex
Dim j = e.ColumnIndex
txtefid.Text = dgfacenq.Item(i, j).Value

Dim i = e.RowIndex Dim j = e.ColumnIndex txtefid.Text = dgfacenq.Item(i, j).Value

HOWEVER THE PROBLEM IS that when i get more thatn 1 row displayed in the datagrid and if i click on any row except row 1 , the value of that ID is not displayed in the textfield !

Whats the prob?? any problem regarding increment ??

PLZ HELP ME OUT ITS VERY URGENT !!! PLZZZ WHT SHOULD ID DO TO OVERCUM THIS PROB ??

CYA
ROHAN

Similar Threads

Creating a popup menu on mouse over in JavaScript / DHTML / AJAX
dropdown list in VB.NET
data grid.... very urgent...... in C#
search problem in vb in Visual Basic 4 / 5 / 6
asp.net help needed URGENT in ASP.NET

laghaterohan

Reputation Points: 10

Solved Threads: 2

Junior Poster

Offline

170 posts
since Aug 2008

Permalink

Oct 3rd, 2008

Re: Data grid urgent help....very urgent

You only handle one value with what you have here. Think about it - how many i's can you have with what you have below? How many j's?

I understand you think since i,j would be different for each row,column that you have it covered but you only have one of each specified. In addition, you don't have anything like a foreach or any other statement that will iterate through more than the first one. How does the program know that you have more than one and to grab them as well?

Maybe you have more code that you didn't post?

Quote ...

Dim i = e.RowIndex
Dim j = e.ColumnIndex
txtefid.Text = dgfacenq.Item(i, j).Value

/// You did realize that this was the same thing repeated right after the first just in a different look right?

Quote ...

Dim i = e.RowIndex Dim j = e.ColumnIndex txtefid.Text = dgfacenq.Item(i, j).Value

In effect if you have this code this way in your program you've just done this

VB.NET Syntax (Toggle Plain Text)
        Dim i = e.RowIndex
        Dim j = e.ColumnIndex
        txtefid.Text = dgfacenq.Item(i, j).Value 
 
        Dim i = e.RowIndex
        Dim j = e.ColumnIndex
        txtefid.Text = dgfacenq.Item(i, j).Value
        Dim i = e.RowIndex
        Dim j = e.ColumnIndex
        txtefid.Text = dgfacenq.Item(i, j).Value 
        
        Dim i = e.RowIndex
        Dim j = e.ColumnIndex
        txtefid.Text = dgfacenq.Item(i, j).Value

Last edited by rapture; Oct 3rd, 2008 at 3:40 pm.

rapture

Reputation Points: 155

Solved Threads: 41

Posting Whiz in Training

Offline

294 posts
since Jul 2007

Permalink

Oct 3rd, 2008

Re: Data grid urgent help....very urgent

Quote ...

When i click on the ID field that id should get displayed in the ID TEXT FIELD...

do you mean display it on TextBox? if yes then use MouseUp event handler inorder to know when user select the cell, and then display the cell content in textbox

VB.NET Syntax (Toggle Plain Text)
Private Sub DataGrid1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGrid1.MouseUp
        TextBox1.Text = DataGrid1.Item(DataGrid1.CurrentCell.RowNumber, NumOfIDColumn)
End Sub
Private Sub DataGrid1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGrid1.MouseUp
        TextBox1.Text = DataGrid1.Item(DataGrid1.CurrentCell.RowNumber, NumOfIDColumn)
End Sub

DataGrid1.CurrentCell.RowNumber will return current cell that user select
NumOfIDColumn refers to the ID column in your dataset if it's the first column then you will write

VB.NET Syntax (Toggle Plain Text)
DataGrid1.Item(DataGrid1.CurrentCell.RowNumber,0)
DataGrid1.Item(DataGrid1.CurrentCell.RowNumber,0)

Note that even when user clicked the Name column in first row , the program will still display the ID in textbox
see this link

I hope that will help you

Last edited by manal; Oct 3rd, 2008 at 8:39 pm.

manal

Reputation Points: 37

Solved Threads: 17

Junior Poster

Offline

122 posts
since Mar 2006

Permalink

Oct 5th, 2008

Re: Data grid urgent help....very urgent

thanks for your timely help!

cya
Rohan

Click to Expand / Collapse Quote originally posted by manal ...

do you mean display it on TextBox? if yes then use MouseUp event handler inorder to know when user select the cell, and then display the cell content in textbox
VB.NET Syntax (Toggle Plain Text)
Private Sub DataGrid1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGrid1.MouseUp
        TextBox1.Text = DataGrid1.Item(DataGrid1.CurrentCell.RowNumber, NumOfIDColumn)
End Sub
Private Sub DataGrid1_MouseUp(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGrid1.MouseUp TextBox1.Text = DataGrid1.Item(DataGrid1.CurrentCell.RowNumber, NumOfIDColumn) End Sub
DataGrid1.CurrentCell.RowNumber will return current cell that user select
NumOfIDColumn refers to the ID column in your dataset if it's the first column then you will write
VB.NET Syntax (Toggle Plain Text)
DataGrid1.Item(DataGrid1.CurrentCell.RowNumber,0)
DataGrid1.Item(DataGrid1.CurrentCell.RowNumber,0)
Note that even when user clicked the Name column in first row , the program will still display the ID in textbox
see this link

I hope that will help you

laghaterohan

Reputation Points: 10

Solved Threads: 2

Junior Poster

Offline

170 posts
since Aug 2008

Permalink

Oct 5th, 2008

Re: Data grid urgent help....very urgent

HI...i am not getting the desired output! i mean i am getting only errors.
Firstly have written that code under the MouseUp event of my datagrid .Is it necessary to write only under MouseUp? Why not under Cell Click / CellContent Click?

when i take my mouse over my id which is the first row in the datagrid nothing appears in the text box.
Yeah before that when i write this code :

VB.NET Syntax (Toggle Plain Text)
DataGrid1.Item(DataGrid1.CurrentCell.RowNumber,0)
DataGrid1.Item(DataGrid1.CurrentCell.RowNumber,0)

with ofcourse modification accordingly i get error as to System.........cannot convert to String. So i add

VB.NET Syntax (Toggle Plain Text)
DataGrid1.Item(DataGrid1.CurrentCell.RowNumber,0).ToString
DataGrid1.Item(DataGrid1.CurrentCell.RowNumber,0).ToString

Is it correct ??

If i click on the cell i get another bigggggggg error....

Plz help me out soon ! plzzzz awating your quick response..

C my prob is :
I search the name of the enq. . When the particular say xyz enq.is found it appears in the datagrid below along with its id and other details.
So now when i will click on the ID ( first Column,row in the datagrid) that same id should appear in the TEXTBOX.

Plzzzzzzzz help me out !

laghaterohan

Reputation Points: 10

Solved Threads: 2

Junior Poster

Offline

170 posts
since Aug 2008

Permalink

Oct 5th, 2008

Re: Data grid urgent help....very urgent

Quote ...

Is it necessary to write only under MouseUp? Why not under Cell Click / CellContent Click?

o, not necessary but I thought it will work
Because I remember that when I once used click event it was fired only when I click the header of datagrid not the cell content

, you can try (or search on net) for what each event do

manal

Reputation Points: 37

Solved Threads: 17

Junior Poster

Offline

122 posts
since Mar 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Will any one plz help me ??

Next Thread in VB.NET Forum Timeline: Visual basic programin 2008

DaniWeb Message

Cancel Changes

User Name
Password