div-css布局:滚动鼠标两侧border消失
Javascript脚本:document对象的write()和writeln()方法区别

24th

2008,07

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

Ado.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数据文件。

代码:

  1. SqlConnectionStringBuilder sqlbldr = new SqlConnectionStringBuilder();
  2. sqlbldr.DataSource = @".\SQLExpress";
  3. sqlbldr.IntegratedSecurity = true;
  4. sqlbldr.AttachDBFilename = @"C:\SQL Server 2000 Sample Databases\PUBS.MDF";
  5. Response.Write(sqlbldr.ConnectionString);
  6. SqlConnection conn = new SqlConnection(sqlbldr.ConnectionString);
  7. conn.Open();

, ,

Del.icio.us Google书签 Digg Live Bookmark Technorati Furl Yahoo书签 Facebook 百度搜藏 新浪ViVi 365Key网摘 天极网摘 和讯网摘 博拉网 POCO网摘 添加到饭否 QQ书签 Digbuzz我挖网

Leave a reply？