Forum guidelines
AuthorQuestion
Input string was not in a correct format.
Posted By Sheikh parvaz on 25 Nov 2012
the below code has some issue with conversion, kidly help.


ticketid = Convert.ToInt32(Request.QueryString["TicketID"].ToString());
            string countresolved = "Select Count(CurrentStatus) From Ticket Where CurrentStatus='Resolved' and TicketId = ticketid";
            Int32.TryParse(countresolved, out countresolvedint);
            countresolvedint = Convert.ToInt32(countresolved);
            if (Convert.ToInt32(countresolved)==1)
            {
                lblIssueResolved.Visible = true;
                btnIssueResolved.Visible = false;
            
            }

Thanks and Regards
Sheikh Parvaz
Program to perfection
AuthorReply
Re: Input string was not in a correct format.
Posted By Sheikh parvaz on 25 Nov 2012  
I got it you have to write '"+ticketid+"' as local variable in sql query.
Thanks and Regards
Sheikh Parvaz
Program to perfection
Infragistics jQuery Controls

SPONSORED BY

JetBrains ReSharper Ultimate
.NET code analysis, refactorings, navigation, unit testing, code coverage and profiling in Visual Studio, a bonus for C++ devs, bundled at 50% off.