I try to insert something into database (SQL server 2008). this is what I did so far.
could someone tell me does my connection string is correct? and what is the next step that actual execute the "insert" to database
thanks in advance
OleDbConnection cn_input = new OleDbConnection();
string ConnStr_input = "Provider = SQLNCLI10; Server = (local); Database = Pb_project; Integrated Security=SSPI; DataTypeCompatibility=80; MARS Connection=True;";
cn_input.ConnectionString = ConnStr_input;
string insert_db = "INSERT INTO [value_tmp] (subject_ID,location,value) VALUES (2013,'London','Tokyo')";