ASP.NET Tree Control Maintenance Perfect Edition Installation Error (Database)

xiaoxiao2021-03-05  21

Server errors in the / Tree application.

User 'sa' failed.

Description: Execute an unprocessed exception during the current web request. Check the stack tracking information to learn more about the error and the code caused in the code. Abnormal details: system.data.sqlclient.sqlexception: User 'sa' Failed. Source error:

[No relevant source line] Source file: c: /Windows/Microsoft.Net/framework/v1.1.4322/temporary ASP.NET FILES / TREE / 3727F902 / Fe95AF87 / 231DOSL2.0.CS line: 0 Stack Track:

[SQLEXCEPTION: User 'SA' login failed. ]

System.data.sqlclient.connectionPool.getConnection (Boolean & IsInsAction) 484

System.data.sqlclient.sqlconnectionPoolManager.getPooled Option (SqlConnectionString Options, Boolean & Isintractions) 372

System.Data.sqlclient.sqlconnection.Open () 384

Tree.config.Open () in d: /net/tree/config.cs: 54

Tree.config..ctor () in d: /net/tree/config.cs: 43

Tree.tree_info..ctor () in d: /net/tree/tree_info.aspx.cs: 19

Asp.tree_info_aspx..ctor () in c: /windows/microsoft.net/framework/v1.1.4322/temporary ASP.NET FILES / TREE / 3727F902 / Fe95AF87 / 231DOSL2.0.CS: 0

[TargetInvocationException: An exception has occurred. ]

System.RuntimeType.createInstanceImpl (Boolean Publiconly) 0

System.Activator.createInstance (Type Type, Boolean Nonpublic) 66

System.Web.ui.templateControlParser.getCompiledInstance (String VirtualPath, String InputFile, HttpContext Context) 164

[HTTPEXCEPTION (0x80004005): Failed to create a page with "asp.tree_info_aspx". ]

System.web.ui.templateControlParser.getCompiledInstance (String VirtualPath, String InputFile, HttpContext Context) 338

System.Web.ui.pageParser.getCompileDPageInstanceinternal (String VirtualPath, String InputFile, HttpContext Context) 43

System.Web.ui.pageHandlerFactory.getHandler (HttpContext Context, String RequestType, String Url, String Path) 44

System.Web.HttpApplication.MapHttpHandler (HttpContext context, String requestType, String path, String pathTranslated, Boolean useAppConfig) 699System.Web.MapHandlerExecutionStep.System.Web.HttpApplication IExecutionStep.Execute ( 95)

System.Web.httpApplication.executeStep (Iexecutionstep Step, Boolean & CompletedSynchronously 173

Version Information: Microsoft .NET Framework Version: 1.1.4322.573; ASP.NET Version: 1.1.4322.573 This error occurs after modifying the database: Object name 't_tree' is invalid. Description: Execute an unprocessed exception during the current web request. Check the stack tracking information to learn more about the error and the code caused in the code. Abnormal details: system.data.sqlclient.sqlexception: Object name 't_tree' is invalid. Source error:

Unprocessed exceptions were generated during the current web request. You can use the following exception stack tracking information to determine information about exception causes and location. Stack tracking:

[SQLEXCEPTION: The object name 't_tree' is invalid. ]

System.data.sqlclient.sqlcommand.executeReader (Commandbehavior Cmdbehavior, Boolean ReturnStream) 723

System.data.sqlclient.sqlcommand.executeReader (Commandbehavior Behavior) 45

System.data.sqlclient.sqlcommand.system.data.idbcommand.executeReader (Commandbehavior Behavior) 5

System.data.common.dbdataadapter.FillFromCommand (Object Data, Int32 StartRecord, Int32 maxRecords, String Srctable, IDBCommand Command, Commandbehavior Behavior) 304

System.data.common.dbdataadapter.Fill (DataSet Dataset, Int32 StartRecord, Int32 MaxRecords, String Srctable, IDBCommand Command, Commandbehavior Behavior) 77

System.data.common.dbdataadapter.fill (Dataset Dataset) 38

Tree.config.Fill (String str_sql) in d: /net/tree/config.cs: 79

Tree.config.Getrowcount (String Str_SQL) in d: /net/tree/config.cs: 142

Tree.tree_info.page_load (Object Sender, Eventargs E) in d: /net/tree/tree_info.aspx.cs: 27

System.Web.ui.Control.onload (Eventargs E) 67

System.web.ui.control.loadrecurs () 35System.Web.ui.page.ProcessRequestMain () 731

Going to the Tree database of the Enterprise Manager, there is no table t_tree, sweat, but the query analyzer is executed in the SQL statement that itself belongs is successful:

If EXISTS (Select * from dbo.sysObjects where id = Object_id (n '[dbo]) And ObjectProperty (ID, n'uSERTABLE') = 1) Drop Table [dbo]. [t_tree] Go

Create Table [DBO]. [T_Tree] ([NodeId] [INT] NOT NULL, [PARENTID] [NVARCHAR] (50) Collate Chinese_PRC_CI_AS NULL, [MyText] [NVARCHAR] (100) Collate Chinese_PRC_CI_AS null, [location] [NVARCHAR ] (50) collate chinese_prc_ci_as null, [ORDER_ID] [INT] NULL) ON [PRIMARY] GO

Alter Table [DBO]. [T_Tree] with nocheck address [pk_tree] primary key clustered ([nodeid]) on [primary] GO

转载请注明原文地址:https://www.9cbs.com/read-32527.html

New Post(0)