public
void Acc_setup_report_S6(string strAccountnumber)
{
System.Data.OracleClient.
OracleConnection conn = new System.Data.OracleClient.OracleConnection(System.Configuration.ConfigurationManager.AppSettings["ConnStr"].ToString());
System.Data.OracleClient.
OracleCommand cmd = new System.Data.OracleClient.OracleCommand();
cmd.Connection = conn;
System.Data.OracleClient.
OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(cmd);
DataSet ds = new DataSet();
try
{
cmd.CommandText =
"pkg_csharp_reports.sprocAcc_setup_report_S6";
cmd.Parameters.Add(
"account_number_", OracleType.VarChar);
cmd.Parameters[
"account_number_"].Direction = ParameterDirection.Input;
cmd.Parameters.Add(
"ret_result_", OracleType.Cursor);
cmd.Parameters[
"ret_result_"].Direction = ParameterDirection.Output;
da.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
// //this.textBox1.Value = dr["description"].ToString();
this.textBox1.Value = dr["fee"].ToString();
this.textBox2.Value = dr["payor"].ToString();
}
}
finally
{
cmd.Dispose();
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Dispose();
}
//return ds;
}