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

Star

当程序数据库发生修改后，需要执行sql脚本，以修正数据库。数据库连接字符串在web.config文件中，所以此部分设计两部分的内容：读web.config；执行sql脚本文件
( F' [0 W+ T* h: Y& e- w1 B
& c2 x/ ^) r$ v/ w读web.config是以读xml文件的方式，找到connectingstring的value，对字符串进行切割、取子字符串的方式获取访问数据库的关键信息：数据库服务器名、数据库名、访问用户名、访问密码

. r$ R, [/ k3 P% C. f对于脚本文件的执行，通过“GO”来获得脚本文件中包含的需要一次性执行的sql代码，然后再执行所有的代码块就好了

Star

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

Star

下面的这篇文章，介绍了Split方法的各种重载的应用，并有例子，字符串切割的话可以看看
http://www.itwis.com/html/net/c/20100506/8234.html
2 t- H4 h$ G# l5 u5 F
程序代码
1) public string[] Split(params char[] separator)
# h  v5 ~& {( A' E  H: Y2) public string[] Split(char[] separator, int count)
3) public string[] Split(char[] separator, StringSplitOptions options)
& |9 u/ i% ?& l7 M4) public string[] Split(string[] separator, StringSplitOptions options)
5) public string[] Split(char[] separator, int count, StringSplitOptions options)
6) public string[] Split(string[] separator, int count, StringSplitOptions options)
- n$ {. E, P8 v3 O- e: H% {$ _
下边我们通过一些实例来说明下怎么使用(以下string words = "1,2.3,,4";)：

9 k/ J; \6 H3 M) f1 q/ c! k5 \; ]1 v1. public string[] Split(params char[] separator)
, A6 a* b( P0 {- W/ x
! ]) Q4 B1 q) _6 U' N3 i+ E 程序代码
9 P* b& _2 K+ ^* O) }9 T0 n5 Wstring[] split = words.Split(new Char[] { ',' });//返回:{"1","2.3","","4"}
. S* q( h) c; Jstring[] split = words.Split(new Char[] { ',', '.' });//返回:{"1","2","3","","4"}

2. public string[] Split(char[] separator, int count)
- R  Z4 ~+ b2 C% B7 T  v$ _9 b- m
程序代码
% d6 n1 Y, Z* y8 ~string[] split = words.Split(new Char[] { ',', '.' }, 2);//返回:{"1","2.3,,4"}
% |2 L% f% Z6 i8 L! Ustring[] split = words.Split(new Char[] { ',', '.' }, 6);//返回:{"1","2","3","","4"}

3. public string[] Split(char[] separator, StringSplitOptions options)

# J3 K& M; C* A" H6 X; a) M) ~; l% | 程序代码
3 e, m$ z0 B& s' H  Fstring[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2","3","4"} 不保留空元素
string[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素

( @, ~+ s. k  W9 r4 h9 }3 y* o4. public string[] Split(string[] separator, StringSplitOptions options)

程序代码
* F9 x: `  j" ~string[] split = words.Split(new string[] { ",", "." }, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2","3","4"} 不保留空元素
string[] split = words.Split(new string[] { ",", "." }, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素
3 ?9 h6 D7 i0 h, O
5. public string[] Split(char[] separator, int count, StringSplitOptions options)

& `9 Y3 y2 O" O+ A7 t, |' T5 R 程序代码
string[] split = words.Split(new Char[] { ',', '.' }, 2, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2.3,,4"} 不保留空元素
7 E5 h6 v- T0 rstring[] split = words.Split(new Char[] { ',', '.' }, 6, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素
4 D7 [. n9 D4 ~! c
6. public string[] Split(string[] separator, int count, StringSplitOptions options)

代码
3 n1 Z( {, j+ X7 `. d+ o3 O, z# M1 m  ostring[] split = words.Split(new string[] { ",", "." }, 2, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2.3,,4"} 不保留空元素
string[] split = words.Split(new string[] { ",", "." }, 6, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素