Employers - Post Free Jobs
Forum guidelines
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

SPONSORED BY

Offshore Software and Database Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.