Member Avatar for calquan

I am creating a access database programatically using c# .
in one of the table i want a coloumn of type boolean / bool / Yes/No.
Can any body help ?

OleDbCommand xCommand = new OleDbCommand
("CREATE TABLE xEntityParam(xName char(255) ,xKey ???????? )", xConnection);

xCommand.ExecuteNonQuery();

I am using OLEDB.
I prefer not to use ADOX, that will be my next option.

  • 2 Contributors
  • 1 Reply
  • 55 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by nick.crane
Member Avatar for nick.crane

Try "bit" that's what it is for SQL.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.