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
Aspose File APIs

SPONSORED BY

Spire.Doc - Free .NET Word API
Use Spire.Doc to create, read, write, print, and convert word documents to OpenXML, RTF, TXT, XPS, EPUB, EMF, HTML, Image and PDF.