Null Data In DataGridView

[SorryDog777]

There is probably a simple answer for this question, but I have just run out of steam looking for the solution!

I have a unbound DataGridView on a form that a user populates. Some cells in the grid can contain null values.

I'm attempting to read the values from the cells to put into a custom database table with the below example:



Dim strCellString as String

strCellString = DataGridView1.Rows(1).Cells(1).Value.ToString


If the current is null the get the exception error. I also tried this statement

strCellString = IIf(DataGridView1.Rows(1).Cells(0).Value.ToString, DataGridView1.Rows(1).Cells(0).Value.ToString, "")

Also gives an exception.

Any suggestions to test for null without using the On Error, Resume Next statement?

Thanks.

 

[tperri]

You need to use the OnRowUpdating event and access the cells that way:

http://www.gridviewguy.com/ArticleDetails.aspx?articleID=139

 

[jebenson]

Use the IsDBNull function:

if not IsDbNull(DataGridView1.Rows(1).Cells(1).Value) Then
strCellString = DataGridView1.Rows(1).Cells(1).Value.ToString
End If

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day! Ye has a choice: talk like a pira