AuthorQuestion
Input string was not in a correct format.
Posted 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 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
Get Career Advice from Experts
SPONSORED BY
  • PDF reports have never been easier to create. With our included WYSIWYG Designer, you can layout your reports, set up your data source and let DynamicPDF ReportWriter do the rest.