Problem in database dataset in C#

Question

currently i been working on University project i make my database in sql server 2008. in C# side i call the database through dataset (virtual database) when ever i try to run my project on another PC it's give error that no database connected. while i have paste the backup copy of database to the other PC...what is the solution. i dont understand.. thanks in advance.

Thamilselvan Jagadeesan · Answer

Please create the new database connection string based on the new machine where you are executing the application and this will work.

Sanjeeb Lenka · Answer

You have to change your connection string of your application according to the SQL Server of that system where you restore your database

Iftikar Hussain · Answer

Then restore the database in the another PC and change SQL Server credentials in your application if it is different Below is the link for restoring the database http://msdn.microsoft.com/en-us/library/ms177429.aspx Regards Iftikar Remember to click Mark as Answer on the post if it helps you.

Nauman · Answer

yes me using SQL MGMT to create database...

Iftikar Hussain · Answer

Hi Since your Sql Database in your local machine. So after copy the backup of database to other system you need to restore it in Sql Server. Are you using SQL MGMT. Studio to create database? Regards Iftikar