24th

07.08

Ado.net 介绍：连接字符串生成器-SqlConnectionStringBuilder类

No CommentAdo.netcngothic

Ado.net 介绍：连接字符串生成器-SqlConnectionStringBuilder
使用连接字符串生成器可以方便准确的生成数据库连接字符串。且于防止注入也有一定的益处。
采用SqlConnectionStringBuilder来生成连接字符串：
代码:

  1. SqlConnectionStringBuilder sqlbldr = new SqlConnectionStringBuilder();
  2. sqlbldr.DataSource = "CNGOTHIC";
  3. sqlbldr.UserID = "sa";
  4. sqlbldr.Password = "cngothic";
  5. sqlbldr.InitialCatalog = "pubs";
  6. sqlbldr.IntegratedSecurity = true;
  7. Response.Write(sqlbldr.ConnectionString);
  8. SqlConnection conn = new SqlConnection(sqlbldr.ConnectionString);
  9. conn.Open();

此时输出内容为：Data Source=CNGOTHIC;Initial Catalog=pubs;Integrated Security=True;User ID=sa;Password=gothic
即sqlbldr.ConnectionString的内容;
下面再介绍下。如果加载mdf数据文件。
Read the rest of this entry »

, ,