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

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.