Question how to insert a null value from db to db

[Raddict]

Hi,

it's been a while but I'm burning my fingers once again on databases

I'm trying to make a tool that copies records from one database to another similar database (SQL).

I made a form containing 2 datagrids, one as source and the other as target.

I try to use:

Me.ToolTableAdapter.Insert(DataGridView1.Item(1, 0).Value, DataGridView1.Item(2, 0).Value, DataGridView1.Item(3, 0).Value

But DataGridView1.Item(2, 0).Value for instance has no value. This seems to result in a "invalid cast exeption".

the type for the value is system.nullable(of short) according to vb.net

I hope someone can shed some light on this.

 

[Rocksteady]

Try setting the item value to System.DBNull.Value()

 

[Raddict]

I tried that but then I get:
Class 'System.DBNull' cannot be indexed because it has no default property.

 

[Rocksteady]

Is it your primary key? Are you trying to sort it?
That should have been System.DBNull.Value and not System.DBNull.Value().

 

[cjard]

Please explain why you list yourself as using VS2003 which doesnt have TableAdapters yet your code specifically uses a TableAdapter

If you have upgraded your Visual Studio, please update your profile