[Solved] ASP.Net QueryString Error: Input string was not in a correct format

indradeo
 
on Jul 26, 2022 03:49 AM
423 Views

Server Error in '/Sfty_inf_sys' Application.


Input string was not in a correct format.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.FormatException: Input string was not in a correct format. Source Error:

Line 17:         {
Line 18: 
Line 19:             empno = Convert.ToInt32(Request.QueryString["Id"].ToString());
Line 20:             Session["EmpId"] = empno;
Line 21:             String EmplooyeId = Session["emp_id"].ToString();

Source File: c:\inetpub\wwwroot\sfty1\sfty1\image.aspx.cs    Line: 19 Stack Trace:

[FormatException: Input string was not in a correct format.]
   System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +12838615
   System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +122
   System.Convert.ToInt32(String value) +48
   sfty1.image.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\sfty1\sfty1\image.aspx.cs:19
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +52
   System.Web.UI.Control.OnLoad(EventArgs e) +97
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693

 


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4494.0

<%@ Page Language="C#" AutoEventWireup="true" Codefile="sdor.aspx.cs" Inherits="sfty1.sdor" %>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.8.2.js"></script> 
<link href="jquery-ui-1.12.1.custom/jquery-ui.min.css" rel="stylesheet" />
 <script src="Scripts/jquery-1.11.1.min.js" type="text/javascript"></script>
<script src="Scripts/jquery.MultiFile.js" type="text/javascript"></script>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title></title>
</head>
<body bgcolor="#CEC0BD" class="auto-style11">
    <form id="form1" runat="server" enctype="multipart/form-data">
                 <asp:GridView ID="GridView1"
                                    HeaderStyle-BackColor="#99ccff" 
                                    HeaderStyle-ForeColor="black"
                                    DataKeyNames="Id"
                                    runat="server" Font-Size="Medium" AutoGenerateColumns="False"
                                    HeaderStyle-Font-Size="17px"
                                    OnRowCommand="GridView1_RowCommand"
                                    EmptyDataText="Your Last Month Data has been Submited in Database!"
                                    Height="146px" Width="1240px"  
                                    OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
                                   OnRowCancelingEdit ="GridView1_RowCancelingEdit" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating"
                                  CssClass="auto-style56" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3">
                <Columns>
                    <asp:TemplateField HeaderText="Id">
                        <ItemTemplate>
                            <asp:Label ID="Id" runat="server" Text='<%# Eval("Id") %>'></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>
                      <asp:TemplateField HeaderText="Date">
                        <ItemTemplate>
                            <asp:Label ID="lbldt" runat="server" Text='<%# Eval("dt") %>'></asp:Label>
                        </ItemTemplate>
                         <EditItemTemplate>  
                        <asp:TextBox ID="txt_dt" runat="server" Height="30px" Width="70px"   ItemStyle-Width="80" Text='<%#Eval("dt") %>'></asp:TextBox>  
                    </EditItemTemplate>
                    </asp:TemplateField>                   
                    <asp:TemplateField HeaderText="Edit">
                    <ItemTemplate>  
                        <asp:Button ID="btn_Edit" runat="server" Text="Edit" CausesValidation="false" CommandName="Edit" />  
                    </ItemTemplate>  
                    <EditItemTemplate>  
                        <asp:Button ID="btn_Update" runat="server" Text="Update" CausesValidation="false" CommandName="Update"/>  
                        <asp:Button ID="btn_Cancel" runat="server" Text="Cancel" CausesValidation="false" CommandName="Cancel"/>  
                    </EditItemTemplate>  
                </asp:TemplateField> 
                     <asp:TemplateField HeaderText="View">               
                                <ItemTemplate>
                                    <asp:Button ID="LinkButton1" Text="Image" runat="server" CausesValidation="false" OnClick="ImgButton1_Click" CommandName="EditButton" CommandArgument="<%# ((GridViewRow) Container).RowIndex %>" />
                                </ItemTemplate>
                            </asp:TemplateField> 
                </Columns>

                <FooterStyle BackColor="White" ForeColor="#000066" />
                <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
                <RowStyle ForeColor="#000066" />
                <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                <SortedAscendingCellStyle BackColor="#F1F1F1" />
                <SortedAscendingHeaderStyle BackColor="#007DBB" />
                <SortedDescendingCellStyle BackColor="#CAC9C9" />
                <SortedDescendingHeaderStyle BackColor="#00547E" />
            </asp:GridView></td>
</form>
</body>
</html>

namespace sfty1
{
    public partial class sdor : System.Web.UI.Page
    {
        string cs = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        SqlConnection con;
        SqlDataAdapter adapt;
        DataTable dt;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindGrid();

            }
            if (Session["emp_nm"] == null)
                Response.Redirect("Sssn.aspx");
            else
            {
                String EmplooyeId = Session["emp_id"].ToString();
                lblName.Text = " " + EmplooyeId + "";
                String emp_nm = Session["emp_nm"].ToString();
                Label1.Text = "" + emp_nm + " ";
                String dept = Session["dept"].ToString();
                Label2.Text = "" + dept + " ";
                Label1.Text = Label1.Text.ToUpper();
                Label2.Text = Label2.Text.ToUpper();

            }
            Label3.Text = String.Format("{0}", DateTime.Now.ToString("MM/yyyy"));
        }
        private void BindGrid()
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
            //SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM bpms WHERE EMP_ID=" + Session["emp_id"] + " and mrk_in_fa='NO'", con);
            SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM sdor WHERE emp_id=" + Session["emp_id"] + "and cls_flg='N'", con);

            DataTable dt = new DataTable();
            sda.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }
        protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "EditButton")
            {
                int index = Convert.ToInt32(e.CommandArgument);
                GridViewRow row = GridView1.Rows[index];
                Response.Redirect("image.aspx?Id=" + row.Cells[0].Text + "&EmplooyeId=" + Label1.Text + "&emp_nm=" + Label2.Text + "&dept=" + Label3.Text);
            }
        }
    }
}

 

 

Download FREE API for Word, Excel and PDF in ASP.Net: Download
dharmendr
 
on Jul 27, 2022 07:57 AM
on Jul 28, 2022 11:52 AM
indradeo says:
Response.Redirect("image.aspx?Id=" + row.Cells[0].Text + "&EmplooyeId=" + Label1.Text + "&emp_nm=" + Label2.Text + "&dept=" + Label3.Text);

Verify the above line. Here the row.Cells[0].Text value is null.

You are using TemplateField. So to get the value you need to use the FindControl method.

Like this.

Response.Redirect("image.aspx?Id=" + (row.FindControl("Id") as Label).Text + "&EmplooyeId=" + Label1.Text + "&emp_nm=" + Label2.Text + "&dept=" + Label3.Text);