C#数据库连接文件

来源：百度知道 编辑：UC知道 时间：2024/09/26 20:30:49
我在C#中 SqlConnection sqlcon = new SqlConnection("Data Source=.;Initial Catalog=user;Integrated Security=True;user id=sa;password=123456");这样建立了个数据库连接,可是我每次对数据库进行增删改查,好像都要复制这段代码....,我怎么把这个放到一个CS文件中.然后用的时候,我调用一下就可以
二位的不够详细呀..private static string connectionStr = "server=.;uid=sa;password=sa;database=ReturnBook"; 这个行吗? private 晕 能用不??
sda = new SqlDataAdapter(sql,conn); 是什么意思??

再App_Code中建一个DBConnection.cs
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
/// <summary>
/// DBConnection 的摘要说明
/// </summary>
public class DBConnection
{
private static string connectionStr = "server=.;uid=sa;password=sa;database=ReturnBook";
SqlConnection conn = null;
SqlCommand comm = null;
SqlDataAdapter sda = null;

public DataSet getDataSet(string sql)
{
conn = new SqlConnection(connectionStr);
sda = new SqlDataAdapter(sql,conn);
conn.Open();
DataSet ds = new DataSet();
try
{
sda.Fill(ds);

}