Experiences in debugging the Asp.net Program

The previous two days, I downloaded some development systems for Asp.net from the 51aspx website, which are divided into two la S: SQL Server2000 + vs2010 and Oracle + vs2010. The following describes the debugging process.

1. SQL Server2000 + vs2010

1) database configuration,Source codeContains the following format * data. MDF, * data. LDF format. If SQL Server is created on the local machine, copy the two files directly to the SQL Server installation path. For example, the installation path is C: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data.

2) Start the SQL Enterprise Manager, select the server to be loaded, right-click the connection, and then right-click the database node. The "Attach database Level 2" menu option in all tasks is displayed, and the "Attach Database" page is displayed, select the database to attach, of course, the * data under c: \ Program Files \ Microsoft SQL Server \ mssql.1 \ MSSQL \ data. MDF database.

3) Specify the database owner. The owner is the username used to start the database connection.

4) Confirm that the attached database is successfully attached. You can do the following.

5) Open vs DevelopmentProgramIn the database connection section, modify the above database configuration.

 

 

 

2. debug the Oracle + vs2010 program.

1) Create Oracle Database configurations. For example, you can use the Database Config Assistant in the Oracle configuration and porting tool to create a database step by step as prompted. Remember the System user and its password, such as the user name and password of the Sys user.

2) After creation, for example, use the Sys user and SYS password (the password created at the time of creation 1), enter through PLSQL, and then create the user and its user password.

3) create a user and its password. Create User Username identified by password; set the username and password for the information you want to create.

4) create a tablespace. Create tablespace name datafile orcle path + tablespace. dbf' size 100 m;

5) modify the current user data default tablespace alter User Username default tablespace

6) Create permissions for the current user, such as grant create session, create table, create sequence, create trigger, and unlimited tablespace to user name;

7) create the required table information.

Create Table Name
(
Field 1varchar2 (15) primary key,
Field 2 varchar2 (15 ),
Field 3 varchar2 (40 ),
Field 4 Number (2 ),
Field 5 Number (2) default 0
)

8) create a sequence

Create sequence queue name

Minvalue 1
Max value 99999999
Start with 1
Increment by 1
Nocache;

 

9) import data.

Insert into Table Name (Field 1, Field 2, Field 3, field 4, Field 5)
Values ('000000', 'name', 'Age, 3, 0 );