Reporting Table

1 posts, 0 answers
  1. sree devi
    sree devi avatar
    5 posts
    Member since:
    Jul 2009

    Posted 28 Aug 2009 Link to this post

    Hi,
    I am using Telerik table to displaying data but it doesnt seem to do anything.
    becausethe stored proc I use to call the data is working and it displays data but in 16 pages
    displaying the results in each line in 16 pages.
    My proc returns 16 results.
    I am using dataset with report viewer.This is the code

    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;

     

    }

Back to Top