access

[palanivel]

hi,


i am creating access database in VB.NET windows project.databas e field sname,salary,cn ame,cdate 4 columes . my windows form having 2 textbox only insert the value..

how to write the insert query....

pls very urgent reply me

[kenobewan]

I assume that you want an sql insert query - insert() values()?

[dip_developer]

hi,


i am creating access database in VB.NET windows project.databas e field sname,salary,cn ame,cdate 4 columes . my windows form having 2 textbox only insert the value..

how to write the insert query....

pls very urgent reply me

INSERT INTO myTable(sname,s alary,cname,cda te ) VALUES ('" & txtsname.Text & "'," & salary & ",'" & txtcname.Text & "',#" & Date.Now() & "#)