datagrid

[vengaqua]

how to delete from datagrid? and also i want to display the value of a row in txtbox by double clicking on the row or single click.all this in vb.net.

Mohinder Singh

[vbdotnetcoder2005]

As far as deleting from a data grid it depends on how you are populating the data grid and how you normally delete rows from you database. I usually use straight SQL statements with a OleDbCommand, so it that case you would execute the command and then refresh the datagrid to redisplay your results. I'm just guessing but it sounds like you might be trying to delete the row in the data grid that user selected? You can get the selected value of a column in a row based on a double click like this: dgResults.Item(dgResults.CurrentRowIndex, 4) I do this on a double click, and this should give you the selected value you need. Good Luck, Curtis

[vengaqua]

what is dgresults in this dgResults.Item(dgResults.CurrentRowIndex, 4). can u explain this a lillte bit...

Mohinder Singh

[vengaqua]

and i want the value to be displayed in txtbox....

Mohinder Singh

[vbdotnetcoder2005]

vengaqua wrote:

what is dgresults in this dgResults.Item(dgResults.CurrentRowIndex, 4). can u explain this a lillte bit...

Sorry, I should have mentioned that. dgresults is the name of the datagrid. The item will return a datagrid item which requires you to pass it a rowindex and a column index. So I used the currentrowindex of my datagrid and then passed it the column I wanted in this case it was column index of 4. You can also see an example here on MSDN: http://msdn2.microsoft.com/en-us/library/wdze7s55.aspx

[vengaqua]

thanks

Mohinder Singh