using System.Data.OleDb;

string ConnectionString="Provider=MSDAORA.1;Data Source=;User Id=user;Password=pwd;";
OleDbConnection conn=new OleDbConnection(ConnectionString);//创建一个新连接
conn.Open();


OleDbCommand cmd=new OleDbCommand("select count(*) from Emp",conn);
int count=Convert.ToInt32(cmd.ExecuteScalar());
Response.Write(count);



cmd.CommandText="update emp set emp_name='test' where emp_name='wangqiang'";    //在这儿写sql语句
cmd.ExecuteNonQuery();


cmd.CommandText="select emp_name from Emp";    //在这儿写sql语句                                         
OleDbDataReader odr=cmd.ExecuteReader();    //创建一个OracleDateReader对象                                              
while(odr.Read())    //读取数据，如果odr.Read()返回为false的话，就说明到记录集的尾部了                                   
{                                                                                                                           
    Response.Write(odr.GetString(0).ToString()+"<BR>");    //输出字段1，这个数是字段索引，具体怎么使用字段名还有待研究
}                                                                                                                           
                                                                         


conn.Close();

和sql 一样