string  cnnstr = "provider=OraOLEDB.Oracle;data source=yourdb;User Id=xxxx;Password=xxxx;";
   OleDbConnection con = new OleDbConnection(cnnstr);

   byte[] ddd;
   ddd = System.Text.Encoding.Unicode.GetBytes(this.textBox1.Text);
   string  strSQL = "update xlutest  set hhhh=:ddd "; 
   try
   {
    con.Open();
   }
   catch
   {} 
   OleDbCommand cmd = new OleDbCommand(cnnstr,con);

   cmd.CommandType=CommandType.Text;
   cmd.CommandText=strSQL;
   cmd.Parameters.Add("ddd",System.Data.OleDb.OleDbType.Binary ,ddd.Length).Value= ddd;
   cmd.ExecuteNonQuery();
   MessageBox.Show("OK!");
  }

 }
}

上一页  [1] [2]