C#

<br />
SqlConnection con = ...<br />
try {<br />
  using (SqlCommand cmd = new SqlCommand("INSERT ...", con)) {<br />
    // cmd.CommandType = CommandType.Text; Default is text, ut if you change to something else you should change this here.<br />
   cmd.ExecuteNonQuery();<br />
  }<br />
catch (SqlException ex) {<br />
   // Do stuff...<br />
}<br />
if (con != null) {<br />
   con.Dispose();<br />
   con = null;<br />
}<br />

<code>OleDbDataAdapter oleDbDataAdapter1 = new OleDbDataAdapter(cmd);
oldeDbDataAdapter1.InsertCommand = cmd; // <-- This line
oleDbDataAdapter1.InsertCommand.CommandText = 
"INSERT INTO Mailing (MailingField)" +
"VALUES ('"+ desc +"')";

string connStr = ConfigurationSettings.AppSettings["ConnectionString"];
string desc = txtMailing.Text;

OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\testing_K_\db1.mdb");
OleDbCommand cmd = new OleDbCommand();
 
// The ? in VALUES is a parameter placeholder
cmd.CommandText = "INSERT INTO Mailing (MailingField) VALUES (?)"; 
 
//open the bridge between the application and the datasource
con.Open();
 
// set the parameters (in the order they appear in the query
cmd.Parameters.Add("param1", desc);
 
//execute the qurey 
cmd.ExecuteNonQuery();
 
//close the connection
con.Close();