以下是服务器中连接数据库的程序。程序中注释掉的程序和没注释掉的程序是可以替换的,也就是他们的功能是相同的。刚学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");
}
}