[2005] assigning "null" to an item in a datarow?

[Desolator144]

Apparently this isn't how you do it

NewRow = TheTable.addrow
                    NewRow.Item(2) = DBNull 'this doesn't work
'and this parser shouldn't have used lastindexof apostrophe :P

so how do you stick a null value in there?

[Fromethius]

did u try just null?

[Harsh Gupta]

Umm, Shouldn't it be Nothing??

[Fromethius]

potatoe patata. point is.. try different stuff

[Desolator144]

the thing is, dbnull should have worked. I think if I assign it to nothing it will try to destroy that datarow.item object and I would try different things except I can't test this at all for reasons I won't get into cuz it's a loooong story so i need to make sure it's correct ahead of time

[Fromethius]

well that sucks.. u can't like.. copy the file and use that one as a test file?

[Desolator144]

does this look right?

Dim TheNull As DBNull
        For x As Integer = 0 To tblQues.Rows.Count - 1
            tblQues.Rows(x).Item(1) = TheNull
        Next

cuz it's giving me the "that's a little iffy" squigglies :P

and I can't test it cuz I can't import a test from csv file into this database because I used my export test to make it and I don't want to double up tests cuz my management studio is broken (or more likely my mdf file) so I can't easily delete a whole new test cuz it spans 4 tables so I need to alter the csv file myself and import it into another copy of this database then toss that one if it works and make another copy of the original so my instructor can test the import without actually adding it to the original database. See told you it was complicated.

[jmcilhinney]

DBNull is a class, so you can't just assign DBNull to a field. DBNull is the type of the object stored in a null field, not the value of the object.

tblQues.Rows(x).Item(1) = DBNull.Value

[Desolator144]

w00t! you're a genius Here I got you one of those new vehicles that runs on corn. It's a slightly older model though...