hi everyone
I have a number of tables (8) that i need to insert data into at almost the same time(thats how my user will see it). I have a form with tabpages they use to insert data into the tables.
I am using an insert store procedure to aid with all this. Now my problem is that i have a few datetimepickers my user uses to insert dates into the respective attributes,their data type is date. when i try to save the data i get the following error.
'Failed to convert parameter value from string to datetime'

I have also attached a sample of one of the datetimepickers i am using. Please help me sort this out.An example will be appreciated.

saveCommand.Parameters.AddWithValue("A_BOOKDATE", abookdatePicker1.Text).DbType = DbType.DateTime


Many Thanks in advance

Hi Slake,

Have you tried changing the code to use abookdatePicker1.Value instead, which gets the value as an actual DateTime?
There isn't always a direct link between what format a .NET control displays a date in and what SQL Server or another database expects it to be passed in as, so it is always best to pass an actual DateTime to the Parameter.Add methods whenever possible.

HTH
Phil

hi
i got it to work but im now faced with a new problem.
I have a procedure that handles all my inserts into the system. I make these inserts into the database using a Vb form. Now my problem is that when i click the save button the values a duplicated in the database. I cannot quite understand why thsi is the case.

Do you by any chance know why this so? Please advise. Look forward to hearing from you.

Kind Regards

Slake

Slake:

I just had a thought or two on your duplication of records, but you will have to read how to translate to VB.NET-ese. Check on the following:

• The state of the Cache especially after you have process that form page;
• Review how the rows are processed automatically. I can't remember the code u submitted in an earlier thread.

Just a thought or two.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.