Форум программистов [Powered by Invision Power Board]

Код

namespace WindowsFormsApplication
{
    public partial class Form1 : Form
    {
        OracleDataAdapter myDataAdapter;
        OracleConnection myAccessConn = null;
        OracleCommand myAccessCommand;
        OracleCommandBuilder da;
        DataSet myDataSet;
  
        public Form1()
        {
        InitializeComponent();
        string strAccessConn = "Data Source=db_name;
        User ID=user;Password=password;Unicode=True;";
        string strAccessSelect = "SELECT col1 FROM table";
        myDataSet = new DataSet();
        myAccessConn = new OracleConnection(strAccessConn);
        myAccessConn.Open();
        myAccessCommand = new OracleCommand(strAccessSelect, 
        myAccessConn);
        myDataAdapter = new OracleDataAdapter(myAccessCommand);
        da = new OracleCommandBuilder(myDataAdapter);
        myDataAdapter.Fill(myDataSet);
       }