Re: Help with XML to datagridview - C# Discussion Boards

Re: Help with XML to datagridview

19-Apr-17 1:01

What is in query and can you share the declarations for row and results.

Also - shortening the amount of XML we have to copy would be nice.
When you say "show it correctly" what do you mean by "correctly"?

modified 19-Apr-17 7:25am.

Gerry Schmitz19-Apr-17 10:11

Gerry Schmitz

19-Apr-17 10:11

row[i] indicates a "column" (indexed via i).

One needs to populate all columns in a (datatable) row that you're writing; you're only populating one column at a time.

You need to populate each column as you retrieve the (xml) values for that column and row.

You're also attempting to do this in the crudest way possible (no xml deserialization; no datarow column naming).

"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal

Not binding data's in Rdlc Report

Member 1305063918-Apr-17 4:10

18-Apr-17 4:10

hi

here is my code Rdlc not binding data's in reportviewer pls any one help

protected void btnSearch_Click(object sender, EventArgs e)
{
DivReport.Visible = true;
GetMonthWiseReports();

}

private void GetMonthWiseReports()
{
string LocationName = string.Empty, CompanyName = string.Empty;
try
{
rptvw.Reset();
rptvw.ProcessingMode = ProcessingMode.Local;
rptvw.LocalReport.ReportPath = Server.MapPath("~/Reports/RDLC/MonthWiseLedger.rdlc");
string accname = string.Empty;
Int64 AccNo = 0;
//string frmdate = string.Empty;
//string todate = string.Empty;

//frmdate = Convert.ToDateTime(rdFrmDate.SelectedDate).ToString("yyyy-MM-dd");
//todate = Convert.ToDateTime(rdToDate.SelectedDate).ToString("yyyy-MM-dd");
DataTable dt_PurchaseData = SerLedgerMaster.GetMonthwiseledgerReport(AccNo).Tables[0];
dt_PurchaseData.Columns.Add("Serial_No");
Int32 RowCount = 0;
foreach (DataRow dr in dt_PurchaseData.Rows)
{
RowCount++;
dr["Serial_No"] = RowCount;
}
ReportDataSource rptSource = new ReportDataSource("MonthWiseLedger", dt_PurchaseData);
rptvw.LocalReport.DataSources.Add(rptSource);
rptvw.LocalReport.Refresh();
}
catch (Exception ex)
{
throw (ex);
}
}

public static DataSet GetMonthwiseledgerReport(Int64 accname)
       {
           try
           {
               MySqlConnection mySQLConnection = new MySqlConnection(ConfigurationManager.ConnectionStrings["MMDBConn"].ToString());

               DataSet objDataSet = new DataSet();
               MySqlCommand command = new MySqlCommand();
               command.Connection = mySQLConnection;
               command.CommandType = CommandType.StoredProcedure;
               command.CommandTimeout = 600;

               command.CommandText = "USP_GetMonthWiseLedger";
               //command.Parameters.AddWithValue("@frmdate", frmdate);
               //command.Parameters.Add("@frmdate", MySqlDbType.String).Value = frmdate;
               //command.Parameters.AddWithValue("@todate", todate);
               //command.Parameters.Add("@todate", MySqlDbType.String).Value = todate;
               //command.Parameters.AddWithValue("@AccNo", accname);
               command.Parameters.Add("@AccNo", MySqlDbType.Int64).Value = accname;
               mySQLConnection.Open();
               MySqlDataAdapter SqlDa = new MySqlDataAdapter(command);
               SqlDa.Fill(objDataSet);
               int count = objDataSet.Tables[0].Rows.Count;
               return objDataSet;
           }
           catch (Exception ex)
           {
               throw (ex);
           }
       }

CHill6018-Apr-17 4:15

18-Apr-17 4:15

I'm sorry I don't understand. Can you rephrase your question please?

Member 1305063918-Apr-17 4:35

18-Apr-17 4:35

Hi here is my code, i want to show data in the report for selected accno in the dropdown list

