用Oracle数据表绑定DataGrid
来源:岁月联盟
时间:2004-12-03
private void button1_Click(object sender, System.EventArgs e)
{
string ConnectionString="Data Source=sky;user=diamond;password=diamond;"; //写连接串
OracleConnection conn=new OracleConnection(ConnectionString); //创建一个新连接
OracleCommand cmd= new OracleCommand("select * from ETAM_USERS",conn);
DataSet ds = new DataSet();
OracleDataAdapter oda=new OracleDataAdapter();
oda.SelectCommand=cmd;
oda.Fill(ds);
conn.Close();
dg.DataSource=ds.Tables[0].DefaultView;
}