当前位置: 代码迷 >> ASP.NET >> 每次在后台代码里都要加上 using System.Data.SqlClient,该如何解决
  详细解决方案

每次在后台代码里都要加上 using System.Data.SqlClient,该如何解决

热度:6168   发布时间:2013-02-25 00:00:00.0
每次在后台代码里都要加上 using System.Data.SqlClient
每次在后台写代码里都要加上 using System.Data.SqlClient
在Web config文件里可以直接添加吗?

------解决方案--------------------------------------------------------
把你的数据库操作写成个类如
C# code
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;using System.Threading;/// <summary>/// database 的摘要说明/// </summary>public class database{    public database()    {        //        // TODO: 在此处添加构造函数逻辑        //    }    public string MassageBox(string TxtMassage) {        string str;        str = "<script language=javascript>alert('" + TxtMassage + "')</script>";        return str;    }    public Boolean Exect(string sQueryString) {        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);        conn.Open();        SqlCommand cmd = new SqlCommand(sQueryString, conn);        try        {            cmd.ExecuteNonQuery();            conn.Close();        }        catch (System.Exception e) {            conn.Close();            return false;        }        return true;    }    public System.Data.DataSet GetDataSet(string sQueryString, string TableName) {        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);        conn.Open();        SqlDataAdapter dbAdapter = new SqlDataAdapter(sQueryString, conn);        DataSet ds = new DataSet();        dbAdapter.Fill(ds, TableName);        conn.Close();        return ds;    }}
  相关解决方案