測試一下 namespace PubFunction
{
///
/// DbAccessing 的摘要说明
///
public class DbAccessing : System.Web.UI.Page
{
public SqlConnection dbConn;
///
/// 數據連結方法 DbAccessing
///
public DbAccessing()
{
setConn();
}
///
/// 連接config的方法 setConn
///
protected void setConn()
{
dbConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["TestSqlServer"].ConnectionString);
}
///
/// 連接config的方法 setConns
///
public SqlConnection setConns()
{
dbConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["TestSqlServer"].ConnectionString);
return dbConn;
}
///
/// 執行一個SQL語句,ExecuteSql方法 返回bool類型
///
///
///
public bool ExecuteSql(string strSQL)
{
SqlCommand cmd = new SqlCommand(strSQL, dbConn);
bool returnValue = false;
try
{
if (dbConn.State != ConnectionState.Open)
dbConn.Open();
cmd.ExecuteNonQuery();
returnValue = true;
}
catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
dbConn.Close();
}
return returnValue;
}
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/183242/viewspace-528628/ ,如需转载,请注明出处,否则将追究法律责任。