1.web.config文件
<connectionStrings>
/*数据库文件配置在sql server默认路径下*/
<add name="ConnString" connectionString="Server=localhost/SQLExpress;Initial Catalog=Northwind;Integrated Security=SSPI" />
/*数据库文件配置在sql server默认路径下*/
<add name="ConnString" connectionString="Data Source=./SQLEXPRESS;AttachDbFilename=|DataDirectory|/Northwind.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient" />
</connectionStrings>
2.cs文件
需要引用
using System.Data.SqlClient;
using System.Configuration;
SqlConnection sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString);
#region 打开数据库连接
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
if (sqlcon == null)
{
sqlcon = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString);
}
if (sqlcon.State == System.Data.ConnectionState.Closed)
{
sqlcon.Open();
}
}
#endregion
#region 返回DataSet数据类型
/// <summary>
/// 此方法返回一个DataSet类型
/// </summary>
public DataSet ExceDS(String SqlCom)
{
try
{
sqlcom = new SqlCommand(SqlCom, sqlcon);
sqldata = new SqlDataAdapter();
sqldata.SelectCommand = sqlcom;
DataSet ds = new DataSet();
sqldata.Fill(ds);
return ds;
}
finally
{}
}
#endregion
public DataTable ExceDT(String SqlCom)
{
try
{
sqlcom = new SqlCommand(SqlCom, sqlcon);
sqldata = new SqlDataAdapter();
sqldata.SelectCommand = sqlcom;
DataTable dt = new DataTable();
sqldata.Fill(dt);
return dt;
}
finally
{}
}
#endregion
#region 将查询结果集中的数据通过绑定GridView控件显示出来
/// <summary>
/// 将查询结果集中的数据通过绑定GridView控件显示出来
/// </summary>
public void gvdatabind(GridView gv,string str)
{
sqldata = new SqlDataAdapter(str, sqlcon);
DataSet ds=new DataSet();
sqldata.Fill(ds);
gv.DataSource = ds;
gv.DataBind();
}
#endregion
#region 执行SQL语句
/// <summary>
/// 此方法来执行SQL语句
/// </summary>
public bool ExceSQL(String SqlCom)
{
sqlcom = new SqlCommand(SqlCom, sqlcon);
try
{
sqlcom.ExecuteNonQuery();
System.Web.HttpContext.Current.Response.Write("<script language=javascript>alert('提示:操作已成功!')</script>");
return true;
}
catch
{
System.Web.HttpContext.Current.Response.Write("<script language=javascript>alert('错误:操作未完成!')</script>");
return false;
}
finally
{}
}
#endregion