弄了一晚上研究连接字符串,给自己留个清楚的回忆~!
数据库连接字符串:
<connectionStrings>
<add name="AdventureWorksDWConnectionString" connectionString="Data Source=QQ123\SQL2005;Initial Catalog=AdventureWorksDW;Persist Security Info=True;User ID=sa;Password=7894561230."
providerName="System.Data.SqlClient" />
</connectionStrings>
在C#语句的连接方式语句:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string con = ConfigurationManager.ConnectionStrings["AdventureWorksDWConnectionString"].ConnectionString;
Label2.Text = con;

SqlConnection conn = new SqlConnection(con);

SqlDataAdapter asd = new SqlDataAdapter();
asd.SelectCommand = new SqlCommand("select * from DatabaseLog", conn);
DataSet ds = new DataSet();
asd.Fill(ds, "emp");


this.GridView1.DataSource = ds.Tables["emp"];
this.GridView1.DataBind();

}
}
<connectionStrings>
<add name="AdventureWorksDWConnectionString" connectionString="Data Source=QQ123\SQL2005;Initial Catalog=AdventureWorksDW;Persist Security Info=True;User ID=sa;Password=7894561230."
providerName="System.Data.SqlClient" />
</connectionStrings>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string con = ConfigurationManager.ConnectionStrings["AdventureWorksDWConnectionString"].ConnectionString;
Label2.Text = con;
SqlConnection conn = new SqlConnection(con);
SqlDataAdapter asd = new SqlDataAdapter();
asd.SelectCommand = new SqlCommand("select * from DatabaseLog", conn);
DataSet ds = new DataSet();
asd.Fill(ds, "emp");

this.GridView1.DataSource = ds.Tables["emp"];
this.GridView1.DataBind();

}
}

浙公网安备 33010602011771号