How to Set a cell Value in a New Row

115

Jeff posted over 14 years ago

Hi,

I cannot figure out how to set the value of a specific cell in a new row to the value of a variable. Any ideas? Thanks! Here's the code I have:

Protected Sub btnAddParent_Click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEventArgs)

Dim BusinessName As String

'Set the variable to the value of the first row, first column:
BusinessName = grdDetail.DisplayLayout.Rows(0).Cells(1).Value

hfCellToFocus.Value = 1

grdDetail.Rows.FromKey(0).Cells(1).Text = BusinessName 'THIS DOESN'T WORK, I get a message that says "Object reference not set to an instance of an object".

End Sub

14517

Offline Valerie S posted over 14 years ago in reply to Jeff

Hello,

Please let me know more information on how you are adding the row and what your requirements are so that I can be of further assistance.

Thanks,

Valerie
Cancel
Reply

Cancel
115

Jeff posted over 14 years ago in reply to Valerie S

Thanks Valerie,

How do I code that? I've tried these with no luck...

grdDetail.Rows.FromDataKey(0) = sBusinessName
grdDetail.Rows.FromDataKey("BusinessName") = sBusinessName

How does it know I want to set the "NEW" row BusinessName cell with the value of sBusinessName?
Cancel
Reply

Cancel
14517

Offline Valerie S posted over 14 years ago

Hello,

Your best option is to use the FromDataKey method or the index of the rows collection to find the row to update.

Please let me know if you have any questions.

Thanks,

Valerie
Cancel
Reply

Cancel