protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
{
int idx = DataList1.SelectedIndex;
Label lbl = (Label)DataList1.Items[idx].FindControl("Label2");
System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(ConfigurationManager.ConnectionStrings["CGConnectionString"].ToString());
System.Data.OracleClient.OracleCommand myCommand = new System.Data.OracleClient.OracleCommand("SELECT * FROM wf_cm_images WHERE ID = '" + lbl.Text + "'", conn);
conn.Open();
System.Data.OracleClient.OracleDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.Default);
try
{
while (myReader.Read())
{
System.Data.OracleClient.OracleLob myLob = myReader.GetOracleLob(myReader.GetOrdinal("IMAGE"));
if (!myLob.IsNull)
{
string FN = myReader.GetString(myReader.GetOrdinal("IMAGE_NAME"));
//Use buffer to transfer data
byte[] b = new byte[myLob.Length];
//Read data from database
myLob.Read(b, 0, (int)myLob.Length);
Response.AddHeader("content-disposition", "attachment;filename=" + FN);
Response.ContentType = "application/octectstream";
Response.BinaryWrite(b);
Response.End();
}
}
}
finally
{
myReader.Close();
conn.Close();
}
}
public override int GetOrdinal(string name)
{
return(rdr.GetOrdinal(name));
}
public void MinDate()
{
BeginCase("Test Min date.");
exp = null;
string[] dateColumns;
DateTime[] expectedValues;
InitMinDates(out dateColumns, out expectedValues);
try
{
con = new OracleConnection(ConnectedDataProvider.ConnectionString);
cmd = new OracleCommand();
cmd.Connection = con;
cmd.CommandText = BuildMinDateTimeSelectSql(dateColumns);
con.Open();
rdr = cmd.ExecuteReader();
Compare(true, rdr.HasRows);
bool b = rdr.Read();
for (int i=0; i<dateColumns.Length && i<expectedValues.Length; i++)
{
int j=-1;
j = rdr.GetOrdinal(dateColumns[i]);
//DateTime result = rdr.GetDateTime(j);
object result = rdr.GetValue(j);
Compare(result, expectedValues[i]);
}
}
catch (Exception ex)
{
exp = ex;
}
finally
{
EndCase(exp);
if (rdr != null && !rdr.IsClosed)
{
rdr.Close();
}
if (con != null && con.State != ConnectionState.Closed)
{
con.Close();
}
}
}