升级程序开发——读Web.config、执行Sql脚本

Star

当程序数据库发生修改后，需要执行sql脚本，以修正数据库。数据库连接字符串在web.config文件中，所以此部分设计两部分的内容：读web.config；执行sql脚本文件

. j7 Z! p' A7 R- C/ e) o  y6 e- B读web.config是以读xml文件的方式，找到connectingstring的value，对字符串进行切割、取子字符串的方式获取访问数据库的关键信息：数据库服务器名、数据库名、访问用户名、访问密码
/ |7 h+ ~3 E, `4 ]7 I" Z) ^
! f/ E7 B6 i6 `$ ~* e对于脚本文件的执行，通过“GO”来获得脚本文件中包含的需要一次性执行的sql代码，然后再执行所有的代码块就好了

Star

这里是参考的这篇文章的做法，但是，这篇文章是用C#执行sql文件，再将连接字符串写到web.config中，和我的应用有些差别
http://blog.sina.com.cn/s/blog_4a50d85b0100lzi2.html

Star

下面的这篇文章，介绍了Split方法的各种重载的应用，并有例子，字符串切割的话可以看看
http://www.itwis.com/html/net/c/20100506/8234.html
! O- l1 T- }/ V1 R# R% H$ f) M
( Z/ I0 h/ z. o" M  s; H( b程序代码
) O. g, q8 `  J  `2 S5 j* |) Y& d1) public string[] Split(params char[] separator)
2) public string[] Split(char[] separator, int count)
1 g) L& J; k6 W/ c% @3) public string[] Split(char[] separator, StringSplitOptions options)
4 O: ]8 H" ]7 E5 g4) public string[] Split(string[] separator, StringSplitOptions options)
9 j  {4 S# {, S+ k! a' o) x5) public string[] Split(char[] separator, int count, StringSplitOptions options)
6) public string[] Split(string[] separator, int count, StringSplitOptions options)
0 e4 ~5 S% I# L2 i+ Y
, A9 V0 s% z, q8 y! Z, v0 g4 b下边我们通过一些实例来说明下怎么使用(以下string words = "1,2.3,,4";)：

9 C2 {9 }5 L7 t/ a3 O1 G! }( n4 |1. public string[] Split(params char[] separator)

程序代码
string[] split = words.Split(new Char[] { ',' });//返回:{"1","2.3","","4"}
string[] split = words.Split(new Char[] { ',', '.' });//返回:{"1","2","3","","4"}
9 O4 u; z0 g( F
: ^0 |' `& A; ]) j+ R/ @. ^3 `2. public string[] Split(char[] separator, int count)
' R; A: |' ^1 a( U8 T
程序代码
0 C5 c# q) k. i3 s% I3 m" Qstring[] split = words.Split(new Char[] { ',', '.' }, 2);//返回:{"1","2.3,,4"}
string[] split = words.Split(new Char[] { ',', '.' }, 6);//返回:{"1","2","3","","4"}
' q3 k1 I( g" _3 U9 K. r9 _" s% b% u
$ f$ G5 P3 {+ {; ?# K( _0 d3. public string[] Split(char[] separator, StringSplitOptions options)

程序代码
string[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2","3","4"} 不保留空元素
, a2 A* f9 e4 i/ X9 G9 e( f  pstring[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素
* N0 e( }* i4 T: R0 T7 t
4. public string[] Split(string[] separator, StringSplitOptions options)

4 p8 `2 l  L+ L" q: C4 T 程序代码
string[] split = words.Split(new string[] { ",", "." }, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2","3","4"} 不保留空元素
string[] split = words.Split(new string[] { ",", "." }, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素
7 M3 I% U: u) s9 H/ _  o6 t
: `7 }! L: m* W3 G5 Q5. public string[] Split(char[] separator, int count, StringSplitOptions options)

4 N5 ?" Q( o/ @7 ~5 R6 [ 程序代码
string[] split = words.Split(new Char[] { ',', '.' }, 2, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2.3,,4"} 不保留空元素
string[] split = words.Split(new Char[] { ',', '.' }, 6, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素
7 n8 V6 j; e( q, n2 D! A
6. public string[] Split(string[] separator, int count, StringSplitOptions options)
2 I$ W, f( H/ T
代码
string[] split = words.Split(new string[] { ",", "." }, 2, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2.3,,4"} 不保留空元素
  M! ?1 H8 X1 rstring[] split = words.Split(new string[] { ",", "." }, 6, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素