Adapter. InsertCommand

  OleDbConnection connection = new OleDbConnection("Provider=System.Data.SqlClient;Data Source=MSSERV;Initial Catalog=JoinExel;Integrated Security=True");// ConfigurationManager.ConnectionStrings["AccessMTSP"].ConnectionString;
            OleDbDataAdapter adapter = new OleDbDataAdapter();
 
            try{
                    adapter.InsertCommand = new OleDbCommand("insert into test (q,w,e) values (q=?,w=?,e=?) ");
                    adapter.InsertCommand.Parameters.Add("q", OleDbType.VarChar, 50, "Q1");
                    adapter.InsertCommand.Parameters.Add("w", OleDbType.VarChar,50, "W1");
                    adapter.InsertCommand.Parameters.Add("e", OleDbType.VarChar, 50, "E1");
            
                    adapter.InsertCommand.Connection = connection;
 
                    adapter.Update(data.Tables[0]);
            }
            catch (Exception ex)
            {
            MessageBox.Show(ex.Message.ToString());
            }
MessageBox.Show("ok");