[聚合文章] vs链接 SQL server（Visual Studio2015 链接sql server 2014）

到这里 vs和 sql server 链接成功。

采用下面最少代码，进行测试

code

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;using System.Configuration;public partial class _Default : System.Web.UI.Page{    protected void Page_Load(object sender, EventArgs e)    {        SqlConnection con = new SqlConnection();        con.ConnectionString = "Data Source=DESKTOP-D5KAKHM;Initial Catalog=df;Integrated Security=True ";        con.Open();        SqlCommand com = new SqlCommand();        com.Connection = con;        if(DropDownList1.SelectedValue=="all")        com.CommandText = "select *  from person";        else        com.CommandText = "select * from person where sf='" + DropDownList1.SelectedValue + "'";        SqlDataReader dr = com.ExecuteReader();        GridView1.DataSource = dr;        GridView1.DataBind();
                
注：本文内容来自互联网，旨在为开发者提供分享、交流的平台。如有涉及文章版权等事宜，请你联系站长进行处理。