Hi! Can sum1 plz help?!!!
here is the prob I'm havingSQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters
.
First of all Next Time start a new Thread.
My first guess would be that the table PatientTable has more columns than the ones you have at your INSERT query. Personally I always use this syntax:
INSERT into PatientTable (col1, col2, ..) values ('a', 'b', ...);
In that way you know what value goes where and you can omit some columns. I think that with your coding all the columns of the table need to have a value at the "insert" query, but with my way the table can have 10 columns (for example) and you can insert a new row by giving only value to one of the columns. Of course the columns that you leave empty must not have any NOT NULL
constraints.
INSERT into PatientTable (col1, col2, col3) values ('a', 'b', 'c');
INSERT into PatientTable (col1) values ('a');
Of course knowing the structure of your table would help