1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
private void btnRechercher_Click(object sender, EventArgs e)
{
//ArrayList sequence = new ArrayList();
List<MyDetails> sequence = new List<MyDetails>();
string connString = GetConnectionString();
OracleConnection oraConn = new OracleConnection();
try
{
oraConn.ConnectionString = connString;
OracleCommand cmd = new OracleCommand();
cmd.Connection = oraConn;
cmd.CommandText =
"SELECT COL1, COL2, COL3 FROM MATABLE WHERE COL1= 3 AND COL2= 1 AND COL3= 3";
oraConn.Open();
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
MyDetails m = new MyDetails();
m.Id = Convert.ToInt32(reader[0]);
m.Name = reader[1].ToString();
m.Age = Convert.ToInt32(reader[2]);
sequence.Add(m);
}
dataGridViewStat.DataSource = sequence;
}
finally
{
oraConn.Close();
} |