输入banner图图片脚本导航/分类

visual studio 2013连接Oracle 11g并获取数据:(二:实现)

void button1_Click(object sender, EventArgs e) { string connectionString; string queryString; connectionString = "Data Source=ORCL;User ID=scott;PassWord=tiger"; queryString = "SELECT * FROM TEST"; OracleConnection myConnection = new OracleConnection(connectionString); OracleCommand myCommand = myConnection.CreateCommand(); myCommand.CommandText = queryString; myConnection.Open(); OracleDataAdapter oraDA = new OracleDataAdapter(myCommand); DataSet ds = new DataSet(); oraDA.Fill(ds); myConnection.Close(); DataTable dtbl=ds.Tables[0]; this.dataGridView1.DataSource = dtbl; }

 

(4)运行,结果如下:

技术分享

和我的数据库中的数据一样

 

visual studio 2013连接Oracle 11g并获取数据:(二:实现)

标签: