RDLC reporting function

20. November 2009
Comments (0)

 

public DataSet WFP_REPORTVIEWER(string CompanyName, string Title, string Address, string Year, string L, string Y)
       {
          
           DataSet ds = new DataSet();
           SqlParameter[] Param ={new SqlParameter("@Ledger",SqlDbType.NVarChar)
                             ,new SqlParameter("@LedgerYear",SqlDbType.NVarChar)};
           Param[0].Value = L;
           Param[1].Value = Y;

           return DataAccessLibrary.DBAccess.ExecuteReader(ConnectionStr.setConnectionString(), CommandType.StoredProcedure, "RChartOfAccounts", Param);


       }

  public static DataSet ExecuteReader(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
       {
           SqlCommand cmd = new SqlCommand();
         
           SqlConnection conn = new SqlConnection(connectionString);
           DataAccess Da = new DataAccess();

              PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters);
              // cmd.CommandType = CommandType.StoredProcedure;
               SqlDataAdapter ad = new SqlDataAdapter();
               ad.SelectCommand = cmd;
               DataSet ds = new DataSet();
               ad.Fill(ds);
               cmd.Parameters.Clear();
           conn.Close();
               return ds;
          
          
       }

 


Microsoft.Reporting.WebForms.ReportDataSource RptDataSource = new Microsoft.Reporting.WebForms.ReportDataSource();
        RptDataSource.Name = "dsReports_RSingleVoucher";
        RptDataSource.Value = ds.Tables[0];
        ReportViewer1.LocalReport.DataSources.Clear();
        ReportViewer1.LocalReport.DataSources.Add(RptDataSource);
        ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local;
        ReportViewer1.LocalReport.ReportPath = "members\\Reports\\SingleVoucher.rdlc";

        ReportViewer1.LocalReport.SetParameters(new ReportParameter[]
        {new ReportParameter("RptCompanyName", "AL SHIFA TRUST EYE HOSPITAL" ),
                        new ReportParameter ( "RptTitle", sRptTitle ),
                        new ReportParameter ( "address", com ),
                        new ReportParameter ( "dates",fto)});
                        //new ReportParameter ( "RptChequeNo", sChequeNumber )});

        ReportViewer1.ToolBarItemBorderColor = System.Drawing.Color.Red;
        ReportViewer1.BackColor = System.Drawing.Color.White;
        ReportViewer1.Height = 1000;
        ReportViewer1.LocalReport.Refresh();


Author: Aamir Hasan     औथोर: आमिर हसन       أثر أمير حسن .

ALL, asp.net, DataSet and DataTable, reports RDLC & RDL, asp.net 4.0 ,

dynamic create table asp.net csahrp

20. November 2009
Comments (0)

private DataTable CreateDataTable()
{

DataTable myDataTable = new DataTable();

DataColumn myDataColumn;

myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "id";
myDataTable.Columns.Add(myDataColumn);

myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "username";
myDataTable.Columns.Add(myDataColumn);

myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "firstname";
myDataTable.Columns.Add(myDataColumn);

myDataColumn = new DataColumn();
myDataColumn.DataType = Type.GetType("System.String");
myDataColumn.ColumnName = "lastname";
myDataTable.Columns.Add(myDataColumn);

return myDataTable;

}

 

 

private void AddDataToTable(string username,string firstname,string lastname,DataTable myTable)
{

DataRow row;

row = myTable.NewRow();

row["id"] = Guid.NewGuid().ToString();
row["username"] = username;
row["firstname"] = firstname;
row["lastname"] = lastname;

myTable.Rows.Add(row);

}

 

protected void btnAdd_Click(object sender, EventArgs e)
{

if (txtUserName.Text.Trim() == "")
{
this.lblTips.Text = "You must fill a username.";
return;
}
else
{
AddDataToTable(this.txtUserName.Text.Trim(), this.txtFirstName.Text.Trim(), this.txtLastName.Text.Trim(), (DataTable)Session["myDatatable"]);

this.GridView1.DataSource = ((DataTable)Session["myDatatable"]).DefaultView;
this.GridView1.DataBind();

this.txtFirstName.Text = "";
this.txtLastName.Text = "";
this.txtUserName.Text = "";
this.lblTips.Text = "";
}

if (!Page.IsPostBack)
{
myDt = new DataTable();
myDt = CreateDataTable();
Session["myDatatable"] = myDt;

this.GridView1.DataSource = ((DataTable)Session["myDatatable"]).DefaultView;
this.GridView1.DataBind();
}


Author: Aamir Hasan     औथोर: आमिर हसन       أثر أمير حسن .

ALL, asp.net, DataSet and DataTable, asp.net 4.0



User Name: Guest

Your Ip: 38.107.191.92
Time: