using System;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
namespace DataReader
{
class Class1
{
[STAThread]
static void Main(string[] args)
{
string strConn="Provider=SQLOLEDB;User ID=sa;Password=password;Initial Catalog=vins;Data Source=211.236.186.207;";
//OleDbConnection Cn = new OleDbConnection(strConn);
string StrSQL =" Select top 1 IDX, Pwd, Name From PdsBoard ";
OleDbDataAdapter daPDS = new OleDbDataAdapter(StrSQL, strConn);
daPDS.RowUpdated += new OleDbRowUpdatedEventHandler(da_RowUpdated);
daPDS.RowUpdating += new OleDbRowUpdatingEventHandler(da_RowUpdating);
DataTable tbl = new DataTable("PDSBoard");
daPDS.Fill(tbl);
OleDbCommandBuilder cb = new OleDbCommandBuilder(daPDS);
tbl.Rows[0]["Pwd"] = "test" + (string)tbl.Rows[0]["Pwd"];
daPDS.Update(tbl);
tbl.Rows[0]["Pwd"] = "test";
daPDS.Update(tbl);
tbl.Rows[0]["Name"] = "by Vins";
daPDS.Update(tbl);
}
static void da_RowUpdated(object sender, OleDbRowUpdatedEventArgs e)
{
Console.WriteLine("RowUpdate Event : " + e.StatementType.ToString());
Console.WriteLine("\t" + "IDX = " + e.Row["IDX"]);
if(e.Status==UpdateStatus.ErrorsOccurred)
{
Console.WriteLine("\t오류발생");
}else{
Console.WriteLine("\t처리완료!");
Console.WriteLine();
}
}
static void da_RowUpdating(object sender, OleDbRowUpdatingEventArgs e)
{
Console.WriteLine("RowUpdate Event : " + e.StatementType.ToString());
Console.WriteLine("\t" + "IDX = " + e.Row["IDX"]);
Console.WriteLine("\t" + "Pwd = " + e.Row["Pwd", DataRowVersion.Original]);
Console.WriteLine("\t" + "Pwd = " + e.Row["Pwd", DataRowVersion.Current]);
Console.WriteLine();
}
}
}
g
