sql - Getting Error while connecting to DB using c# -


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