السبت، 5 سبتمبر 2015

مشكلة Invalid object name RegMember in asp.net

"Invalid object name 'RegMember'." in ExecutReader




عند استخدامك ل ExecuteReader  تظهر مشكلة ان اسم الاوبجكت غير صحيح  "Invalid object name  Member'' .


**عليك التأكد من كتابة اسم الجدول  الذى تعمل عليه ExecuteReader صحيح فى جملة ال select .

ارجع الى الداتا بيز وتاكد من اسم الجدول  .
{"Invalid object name 'RegMember'."}
"External component has thrown an exception."}

detailes
System.Data.SqlClient.SqlException was unhandled by user code
  HResult=-2146232060
  Message=Invalid object name 'reg'.
  Source=.Net SqlClient Data Provider
  ErrorCode=-2146232060
  Class=16
  LineNumber=1
  Number=208
  Procedure=""
  Server=\\.\pipe\15207493-C255-4A\tsql\query
  State=1
  StackTrace:
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection, Action`1 wrapCloseInAction
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean
breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader
       at DB.RunQuery(String Select) in d:\Web\ASP.net\Example c# web app -adel\WebSite3.1fulldreamy\App_Code\DB.cs:line 69
       at RegMember.Login(String UserN, String Pass) in d:\Web\ASP.net\Example c# web app -adel\WebSite3.1fulldreamy\App_Code\Reg.cs:line 143
       at WUsLogin.Btnlogin_Click(Object sender, EventArgs e) in d:\Web\ASP.net\Example c# web app -adel\WebSite3.1fulldreamy\WUsLogin.ascx.cs:line 17
       at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
       at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  InnerException:

System.Runtime.InteropServices.SEHException was unhandled
  HResult=-2147467259
  Message=External component has thrown an exception.
  Source=mscorlib
  ErrorCode=-2147467259
  StackTrace:
       at Microsoft.Win32.Win32Native.CloseHandle(IntPtr handle)
       at Microsoft.Win32.SafeHandles.SafeTokenHandle.ReleaseHandle()
       at System.Runtime.InteropServices.SafeHandle.InternalFinalize()
       at System.Runtime.InteropServices.SafeHandle.Dispose(Boolean disposing)
       at System.Runtime.InteropServices.SafeHandle.Finalize()
  InnerException: 

:sol
 .Write the correct name of table not name of class in select statement 


EmoticonEmoticon