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

Star

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

读web.config是以读xml文件的方式，找到connectingstring的value，对字符串进行切割、取子字符串的方式获取访问数据库的关键信息：数据库服务器名、数据库名、访问用户名、访问密码

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

Star

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

Star

下面的这篇文章，介绍了Split方法的各种重载的应用，并有例子，字符串切割的话可以看看
  w% {, ~+ ~6 Z9 a% ahttp://www.itwis.com/html/net/c/20100506/8234.html
, S% W2 d# q6 j4 ~; _
程序代码
1) public string[] Split(params char[] separator)
2) public string[] Split(char[] separator, int count)
0 c& n1 Y0 S4 ?% Z( b3) 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)
5 q) f$ @' C: c3 T8 o6) public string[] Split(string[] separator, int count, StringSplitOptions options)

& x, V( N: j% q" P2 t. _下边我们通过一些实例来说明下怎么使用(以下string words = "1,2.3,,4";)：

1. public string[] Split(params char[] separator)
' [4 D( q7 p" K, |" Q+ |" ?
程序代码
string[] split = words.Split(new Char[] { ',' });//返回:{"1","2.3","","4"}
string[] split = words.Split(new Char[] { ',', '.' });//返回:{"1","2","3","","4"}
- S3 W0 S3 W& r4 Y" m7 A
2. public string[] Split(char[] separator, int count)

9 H, \( |3 N4 @  T 程序代码
string[] split = words.Split(new Char[] { ',', '.' }, 2);//返回:{"1","2.3,,4"}
string[] split = words.Split(new Char[] { ',', '.' }, 6);//返回:{"1","2","3","","4"}
/ {0 v& v' \8 T3 b9 p
5 Y; L0 H; J4 m  S8 J6 C. d3. public string[] Split(char[] separator, StringSplitOptions options)
$ z- ?$ X1 {1 C5 \4 L
程序代码
5 l% J) L7 q- ?( P& @string[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2","3","4"} 不保留空元素
$ ~. ]$ W9 h" t9 }0 g2 L- kstring[] split = words.Split(new Char[] { ',', '.' }, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素

: Q5 |1 Z& T! o* s4. public string[] Split(string[] separator, StringSplitOptions options)

程序代码
1 B1 J! q5 C( t+ cstring[] split = words.Split(new string[] { ",", "." }, StringSplitOptions.RemoveEmptyEntries);//返回:{"1","2","3","4"} 不保留空元素
# x. F7 G$ |% C  T9 {string[] split = words.Split(new string[] { ",", "." }, StringSplitOptions.None);//返回:{"1","2","3","","4"} 保留空元素

5. public string[] Split(char[] separator, int count, StringSplitOptions options)
7 t& y3 R) Y( u( p
8 ], ?1 y4 y) P" V. ~ 程序代码
# P$ k* g- g& N4 v/ V+ g6 zstring[] 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"} 保留空元素

; H6 i% s& O0 r+ X& z8 P7 |6. public string[] Split(string[] separator, int count, StringSplitOptions options)

' U& o" l: {! n* d! ~- u3 @代码
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"} 保留空元素