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

dineshkumar n

11y1.5k.NET

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rakesh Raky11y ago
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 n11y ago
" 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 < " + int.Parse(strUserSanctionLevel) + " then 'Waiting for Approval'" +
" 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 < " + int.Parse(strUserSanctionLevel) + " then 'Clarification Required'" +
" 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 Sabadra11y ago
Hi,

If possible please share your query.
Bala Murugan11y ago
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