Click here to Skip to main content
15,881,757 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want To Return ID from DB When data save In DB I Have get Error On Exception on button click Event "Input String not in correct format"

C#
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
        {
            DataTable dt = new DataTable();
            try
            {
                //dt = obj.InsertCartData("babar@ark-sol.com", System.DateTime.Now, "GetEmenu.com:"+"" + lbl_months.Text +"" +"For"+"" + lbl_device.Text +""+ "From" +""+ lbl_currnetDate.Text +""+ "To" +""+ lbl_limit.Text, lbl_device.Text);
                int chk = obj.InsertCartData(Convert.ToInt32("return_id"), "babar@ark-sol.com", System.DateTime.Now, "GetEmenu.com:" + "" + lbl_months.Text + "" + "For" + "" + lbl_device.Text + "" + "From" + "" + lbl_currnetDate.Text + "" + "To" + "" + lbl_limit.Text, lbl_device.Text);


                if (dt.Rows.Count > 0)
                {
                    pid = Convert.ToInt32(dt.Rows[0]["return_id"]);
                    Response.Redirect("Paypayl.aspx?id=" + pid);
                }
            }
            catch (Exception ex)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Error" + ex.ToString() + "');", true);

            }
        }


    public int InsertCartData(int return_id, string username, DateTime date, string description, string device)
        {
            SqlConnection con = new SqlConnection(connStr);
            con.Open();
            SqlCommand cmd = new SqlCommand();
            SqlDataAdapter da = new SqlDataAdapter();
            //DataTable dt = new DataTable();
            try
            {
                cmd = new SqlCommand("GetEmenuDemo_InsertCartData", con);
                
                cmd.Parameters.Add(new SqlParameter("@UserName", username));
                cmd.Parameters.Add(new SqlParameter("@CartDated", date));
                cmd.Parameters.Add(new SqlParameter("@Product_Detail", description));
                cmd.Parameters.Add(new SqlParameter("@NoOfDevices", device));
                //cmd.Parameters.Add(new SqlParameter("@return_id", retid));
                cmd.Parameters.Add("@return_id", SqlDbType.Int).Direction = ParameterDirection.Output;
                cmd.CommandType = CommandType.StoredProcedure;
                da.SelectCommand = cmd;
                //da.Fill(dt);
                //return dt;
                return Convert.ToInt32(cmd.Parameters["@return_id"].Value);
            }
            catch (Exception ex)
            {
                return 0;
            }
            finally
            {
                cmd.Dispose();
                con.Close();
            }

            return Convert.ToInt32(cmd.Parameters["@return_id"].Value);
        }
Posted
Updated 13-Sep-15 20:20pm
v2
Comments
Patrice T 14-Sep-15 2:22am    
Where is the error ?
Babar Shahzad 14-Sep-15 2:29am    
I Have get Error in Exception on button click Event "Input String not in correct format"
Patrice T 14-Sep-15 2:40am    
Never use try/catch until you know the program have no bug.
It prevent debugger to fire on error.
OriginalGriff 14-Sep-15 3:02am    
I'd disagree with that: you can tell the debugger to break on all exception, handled or unhandled. It's in the Debug Menu, under Exceptions.

Adding the try/catch later can cause problems and means you have to retest anyway because the code has been changed.
Babar Shahzad 14-Sep-15 3:16am    
I want return id in query string DB when store data in DB I have write store procedure in return_id int Output.When save data and ID will show on my redirect page query String

Look at your code:
C#
... obj.InsertCartData(Convert.ToInt32("return_id"), ...

What kind of number do you expect to get from a string "return_id"?
I suspect that you value to use a value that is contained in your variable return_id, or that it's a control of some kind.
But you can't convert that string to a number, so you get an exception.
 
Share this answer
 
I want return id in query string DB when store data in DB I have write store procedure in return_id int Output.When save data and ID will show on my redirect page query String
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900