How to run my .Exe file?

Question

I built a console application in VS2010.The tool will simply process some details and atore it to the sql table .When I debug my program in VS2010 it run sucessfully and meet my requirement.But when i run the exe file it run but can't stroe the values to sql table.The exe didn't generate any error.It runs but failed to meet my requirement.I don't know why this is happened?please help me to solve my issue.