“Input string was not in a correct format.”

Question

I want to calculate the running total of gridview data I have the following code:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    DataRowView dtview = e.Row.DataItem as DataRowView;

    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        Label lblaprl = (Label)e.Row.FindControl("lblaprl");
        Totalapr = Totalapr + Convert.ToDecimal(lblaprl.Text);
        Label lblmay = (Label)e.Row.FindControl("lblmay");
        Totalmay = Totalmay + Convert.ToDecimal(lblmay.Text);
    }

    if (e.Row.RowType == DataControlRowType.Footer)
    {
            Label lbl_aprTotalamount = (Label)e.Row.FindControl("lbl_aprTotalamount");
            lbl_aprTotalamount.Text = Totalapr.ToString();
            Label lbl_mayTotalamount = (Label)e.Row.FindControl("lbl_mayTotalamount");
            lbl_mayTotalamount.Text = Totalmay.ToString();
    }
}

When we run this code for one column for apr month it works fine but when we want to calculate running total of both column separately it's causing this error:

Input string was not in a correct format.

on the following line in my code

Label lblmay = (Label)e.Row.FindControl("lblmay");
***Totalmay = Totalmay + Convert.ToDecimal(lblmay.Text);***

My c# code for bind gridview

public void bindgvduedate()
{
    con = new SqlConnection();
    con.ConnectionString = ConfigurationManager.ConnectionStrings["con1"].ConnectionString;
    con.Open();

    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = "readfeedetails";
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Connection = con;
    ////cmd.Parameters.AddWithValue("@classname",Convert.ToString(ddlclassname.SelectedItem));
    ////cmd.Parameters.AddWithValue("@feecatename", Convert.ToString(ddlstcategory.SelectedItem));

    SqlDataAdapter da = new SqlDataAdapter(cmd);
    DataTable table = new DataTable();
    da.Fill(table );
    GridView1.DataSource= table;
    GridView1.DataBind();
    con.Close();
}

This function I call on page load event.

Gridview aspx markup:

My database table

CREATE TABLE [dbo].[feemaster]
(
   [feeId] [int] IDENTITY(1,1) NOT NULL,
   [feetype] [nvarchar](50) NULL,
   [feename] [nvarchar](50) NULL,
   [classname] [nvarchar](50) NULL,
   [duemonth] [nvarchar](50) NULL,
   [feeamount] [decimal](15, 2) NULL,
   [feeactive] [bit] NULL,
   [feecatename] [nvarchar](50) NULL
) ON [PRIMARY]
GO

SET IDENTITY_INSERT [dbo].[feemaster] ON

INSERT [dbo].[feemaster] ([feeId], [feetype], [feename], [classname], [duemonth], [feeamount], [feeactive], [feecatename]) 
VALUES (1, N'One Time', N'Prospectus & Registration Fee', N'PRE NURSURY', N'Apr-15', CAST(300.00 AS Decimal(15, 2)), 1, N'NEW')

INSERT [dbo].[feemaster] ([feeId], [feetype], [feename], [classname], [duemonth], [feeamount], [feeactive], [feecatename]) 
VALUES (13, N'One Time', N'Prospectus & Registration Fee', N'NURSURY', N'Apr-15', CAST(300.00 AS Decimal(15, 2)), 1, N'NEW')

INSERT [dbo].[feemaster] ([feeId], [feetype], [feename], [classname], [duemonth], [feeamount], [feeactive], [feecatename]) 
VALUES (2, N'One Time', N'Prospectus & Registration Fee', N'KG', N'Apr-15', CAST(300.00 AS Decimal(15, 2)), 1, N'NEW')

INSERT [dbo].[feemaster] ([feeId], [feetype], [feename], [classname], [duemonth], [feeamount], [feeactive], [feecatename]) 
VALUES (16, N'Annual', N'Maintenance Fee', N'NURSURY', N'Apr-15', CAST(500.00 AS Decimal(15, 2)), 1, N'NEW')

INSERT [dbo].[feemaster] ([feeId], [feetype], [feename], [classname], [duemonth], [feeamount], [feeactive], [feecatename]) 
VALUES (17, N'Annual', N'Maintenance Fee', N'NURSURY', N'Apr-15', CAST(500.00 AS Decimal(15, 2)), 1, N'OLD')

INSERT [dbo].[feemaster] ([feeId], [feetype], [feename], [classname], [duemonth], [feeamount], [feeactive], [feecatename]) 
VALUES (18, N'Annual', N'Maintenance Fee', N'KG', N'Apr-15', CAST(500.00 AS Decimal(15, 2)), 1, N'NEW')

My stored procedure

create proc [dbo].[readfeedetails]
AS
BEGIN
    select
        *
    from
        (select 
             f.feename, f.feeamount, dd.duemonth 
         from 
             feemaster as f
         left outer join 
             duedate as dd on dd.duemonth = f.duemonth  
         where   
             classname = 'KG' and feeactive = 1 
             and feecatename = 'OLD') as f
pivot
(
  min(f.feeamount)
  for f.duemonth in ([Apr-15],[May-15],[Jun-15],[Jul-15],[Aug-15],[Sep-  15],[Oct-15],[Nov-15],[Dec-15],[Jan-15],[Feb-15],[Mar-15])
) as PIV
END
GO

Please can anyone suggest how we can remove this error?

“Input string was not in a correct format.”

Answers (1)

Related Questions