how to use insert query in asp.net for ms access database? can any one say?

Question

con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=database1.mdb;")
con.Open()
cmd = New OleDbCommand("insert into number values ('name','03/03/10',str)", con)
cmd.ExecuteNonQuery()
con.Close()
i am using the database Ms-access contains table named number it has values are name as text,date as date/time, value as integer..
if i execute the above query that gives Syntax error in INSERT INTO statement. error
how can rectify that problem?
can anyone help me?

thanks for all

Answer 1

I think you have variable str already declared and intialized to some integer value..

If thats the case than use this line:

cmd = New OleDbCommand("insert into number values ('name','03/03/10',"+str+")", con)



Even name appears to be a variable in your program.

If its true as well , than use this instead:

cmd = New OleDbCommand("insert into number values ('"+name+"','03/03/10',"+str+")", con)

Answer 2

If the transaction in the second database is approved, and it is being approved again, then you need to have a reference link between the 2 databases so that the original list of transactions can exclude records that already exist in the second database. By not doing this, then you are allowing multiple users to approve the same transaction. You need to prevent that from happening. Even if 2 users are approving the same transaction at the same time, one of them must execute first, and the second one must reject. To do that, you need to change the Select clause of your INSERT statement to LEFT JOIN to the destination table WHERE the transactionID is null. INSERT (.......) SELECT ........ FROM Array a LEFT JOIN Target t ON t.ID=a.ID WHERE t.ID IS NULL That will exclude any transaction that already exists in the target table. It sounds like you have an awkward system design there. You should be able to use replication or log shipping to keep the second database current. Good luck.

Answer 3

Hello

This is JARC InfoTech, providing service is Website/ Application Development for the last 4 year.

Our professionals have very rich experience in ASP.NET/SQL/SQL SERVER.

Please send us question with more details at following email ID to get a solution



email ID: [e-mail]

http://www.jarcinfotech.com

Answer 4

str is not defined, you either want 'str' or @str and add a parameter to the cmd.