Input String was not in correct format error C# ASP.NET

Question

Input String was not in correct format error C# ASP.NET in a query.

Rakesh Raky · Answer

SqlConnection con = new SqlConnection("server=RAKY\POWERPIVOT;user id=sa;password=Raky@dusa;database=Users"); protected void btnlogin_Click(object sender, EventArgs e) { string s="select * from userid where username=@p1 and password=@p2"; SqlCommand cmd=new SqlCommand (s,con); cmd.Parameters.AddWithValue("@p1",txtuname.Text); cmd.Parameters.AddWithValue("@p2",txtpassword.Text); con.Open(); int i=Convert.ToInt32(cmd.ExecuteScalar()); con.Close(); if(i==0) { Lbldisplay.Text="Invalid user Id/Password"; } else{ Response.Redirect("Mails.aspx?u="+txtuname.Text); }

dineshkumar n · Answer

" select null as SlNo,S.SanctionID,S.AccYrSetID,S.SourceID,S.SchemeID,S.SanctionNo,S.SanctionDate,S.SanctionEndDate," + "S.SanctionValue,S.Status,M.SupplierName,S.SupplierID,S.IsManufacturer,coalesce(S.AmendNo,0) AmendNo," + "S.CurrentUpdatedBy CurrentUser,lower(SH.Designation) Designation,S.CurrentLevel," + "(case when S.IsManufacturer = 'Y' then 'Yes' else 'No' end) SupplierType," + "(coalesce(U.FirstName,'') || ' ' || coalesce(U.LastName,'') || ' :: ' || coalesce(SH.Designation,'')) SanctioningAuthority," + "(case when S.Status = 'IN' then 'Incomplete' when S.Status = 'AP' then 'Approved'" + " when S.Status = 'RJ' then 'Rejected'" + " when S.SanctionLevel = S.CurrentLevel and S.Status = 'RA' and S.CurrentLevel " when S.SanctionLevel = S.CurrentLevel and S.Status = 'RA' and S.CurrentLevel = " + int.Parse(strUserSanctionLevel) + " then 'Received for Approval'" + " when S.SanctionLevel != S.CurrentLevel and S.Status = 'RA' and S.CurrentLevel = " + int.Parse(strUserSanctionLevel) + " then 'Clarification Required'" + " when S.SanctionLevel != S.CurrentLevel and S.Status = 'RA' and S.CurrentLevel > " + int.Parse(strUserSanctionLevel) + " then 'Clarification Required'" + " when S.SanctionLevel != S.CurrentLevel and S.Status = 'RA' and S.CurrentLevel " else '' end) SanctionStatus" + " from sanSanctions S" + " inner join masSuppliers M on (M.SupplierID = S.SupplierID)" + " inner join usrUsers U on (U.UserID = S.CurrentUpdatedBy)" + " inner join masSanctionHierarchy SH on (SH.SanctionHierarchyID = U.SanctionHierarchyID)"

Prasham Sabadra · Answer

Hi, If possible please share your query.

Bala Murugan · Answer

For Example: U give a input as a integer and you are getting or saving as a String format mean. Like this error will come. If you need any more clarification Post your code

Input String was not in correct format error C# ASP.NET

Answers (4)