1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(oradb);
/* ouverture de la connection */
conn.Open();
/* requete */
string sql = " SELECT TYPE , SOUSTYPE, ETAT, ORIGINE, QUANTITE, MAJ, EMAIL FROM TABLE WHERE ID = " + 23 + "";
/* creation de l'objet OracleCommand */
System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(sql, conn);
System.Data.OracleClient.OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
/* libaration des ressources */
conn.Close(); |
Partager