Object can not be cast from the DBNull to the other type errors

[10533]

HI,

There are 2tables in the "mydatabse" .

1. Tools
2. ToolsRepair

there are some columns in the above two tables.

Toolid is the primary key of the Tools table and also FK for the ToolsRepair
and also there are some other columns in the two tables

I am trying to insert the all details of the ToolsRepair table using that FK_ Toolid

but I am getting the error,

Cannot insert the value NULL into column 'Tool_id', table 'ToolApp.dbo.To olsRepair'; column does not allow nulls. INSERT fails. The statement has been terminated.

please help me out...
thanks in advance

[tlhintoq]

The table doesn't allow nulls. You want to use a null. What advice do you want? The table won't allow it. Put in something else.

[10533]

Thank you, thats I understand, am new to C sharp coding

SO could you please explain me more clearly??

thanks.

[tlhintoq]

No. I don't think I could be any more clear than that.

If the table doesn't allow nulls, then you can't force it to accept them.

Database How-to parts 1 and 2
Database tutorial Part 1
Database tutorial Part 2