对于我们一些上了年纪的程序员或者是英语不好的程序员来说,可能连连接字符串都记不住,其实也没有必要来记,下面我们看看SqlConnectionStringBuilder来帮助我们生成连接字符串.
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnectionStringBuilder scsb = new SqlConnectionStringBuilder();
scsb.DataSource = "127.0.0.1";
scsb.InitialCatalog = "mydata";
scsb.UserID = "sa";
scsb.Password = "sa";
Response.Write(scsb.ConnectionString);
}
}