How to connect database in asp.net after uploading website?

[Hardik mistry]

i have upload my website to net & also connect with server by connection string but how to upload my Database
I have created database in .net control panel and all have told me to restore my database(.mdf file) but then also it shows some error like

 
Server Error in '/' Application.
 
 Invalid object name 'mentors'.
 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
 
Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'mentors'.
 
Source Error: 
 
 
Line 20:         _cmd.CommandType = CommandType.Text;
Line 21:         _cmd.CommandText = "select * from mentors";
Line 22:         _cmd.ExecuteNonQuery();
Line 23:         DataTable _dt = new DataTable();
Line 24:         SqlDataAdapter _da = new SqlDataAdapter(_cmd);
 
Source File: e:\HostingSpaces\rfucs\rfucs.com\wwwroot\mentors.aspx.cs    Line: 22 
 
Stack Trace: 
 
 
[SqlException (0x80131904): Invalid object name 'mentors'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +317
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   mentors.Page_Load(Object sender, EventArgs e) in e:\HostingSpaces\rfucs\rfucs.com\wwwroot\mentors.aspx.cs:22
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
 
 

so plz help me......

[Ahmed AlNaib]

In order to solve this issue I suggest for you to implement one of the following suggestions :

1- Export you sqlserver database as a sql file then ask you host provider to restore it from that file.

2- If you are using the sqlserver express version you may just upload the file to the "database" folder in your host account that is located next to your "www" or "public_html" or "wwwroot".

I hope that I manage to help you .....

Ahmed Al-Naib