thank you for ur reply

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                CurUserID = Convert.ToInt64(Session["UserID"]);
                CurrLocID = Convert.ToInt64(HttpContext.Current.Session["LocID"]);
                CurrCompID = Convert.ToInt64(HttpContext.Current.Session["CompID"]);
                if (CurUserID == 0)
                {
                    Response.Redirect("~/Logout.aspx");
                }
                else
                {
                    BindAccounDetails();
                    GetMonthWiseReports();
                   
                }
            }
        }

        private void BindAccounDetails()
        {
            CurrLocID = Convert.ToInt64(HttpContext.Current.Session["LocID"]);
            CurrCompID = Convert.ToInt64(HttpContext.Current.Session["CompID"]);
            try
            {
               
                DataTable dt = new DataTable();
                SerChequePaymentDetails SerObjChq = new SerChequePaymentDetails();
             
                dt = SerObjChq.BindAccounDetails(CurrLocID, CurrCompID);
                ddlAccname.DataSource = dt;
                ddlAccname.DataTextField = "Acc_Name";
                ddlAccname.DataValueField = "Acc_No";
                ddlAccname.DataBind();
                RadComboBoxItem item = new RadComboBoxItem("Select", "0");
                ddlAccname.Items.Insert(0, item);
            }
            catch (Exception ex)
            {
            }
        }

        protected void btnSearch_Click(object sender, EventArgs e)
        {
            DivReport.Visible = true;
            GetMonthWiseReports();
            
        }

        private void GetMonthWiseReports()
        {
            string LocationName = string.Empty, CompanyName = string.Empty;
            try
            {
                rptvw.Reset();
                rptvw.ProcessingMode = ProcessingMode.Local;
                rptvw.LocalReport.ReportPath = Server.MapPath("~/Reports/RDLC/MonthWiseLedger.rdlc");
                string accname = string.Empty;
                Int64 AccNo = 0;
                
                
                
                DataTable dt_PurchaseData = SerLedgerMaster.GetMonthwiseledgerReport(AccNo).Tables[0];
                dt_PurchaseData.Columns.Add("Serial_No");
                Int32 RowCount = 0;
                foreach (DataRow dr in dt_PurchaseData.Rows)
                {
                    RowCount++;
                    dr["Serial_No"] = RowCount;
                }
                ReportDataSource rptSource = new ReportDataSource("MonthWiseLedger", dt_PurchaseData);
                rptvw.LocalReport.DataSources.Add(rptSource);
                rptvw.LocalReport.Refresh();
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }

public static DataSet GetMonthwiseledgerReport(Int64 accname)
        {
            try
            {
                MySqlConnection mySQLConnection = new MySqlConnection(ConfigurationManager.ConnectionStrings["MMDBConn"].ToString());

                DataSet objDataSet = new DataSet();
                MySqlCommand command = new MySqlCommand();
                command.Connection = mySQLConnection;
                command.CommandType = CommandType.StoredProcedure;
                command.CommandTimeout = 600;

                command.CommandText = "USP_GetMonthWiseLedger";
                //command.Parameters.AddWithValue("@frmdate", frmdate);
                //command.Parameters.Add("@frmdate", MySqlDbType.String).Value = frmdate;
                //command.Parameters.AddWithValue("@todate", todate);
                //command.Parameters.Add("@todate", MySqlDbType.String).Value = todate;
                //command.Parameters.AddWithValue("@AccNo", accname);
                command.Parameters.Add("@AccNo", MySqlDbType.Int64).Value = accname;
                mySQLConnection.Open();
                MySqlDataAdapter SqlDa = new MySqlDataAdapter(command);
                SqlDa.Fill(objDataSet);
                int count = objDataSet.Tables[0].Rows.Count;
                return objDataSet;
            }
            catch (Exception ex)
            {
                throw (ex);
            }
        }

CHill6018-Apr-17 10:20

18-Apr-17 10:20

Ok - I get what you want to do, I get that you have some code. But what is the actual problem? (or question)

Member 1305063918-Apr-17 23:46

18-Apr-17 23:46

hi
report structure only visible i click the button...nothing data inside my report that is problem

CHill6018-Apr-17 23:48

18-Apr-17 23:48

Have you seen the suggestion from vinod.jangle below? You do not appear to have used DataBind()

User 418025418-Apr-17 4:19

User 4180254

18-Apr-17 4:19

I have no much idea on reports but don't you need "

DataBind();

" for your reportviewer control?

modified 20-Sep-20 21:01pm.

Member 1305063918-Apr-17 23:52