table.rows(1)(1)=nothing???

How do i make my program know if a certain entry in a table doesnt exists, aka null, aka nothing?? I tried doing

Code:

---

If table.rows(1)(1).contains("") Then
Do it
End If

---

and i also tried

Code:

---

If table.rows(1)(1).contains(nothing) Then
do it
end if

---

Both times i got the same error "Public member on "Contains" on type double not found"....


I imported an excel database, into the table, so i don't know what it thinks it is, or what the data type is... SO any information about this, or any suggestions would help!

Try this:

Code:

---

If IsDBNull(table.rows(1)(1)) Then
    Do it
End If

---

Not sure about the whole "table.rows(1)(1)" but the IsDBNull part is correct.

i've not seen that syntax either. how is it read?

YOu alwaus should use column name for rows in a DataTable, because you may need in some point to move into SQLDB/XML data storing, where while writing code for creating columns changing the order columns are putten into the table may deffer from method to method, which makes using index for column identication is irreliable.
Also using column name makes your code more readable and organized :D

Quote:

---

Originally posted by Andy
i've not seen that syntax either. how is it read?

---

Code:

---

table.rows(1)(1)

---

is just a faster way for writing

Code:

---

table.rows(1).items(1)

---

Quote:

---

Originally posted by Andy
i've not seen that syntax either. how is it read?

---

Code:

---

table.rows(1)(1)

---

is just a faster way for writing

Code:

---

table.rows(1).items(1)

---