.NET 数据库配置链接

提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档

---

一、使用步骤

1.引入命名

代码如下（示例）：

using System.Data.SqlClient;
using System.Configuration;
using System.Data;

2.配置config

代码如下（示例）：

 <connectionStrings>
    <add name="StudentCnnString" connectionString="Data Source=PC-16;
         Initial Catalog = Student;
         Integrated Security = True;
         User Instance = False;"
         providerName =" System.Data.SqlClient"/>
  </connectionStrings>

3.增删改查操作

   public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("Data Source = PC-16; Initial Catalog=Student; Integrated Security = True;");
        con.Open();
        Response.Write("连接成功");
        con.Close();
    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        string strCon = ConfigurationManager.ConnectionStrings["StudentCnnString"].ConnectionString;
        SqlConnection con = new SqlConnection(strCon);
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "Insert into UserInfo(UserId,Password) values('" + TextBox1.Text.Trim() + "','" + TextBox2.Text.Trim() + "');";

        try
        {
            con.Open();
            Response.Write("连接成功");
        }
        catch (Exception ex)
        {
            Response.Write("链接失败，原因为 " + ex.Message);
        }
        finally
        {
            if (con.State == ConnectionState.Open) con.Close();
        }
    }

    //修改数据


    protected void Button2_Click1(object sender, EventArgs e)
    {
        string strCon = ConfigurationManager.ConnectionStrings["StudentCnnString"].ConnectionString;
        SqlConnection con = new SqlConnection(strCon);
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "Update UserInfo set Password='" + TextBox2.Text.Trim() + "' where UserId='" + TextBox2.Text.Trim() + "'";

        try
        {
            con.Open();
            int re = cmd.ExecuteNonQuery();
            if (re > 0)
                Response.Write("修改密码成功");
            else Response.Write("不存在用户名：" + TextBox1.Text);
        }
        catch (Exception ex)
        {
            Response.Write("链接失败，原因为 " + ex.Message);
        }
        finally
        {
            if (con.State == ConnectionState.Open) con.Close();
        }
    }

    protected void Button3_Click(object sender, EventArgs e)
    {
        string strCon = ConfigurationManager.ConnectionStrings["StudentCnnString"].ConnectionString;
        SqlConnection con = new SqlConnection(strCon);
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "delete From UserInfo where UserId = '" + TextBox2.Text.Trim() + "'";

        try
        {
            con.Open();
            int re = cmd.ExecuteNonQuery();
            if (re > 0)
                Response.Write("删除成功");
            else Response.Write("不存在用户名：" + TextBox1.Text);
        }
        catch (Exception ex)
        {
            Response.Write("链接失败，原因为 " + ex.Message);
        }
        finally
        {
            if (con.State == ConnectionState.Open) con.Close();
        }
    }
    //连接模式查询
    protected void Button4_Click(object sender, EventArgs e)
    {
        {
            string strCon = ConfigurationManager.ConnectionStrings["StudentCnnString"].ConnectionString;
            SqlConnection con = new SqlConnection(strCon);
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandText = "Select * from StuInfo;";
            SqlDataReader sdr = null;

            try
            {
                con.Open();
                sdr = cmd.ExecuteReader();
                GridView1.DataSource = sdr;
                GridView1.DataBind();

            }
            catch (Exception ex)
            {
                Response.Write("shaxun失败，原因为 " + ex.Message);
            }
            finally
            {
                if (con.State == ConnectionState.Open) con.Close();
            }
        }
    }
}

 //断开模式查询数据
    protected void Button2_Click(object sender, EventArgs e)
    {
        string strCnn = ConfigurationManager.ConnectionStrings["StudentCnnString"].ConnectionString;
        SqlConnection con = new SqlConnection(strCnn);
        SqlDataAdapter sda = new SqlDataAdapter("select * from StuInfo;", con);

        DataTable dt = new DataTable();
        try
        {
            sda.Fill(dt);
            GridView2.DataSource = dt;
            GridView2.DataBind();
        }
        catch (Exception ex)

        {
            Response.Write("shaxun失败，原因为 " + ex.Message);
        }
    }

---

添加了两个botton

总结

基础中的基础，数据库连接操做