Loading

newbie :: missing primarykey exception?

x _sanctus

Dear All, i'm really new to .net and using database. I use access database using OleDbconnection I want to get a row from a table DataRow targetRow=member.Rows.Find(new Object[]{userId)}; but i got exception "the table don't have primary key" , but i'm sure i have set the primary key when creating the table. Please help..

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Andrzej Wegierski21y ago
May be, You dropped previous primary key definition (for instance by replacing created datatable with new one). May be primary key has null columns - this mistake doesnt't generate exception. Check for existance and columns in primary key - may be using debugger