数据库连接程序

来源：互联网发布：电子阅读器知乎编辑：程序博客网时间：2024/06/05 13:07

以下是服务器中连接数据库的程序。程序中注释掉的程序和没注释掉的程序是可以替换的，也就是他们的功能是相同的。刚学ASP.NET和SQL server 2008，想记录下来，顺便和大家分享。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Text;

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

    }

    protected void Button1_Click1(object sender, EventArgs e)
    {

      SqlConnection cnn = new SqlConnection();
        cnn.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\D0522.mdf;Integrated Security=True;User Instance=True";
       /// SqlCommand cmm = new SqlCommand();
        SqlCommand cmm = new SqlCommand("Insert Into t0522(type) Values(@type)",cnn);
      /// cmm.Connection = cnn;
        cnn.Open();
        ///cmm.CommandText = "Insert Into t0522(type)" + "Values(@type)";
        ///cmm.Parameters.Add("@type", System.Data.SqlDbType.NVarChar).Value=L1.Text; ///

        cmm.Parameters.AddWithValue("@type", L1.Text);
        ///cmm.Parameters["@type"].Value = L1.Text;
        cmm.ExecuteNonQuery();
        cnn.Close();
        Response.Write("save data succussful");

}