one more thing:the problem is that you insert into database and update empty columns with dbnull.value i think. there will be always problem because I can do inserts or updates without all columns. for example table has: id, col1, col2, col3... and when i query with "INSERT INTO [table] (col2) VALUES...