is there wrong code? please me out.
protected void button_click(object sender, eventargs e) { string cs = "data source=sfsind0402;initial catalog=testdb;integrated security=sspi;provider=microsoft.ace.oledb.12.0"; oledbconnection conn = new oledbconnection(cs); conn.open(); oledbcommand insert = conn.createcommand(); insert.commandtext="insert employee(id, name, sex, salary) values('003','vedpathi','m',25000)"; insert.connection = conn; insert.executenonquery(); conn.close(); } i getting following error:
multiple-step ole db operation generated errors. check each ole db status value, if available. no work done
(on line 22:conn.open();)
when connecting ms sql database, use ms sql providers:
using (var connection = new sqlconnection(connectionstring)) { connection.open(); var cmd = new sqlcommand(commandtext, connection); cmd.executenonquery(); }
Comments
Post a Comment