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 (scon); cmd.Parameters.AddWithValue(@p1txtuname.Text); cmd.Parameters.AddWithValue(@p2txtpassword.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 SlNoS.SanctionIDS.AccYrSetIDS.SourceIDS.SchemeIDS.SanctionNoS.SanctionDateS.SanctionEndDate + S.SanctionValueS.StatusM.SupplierNameS.SupplierIDS.IsManufacturercoalesce(S.AmendNo0) AmendNo + S.CurrentUpdatedBy CurrentUserlower(SH.Designation) DesignationS.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