C#

String sqltext = "Select artext from tbl_ar"; // artext is
   // varchar2(30 char)
DataTable schTable;
OracleDataReader rdr = null;


OracleCommand cmd = new OracleCommand (sqltext, OracleConnection, OracleTransaction);
rdr = cmd.ExecuteReader(CommandBehavior.KeyInfo);
schTable = rdr.GetSchemaTable();  // Here the DataTable is filled with the
    //  information of the columns
DataRow fldDescr = schTable.Rows[0];
int len = (int) fldDescr[2]; 	    // 2 = ColumnSize

SqlConnection conn = new SqlConnection(some connection);
                   conn.Open();
                   SqlDataAdapter da = new SqlDataAdapter("Select * FROM Table", conn);
                   SqlCommandBuilder MyCB = new SqlCommandBuilder(da);
                   DataSet ds = new DataSet("Table");
                   da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
                   FileStream fs = new FileStream(@"C:\\PDFdocument"+"\\" + PDF, FileMode.OpenOrCreate, FileAccess.Read);
                   byte[] myData = new byte[fs.Length];
                   fs.Read(myData, 0, System.Convert.ToInt32(fs.Length));

                   fs.Close();
                   da.Fill(ds, "Table");

                   DataRow myRow;
                   myRow = ds.Tables["Table"].NewRow();
                   myRow["Document"] = myData;
                   myRow["ID"] = fileID;
                   ds.Tables["Table"].Rows.Add(myRow);
                   da.Update(ds, "Table");

private void Form1_Load(object sender, EventArgs e)
{
     this.kisiTableAdapter.Fill(this.denekDataSet.Kisi);
   
     denekDataSet.Kisi.KisiRowChanged += new denekDataSet.KisiRowChangeEventHandler(Kisi_KisiRowChanged);

}


void Kisi_KisiRowChanged(object sender, denekDataSet.KisiRowChangeEvent e)
        {
            DataRowAction drc = e.Action;
            if (drc == DataRowAction.Change)
            {
                DialogResult dr = MessageBox.Show("do you want to save changes!", "warning", MessageBoxButtons.YesNo);
                if (dr == DialogResult.No)
                {
                    e.Row.RejectChanges();

                }
     
            }
        }

void Kisi_KisiRowChanged(object sender, denekDataSet.KisiRowChangeEvent e)
        {
            DataRowAction drc = e.Action;
            if (drc == DataRowAction.Change)
            {
                DialogResult dr = MessageBox.Show("do you want to save changes!", "warning", MessageBoxButtons.YesNo);
                if (dr == DialogResult.No)
                {
                    e.Row.RejectChanges();

                }else 
                {
                   kisiTableAdapter.Update(denekDataSet.Kisi);
                }

     
            }
        }