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

Star

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

0 a2 ]) ^# U2 j$ c* j6 [% p0 h4 u读web.config是以读xml文件的方式，找到connectingstring的value，对字符串进行切割、取子字符串的方式获取访问数据库的关键信息：数据库服务器名、数据库名、访问用户名、访问密码

对于脚本文件的执行，通过“GO”来获得脚本文件中包含的需要一次性执行的sql代码，然后再执行所有的代码块就好了

Star

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

Star

下面的这篇文章，介绍了Split方法的各种重载的应用，并有例子，字符串切割的话可以看看
http://www.itwis.com/html/net/c/20100506/8234.html
& X0 f7 F: V* T) v) W" d4 ?$ i
程序代码
1) public string[] Split(params char[] separator)
( q& `( q* X$ ~2) public string[] Split(char[] separator, int count)
3) public string[] Split(char[] separator, StringSplitOptions options)
& ~6 P+ w( q" k4 I! v) k4) 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)
3 M0 L3 f  Q. @- I- G; F
下边我们通过一些实例来说明下怎么使用(以下string words = "1,2.3,,4";)：

1. public string[] Split(params char[] separator)
) }" v: ]6 j- y: H3 I+ R+ d5 _* M) q
程序代码
( G5 h( R( Z8 v9 istring[] split = words.Split(new Char[] { ',' });//返回:{"1","2.3","","4"}
! o9 F/ j( _, Z5 cstring[] split = words.Split(new Char[] { ',', '.' });//返回:{"1","2","3","","4"}
7 V2 A% m/ W* U% U" m- |/ X  Q
8 N+ |& l" ]. F5 y2. public string[] Split(char[] separator, int count)
4 [, s8 ]+ L. g* d# l
4 T! d  _9 }; z) p  N% S 程序代码
string[] split = words.Split(new Char[] { ',', '.' }, 2);//返回:{"1","2.3,,4"}
string[] split = words.Split(new Char[] { ',', '.' }, 6);//返回:{"1","2","3","","4"}
1 S9 p2 c% o3 w: h6 p
9 J! k8 Z8 {7 Y6 s, O: X$ Y2 b4 n3. public string[] Split(char[] separator, StringSplitOptions options)

! Z4 }5 p# v% c% u) x 程序代码
string[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2","3","4"} 不保留空元素
% O8 o; q$ B& `- G, w$ vstring[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素
. f$ Y1 q: J& w! J; k: v
4. public string[] Split(string[] separator, StringSplitOptions options)
% w5 J, H+ C) ^3 e! g
程序代码
string[] split = words.Split(new string[] { ",", "." }, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2","3","4"} 不保留空元素
2 H; q/ [$ r, f' Lstring[] split = words.Split(new string[] { ",", "." }, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素
( I0 e( c& o5 y; c5 F! }
4 @1 v& W2 K1 m' x, I5. public string[] Split(char[] separator, int count, StringSplitOptions options)
. ~: a/ r3 f/ Z& k- ?& T
. @& D" F* e+ F* {9 F 程序代码
7 i9 b" f3 a+ C6 |0 t  Sstring[] 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"} 保留空元素
# s: X  N! P( X
6. public string[] Split(string[] separator, int count, StringSplitOptions options)

* _1 x5 o' h9 R8 J' b1 V代码
string[] 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"} 保留空元素