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

Star

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

% F9 a& Y" `2 h1 \; A读web.config是以读xml文件的方式，找到connectingstring的value，对字符串进行切割、取子字符串的方式获取访问数据库的关键信息：数据库服务器名、数据库名、访问用户名、访问密码
+ R  F4 o) T9 d1 V. j
7 z- k- p% l% q/ E! G对于脚本文件的执行，通过“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
+ B5 G. T( O9 {2 c  r7 N
程序代码
1) public string[] Split(params char[] separator)
2) public string[] Split(char[] separator, int count)
3) public string[] Split(char[] separator, StringSplitOptions options)
4) public string[] Split(string[] separator, StringSplitOptions options)
5) public string[] Split(char[] separator, int count, StringSplitOptions options)
+ i, ~4 _' Z, O6 g6) public string[] Split(string[] separator, int count, StringSplitOptions options)
# E" `: H2 V( ?' e/ Y$ N7 K6 ?& ?
1 U5 G: _% v* B. T下边我们通过一些实例来说明下怎么使用(以下string words = "1,2.3,,4";)：

% I8 D/ b5 Q" k1. public string[] Split(params char[] separator)

+ q: Z1 B0 _$ m" W- Y 程序代码
string[] split = words.Split(new Char[] { ',' });//返回:{"1","2.3","","4"}
string[] split = words.Split(new Char[] { ',', '.' });//返回:{"1","2","3","","4"}

% b" _6 D; M  g% r% K: K; T( W: |2. public string[] Split(char[] separator, int count)
" J" l" V$ j' X9 h0 V" K- J+ g
程序代码
string[] split = words.Split(new Char[] { ',', '.' }, 2);//返回:{"1","2.3,,4"}
# }8 n" g* [2 W/ @. c' @1 X, kstring[] split = words.Split(new Char[] { ',', '.' }, 6);//返回:{"1","2","3","","4"}
/ v7 P- \1 y# _6 ]) l2 \" V
6 B; K; g0 |) v! g% ]3. public string[] Split(char[] separator, StringSplitOptions options)

( O. m/ @( v6 ]4 N  c9 N9 g 程序代码
& H& R* l0 W4 V' Y# wstring[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2","3","4"} 不保留空元素
# t6 l! K3 }! X$ P& V' j# ^4 ustring[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素

' z3 l( @1 F! C$ k4. public string[] Split(string[] separator, StringSplitOptions options)

" W' }* i3 ^5 a/ H8 ~8 F8 A 程序代码
string[] split = words.Split(new string[] { ",", "." }, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2","3","4"} 不保留空元素
) G& V8 x7 m: k) e+ Y1 wstring[] split = words.Split(new string[] { ",", "." }, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素

5. public string[] Split(char[] separator, int count, StringSplitOptions options)
. `) O  Y/ D6 b, v  C
: t4 B; f6 f" z# h 程序代码
# s4 l: J1 ^+ W/ O% i% {/ F4 [string[] split = words.Split(new Char[] { ',', '.' }, 2, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2.3,,4"} 不保留空元素
4 X6 Z$ x/ K# B# l' M, G- vstring[] split = words.Split(new Char[] { ',', '.' }, 6, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素

7 y9 P, w1 n7 f3 m0 Z6. public string[] Split(string[] separator, int count, StringSplitOptions options)

" P4 i0 v$ p4 k; y代码
2 M& h9 t  g5 l. _+ [8 dstring[] 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"} 保留空元素