Quote:I have seen the problem in Dataset when execution control comes on dataset it will close whole application.
Then the most likely reason is that you don't use any try-catch blocks to try to locate and handle errors properly, and your connection string is probably wrong. Development and production do not normally use the same connection string - or even the same database - so unless your code is set up to use a configuration system to store the connection string, it's probably still trying to reference your development SQL Server instance. EVen if it is, you need to check what that string is, and that it's correct for the actual instance of SQL that it references. And that the instance has a copy of the database. And ... you get the idea.
We can't do any of that for you: so check it all very carefully, and add try - catch blocks to report problems (including any inner exception) so that you get told what the error actual is rather than "it crashed".