Hi,
I deployed a website on a remote server and it was working fine.
I made a change to the code and updated on the remote server but the code change does not reflect.
The code change works fine when the website is run through VS 2012 on localhost but not after it is deployed to remote server.
String currentyear= DateTime.Today.Year.ToString();
SqlCommand cmd2 = new SqlCommand("Select min(r_id) from data WHERE year ='"+currentyear+"'" , con);
int start2 = (int)cmd2.ExecuteScalar();
The only change I made was addition of the WHERE clause in the SELECT command.
Can someone suggest what might be the reason behind this issue and what troubleshooting methods can be tried?
Thanks,
Shaleen
Go to the complete details ...