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

Star

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

9 a/ B+ d: ^3 E8 A; `+ }读web.config是以读xml文件的方式，找到connectingstring的value，对字符串进行切割、取子字符串的方式获取访问数据库的关键信息：数据库服务器名、数据库名、访问用户名、访问密码

对于脚本文件的执行，通过“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

$ D3 @2 f8 `5 p8 l  o" G程序代码
, [; |% W3 Z/ m5 P- S3 w1) public string[] Split(params char[] separator)
2) public string[] Split(char[] separator, int count)
. d; a5 }8 u6 c, A3) public string[] Split(char[] separator, StringSplitOptions options)
4) public string[] Split(string[] separator, StringSplitOptions options)
: R) Y) n* `, w& |, |5 o+ {5 I- _5) public string[] Split(char[] separator, int count, StringSplitOptions options)
6) public string[] Split(string[] separator, int count, StringSplitOptions options)
- _* x" w8 T! b: `: X* M( M
下边我们通过一些实例来说明下怎么使用(以下string words = "1,2.3,,4";)：
/ \( D- Y$ H: ?7 C3 \5 q
" N* e% @; f# L# b6 }+ m1. public string[] Split(params char[] separator)
  `% K8 P# p5 t7 f, s) q1 S  Z
程序代码
string[] split = words.Split(new Char[] { ',' });//返回:{"1","2.3","","4"}
string[] split = words.Split(new Char[] { ',', '.' });//返回:{"1","2","3","","4"}
% B* i+ Y3 N/ e$ w' e4 @2 L
+ B# i. y" L* \; J2 d2. public string[] Split(char[] separator, int count)

5 n. x9 i( c; @! N6 e. ]7 \$ d 程序代码
string[] split = words.Split(new Char[] { ',', '.' }, 2);//返回:{"1","2.3,,4"}
string[] split = words.Split(new Char[] { ',', '.' }, 6);//返回:{"1","2","3","","4"}

" x( X0 v& b! d2 a. ^+ R# H  b& B# R7 O3. public string[] Split(char[] separator, StringSplitOptions options)
6 g/ D6 U7 W1 U( ]! n6 t* t
- n) H* w4 Q' F3 q3 A5 u/ t 程序代码
7 ^. ]; J$ G$ m5 T# s, z" `/ |! nstring[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2","3","4"} 不保留空元素
string[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素
: _( D' |* G. B2 F
4. public string[] Split(string[] separator, StringSplitOptions options)
5 ]5 g* t* l4 L8 R6 L' M( S# j
, ~+ {( X" J5 C1 K, G  v, y 程序代码
2 t9 Z( l- ?3 w4 R! 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"} 保留空元素
7 h, M' R3 ~9 [& x2 _2 S: h. W, g; N
5. public string[] Split(char[] separator, int count, StringSplitOptions options)
8 Z( S$ h! o" e. n6 L3 C
程序代码
string[] split = words.Split(new Char[] { ',', '.' }, 2, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2.3,,4"} 不保留空元素
+ L" b' F9 s. y* r1 B+ v: @string[] split = words.Split(new Char[] { ',', '.' }, 6, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素

3 l5 }) c7 W! @6 w5 C' g4 |6. public string[] Split(string[] separator, int count, StringSplitOptions options)
, C# S) |' U2 V  s, A9 j) E
. ~5 s. L# J9 \* A' N代码
" I9 W4 v. b' a" ~' _string[] split = words.Split(new string[] { ",", "." }, 2, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2.3,,4"} 不保留空元素
7 s7 |& I) S& g5 }string[] split = words.Split(new string[] { ",", "." }, 6, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素