我这个当个反面教材就好了。
嗨,辛苦地写了半天~~~草草了事了~~先发上来,大家帮忙看看有啥不好噢~!多提意见会对我很有帮助滴~~~!
目的:好好地写一个类处理大部分常用的oracle数据库连接的问题。
当然,在开始还是把基本设置做齐了,省得一会连不通被人骂
![emteeth.gif](https://www.cnblogs.com/CuteSoft_Client/CuteEditor/images/emteeth.gif)
首先,配置web.config文件
添加
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
类文件名为conn.cs
由于VS.NET2005不默认支持oracle数据库,所以要添加其引用:在解决方案资源管理器里添加引用:System.Data.OracleClient(仔细找找噢~在.NET选项卡中)
内容(不断更新):
1
using
System;
2
using
System.Data;
3
using
System.Configuration;
4
using
System.Web;
5
using
System.Web.Security;
6
using
System.Web.UI;
7
using
System.Web.UI.WebControls;
8
using
System.Web.UI.WebControls.WebParts;
9
using
System.Web.UI.HtmlControls;
10
using
System.Data.OracleClient;
11![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
namespace
User.Data
13![ExpandedBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
14
public class conn
15![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
16![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
构造函数#region 构造函数
18![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
19
/// 构造函数(默认)
20
/// </summary>
21![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
public conn()
{ }
22![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
23![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
24
/// 构造函数
25
/// </summary>
26
/// <param name="connString">连接字符串(类型:string)</param>
27
/// 例子:"Data Source=ServerName;User ID=userid;Password=password;Unicode=True"
28
public conn(string connString)
29![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
30
this.ConnectionString = connString;
31
}
32![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
33
#endregion
34![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
35![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
私有变量#region 私有变量
36![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
37![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
38
/// 表示针对数据库执行的SQL语句或存储过程
39
/// </summary>
40
private System.Data.OracleClient.OracleCommand cmd;
41![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
42![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
43
/// 表示一个到数据库的打开的连接
44
/// </summary>
45
private System.Data.OracleClient.OracleConnection con;
46![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
47![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
48
/// 表示要在数据库中生成的事务
49
/// </summary>
50
private System.Data.OracleClient.OracleTransaction tran;
51![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
52![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
53
/// 表示用于填充System.Data.DataSet和更新数据库的一组数据命令和到数据库的连接。
54
/// </summary>
55
private System.Data.OracleClient.OracleDataAdapter adapter;
56
57![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
58
/// 提供从数据源读取数据行的只进流的方法
59
/// </summary>
60
private System.Data.OracleClient.OracleDataReader reader;
61![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
62![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
63
/// 表示内存中数据的一个表
64
/// </summary>
65
private System.Data.DataTable dt;
66![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
67![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
68
/// 表示数据在内存中的缓存
69
/// </summary>
70
private System.Data.DataSet ds;
71![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
72
/// 连接字符串
73
/// </summary>
74
string ConnectionString = "";
75![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
76![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
77
/// 返回与打开的数据库连接
78
/// </summary>
79
private System.Data.OracleClient.OracleConnection openedCon
80![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
81
get
82![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
83
this.openCon(); //固定地打开数据库与之连接
84
return this.con;
85
}
86
//connectiongString是由固定的,存放在Web.config文件的AppSetting节点下,因此无需set访问器
87
}
88
#endregion
89![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
90![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
私有方法#region 私有方法
91![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
92
/// 打开与数据库的连接
93
/// </summary>
94
private void openCon()
95![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
96
try
97![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
98
if (this.con == null)
99![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
100
//使用using可以使该连接可以调用Dispose方法来释放资源
101
//using (this.con = new OracleConnection())
102
//{
103
this.con = new OracleConnection();
104
//设置数据库连接属性为web.config中的设置的值(默认)
105
//或者设置为构造函数中指定的connString的值
106
this.con.ConnectionString
107
= (this.ConnectionString == "") ? System.Configuration.ConfigurationManager.AppSettings["SysDSN"] : this.ConnectionString;
108
this.con.Open();
109
//}
110
//System.Web.HttpContext.Current.Response.Write("数据库连接成功!"); //Test
111
}
112
else if (con.State == ConnectionState.Closed)
113![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
114
this.con.Open();
115
}
116
}
117
catch
118![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
119
System.Web.HttpContext.Current.Response.Write("数据库连接失败,请与管理员联系!");
120
System.Web.HttpContext.Current.Response.End();
121
}
122
}
123![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
124![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
125
/// 获取或设置将在其中执行System.Data.OracleClient.OracleCommand的
126
/// System.Data.OracleClient.OracleTransaction。
127
/// 因为OracleConnection 不支持并行事务。所以在添加事务前必须要检查是否为空!
128
/// </summary>
129
private void checkTransaction()
130![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
131
if (this.tran != null)
132![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
133
this.cmd.Transaction = this.tran;
134
}
135
}
136![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
137![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
138
/// 设置基本Command对象
139
/// </summary>
140
/// <param name="sql"></param>
141
private void CreateCmd(string sql)
142![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
143
//方法1
144
this.cmd = new OracleCommand();
145
this.checkTransaction();
146
this.cmd.Connection = this.openedCon;
147
this.cmd.CommandText = sql;
148
149
//方法2
150
//this.checkTransaction();
151
//this.cmd=new OracleCommand(sql);
152
//this.cmd.Connection=this.openedCon;
153![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
154
//方法3
155
//this.checkTransaction();
156
//this.cmd = new OracleCommand(sql, this.openedCon);
157![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
158
//方法4
159
//this.cmd = new OracleCommand(sql, this.openedCon, this.tran);
160![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
161
//方法5(Oracle中只支持.NET2.0以上版本)
162
//this.cmd = this.openedCon.CreateCommand();
163
//this.checkTransaction();
164
//this.cmd.CommandText = sql;
165
}
166![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
167
#endregion
168![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
169![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
公共方法#region 公共方法
170![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
171![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
172
/// 开始事务
173
/// </summary>
174
public void BeginTransaction()
175![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
176
this.tran = this.openedCon.BeginTransaction();
177
}
178![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
179
/// 提交事务
180
/// </summary>
181
public void Commit()
182![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
183
this.tran.Commit();
184
}
185![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
186
/// 回滚事务
187
/// </summary>
188
public void RollBack()
189![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
190
this.tran.Rollback();
191
}
192![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
193![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
194
/// 关闭与数据库的连接
195
/// </summary>
196
public void CloseCon()
197![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
198
if (this.openedCon != null && this.openedCon.State == ConnectionState.Open)
199![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
200
this.openedCon.Close();
201
}
202
}
203![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
204![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
205
/// 执行SQL语句
206
/// </summary>
207
/// <param name="sql">SQL语句</param>
208
/// <returns>受影响的行数</returns>
209
public int DoSelectSql(string sql)
210![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
211
this.CreateCmd(sql);
212
return this.cmd.ExecuteNonQuery();
213
}
214![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
215![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
216
/// 获得OracleDataReader对象
217
/// </summary>
218
/// <param name="sql">SQL语句</param>
219
/// <returns>OracleDataReader对象</returns>
220
public System.Data.OracleClient.OracleDataReader GetReader(string sql)
221![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
222
this.CreateCmd(sql);
223
this.reader=this.cmd.ExecuteReader();
224
return this.reader;
225
}
226![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
227![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
228
/// 获得DataTable
229
/// </summary>
230
/// <param name="sql">SQL语句</param>
231
/// <returns>DataTable对象</returns>
232
public System.Data.DataTable GetDataTable(string sql)
233![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
234
this.adapter = new OracleDataAdapter();
235
this.dt = new DataTable();
236
this.CreateCmd(sql);
237
this.adapter.SelectCommand = this.cmd;
238
this.adapter.Fill(this.dt);
239
return this.dt;
240
}
241![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
242![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
243
/// 获得DataSet(通过sql语句)
244
/// </summary>
245
/// <param name="sql">SQL语句</param>
246
/// <returns>DataSet对象</returns>
247
public System.Data.DataSet GetDataSet(string sql)
248![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
249
this.adapter = new OracleDataAdapter();
250
this.ds = new DataSet();
251
this.CreateCmd(sql);
252
this.adapter.SelectCommand = this.cmd;
253
this.adapter.Fill(this.ds);
254
return this.ds;
255
}
256![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
257![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
258
/// 获得DataSet(通过sql语句、表名)
259
/// </summary>
260
/// <param name="sql">SQL语句</param>
261
/// <param name="srcTableName">用于表映射的源表的名称</param>
262
/// <returns>DataSet对象</returns>
263
public System.Data.DataSet GetDataSet(string sql,string srcTableName)
264![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
265
if (this.ds == null)
266![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
267
this.ds = new DataSet();
268
}
269
this.adapter = new OracleDataAdapter();
270
this.CreateCmd(sql);
271
this.adapter.SelectCommand = this.cmd;
272
this.adapter.Fill(ds,srcTableName);
273
return this.ds;
274
}
275![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
276![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
277
/// 获得DataSet(通过sql语句、表名、已存在的DataSet)
278
/// </summary>
279
/// <param name="sql">SQL语句</param>
280
/// <param name="srcTableName">用于表映射的源表的名称</param>
281
/// <param name="DataSet">已存在的DataSet对象</param>
282
/// <returns>DataSet对象</returns>
283
public System.Data.DataSet GetDataSet(string sql, string srcTableName, DataSet DataSet)
284![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
285
this.ds = DataSet;
286
return GetDataSet(sql,srcTableName);
287
}
288![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
289![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
290
#endregion
291
}
292
}
293
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
13
![ExpandedBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
14
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
15
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
16
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
18
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
19
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
20
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
21
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
22
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
23
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
24
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
25
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
26
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
27
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
28
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
29
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
30
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
31
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
32
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
33
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
34
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
35
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
36
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
37
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
38
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
39
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
40
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
41
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
42
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
43
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
44
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
45
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
46
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
47
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
48
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
49
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
50
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
51
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
52
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
53
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
54
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
55
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
56
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
57
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
58
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
59
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
60
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
61
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
62
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
63
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
64
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
65
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
66
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
67
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
68
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
69
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
70
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
71
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
72
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
73
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
74
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
75
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
76
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
77
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
78
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
79
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
80
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
81
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
82
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
83
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
84
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
85
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
86
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
87
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
88
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
89
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
90
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
91
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
92
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
93
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
94
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
95
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
96
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
97
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
98
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
99
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
100
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
101
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
102
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
103
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
104
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
105
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
106
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
107
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
108
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
109
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
110
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
111
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
112
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
113
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
114
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
115
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
116
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
117
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
118
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
119
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
120
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
121
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
122
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
123
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
124
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
125
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
126
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
127
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
128
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
129
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
130
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
131
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
132
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
133
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
134
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
135
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
136
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
137
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
138
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
139
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
140
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
141
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
142
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
143
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
144
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
145
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
146
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
147
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
148
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
149
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
150
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
151
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
152
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
153
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
154
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
155
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
156
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
157
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
158
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
159
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
160
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
161
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
162
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
163
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
164
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
165
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
166
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
167
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
168
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
169
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
170
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
171
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
172
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
173
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
174
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
175
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
176
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
177
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
178
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
179
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
180
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
181
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
182
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
183
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
184
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
185
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
186
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
187
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
188
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
189
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
190
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
191
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
192
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
193
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
194
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
195
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
196
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
197
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
198
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
199
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
200
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
201
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
202
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
203
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
204
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
205
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
206
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
207
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
208
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
209
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
210
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
211
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
212
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
213
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
214
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
215
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
216
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
217
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
218
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
219
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
220
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
221
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
222
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
223
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
224
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
225
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
226
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
227
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
228
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
229
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
230
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
231
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
232
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
233
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
234
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
235
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
236
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
237
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
238
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
239
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
240
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
241
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
242
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
243
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
244
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
245
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
246
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
247
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
248
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
249
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
250
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
251
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
252
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
253
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
254
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
255
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
256
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
257
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
258
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
259
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
260
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
261
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
262
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
263
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
264
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
265
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
266
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
267
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
268
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
269
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
270
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
271
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
272
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
273
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
274
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
275
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
276
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
277
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
278
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
279
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
280
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
281
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
282
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
283
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
284
![ExpandedSubBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![ContractedSubBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
285
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
286
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
287
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
288
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
289
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
290
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
291
![ExpandedSubBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
292
![ExpandedBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
293
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
最后就是调用它们了,不过这个不是本文的重点,就随便显示显示就OK了。
随便拉两个GridView控件,在它们的Page_Load事件中添加代码:(注意红色部分要和实际相符)
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![ContractedBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![dot.gif](https://www.cnblogs.com/Images/dot.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![ExpandedBlockEnd.gif](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![None.gif](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
基本上就OK了,Ctrl+F5就OK了。记得把两条sql语句改改~~~~`还有web.config中的连接名和连接密码要和实际的相符,否则不是连不上就是查不到东东噢~~~
conn.cs下载地址: http://files.cnblogs.com/volnet/conn[Oracle].rar