ASP.NET数据库操作类实例
作者:xyzqiang 时间:2024-01-12 21:01:07
本文实例讲述了ASP.NET数据库操作类。分享给大家供大家参考,具体如下:
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;
namespace Mysqlserver
{
/// <summary>
/// SqlServerDataBase 的摘要说明
/// </summary>
public class SqlServerDataBase
{
private string strError = null;
private int intCount = 0;
public SqlServerDataBase()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
/// <summary>
/// 公开方法DBConn,返回数据库连接
/// </summary>
/// <returns></returns>
public SqlConnection DBconn()
{
string strConn = "Server=(local);Database=GlobalMeetings;Uid=sa;pwd=";
try
{
return new SqlConnection(strConn);
}
catch (Exception)
{
return null;
}
}
/// <summary>
/// 公开属性ErrorMessage,返回错误信息
/// </summary>
public string ErrorMessage
{
get
{
return strError;
}
}
/// <summary>
/// 根据查询语句从数据库检索数据
/// </summary>
/// <param name="strSelect">查询语句</param>
/// <param name="SqlConn">数据库连接</param>
/// <returns>有数据则返回DataSet对象,否则返回null</returns>
public DataSet Select(string SelectString, SqlConnection sqlConn)
{
strError = "";
SqlConnection conn;
if (sqlConn == null)
{
conn = DBconn();
}
else
{
conn = sqlConn;
}
try
{
//若数据库连接的当前状态是关闭的,则打开连接
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
SqlCommand selectCommand = new SqlCommand(SelectString, conn);
selectCommand.CommandType = CommandType.Text;
mySqlDataAdapter.SelectCommand = selectCommand;
DataSet myDS = new DataSet();
mySqlDataAdapter.Fill(myDS);
return myDS;
}
catch (Exception e)
{
strError = "数据检索失败:" + e.Message;
return null;
}
finally
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
/// <summary>
/// 更新数据库
/// </summary>
/// <param name="UpdateString">Update Sql语句</param>
/// <param name="SqlConn">数据库连接</param>
/// <returns>更新成功返回true</returns>
public bool Update(string UpdateString, SqlConnection SqlConn)
{
return udiDataBase(UpdateString, SqlConn);
}
/// <summary>
/// 从数据库中删除数据
/// </summary>
/// <param name="DeleteString">Delete Sql语句</param>
/// <param name="SqlConn">数据库连接</param>
/// <returns>删除成功返回true</returns>
public bool Delete(string DeleteString, SqlConnection SqlConn)
{
return udiDataBase(DeleteString, SqlConn);
}
/// <summary>
/// 把数据插入数据库
/// </summary>
/// <param name="InsertString">Insert Sql语句</param>
/// <param name="SqlConn">数据库连接</param>
/// <returns>插入成功返回true</returns>
public bool Insert(string InsertString, SqlConnection SqlConn)
{
return udiDataBase(InsertString, SqlConn);
}
/// <summary>
/// 根据Sql语句更新数据库
/// </summary>
/// <param name="UDIString">更新语句</param>
/// <param name="SqlConn">数据库连接</param>
/// <returns>更新成功则返回true</returns>
public bool udiDataBase(string UDIString, SqlConnection SqlConn)
{
strError = "";
SqlConnection conn;
if (SqlConn == null)
{
conn = DBconn();
}
else
{
conn = SqlConn;
}
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand cmd = new SqlCommand(UDIString, conn);
cmd.CommandType = CommandType.Text;
intCount = cmd.ExecuteNonQuery();
return !(intCount < 1);
}
catch (Exception e)
{
strError = "更新数据库失败:" + e.Message;
return false;
}
finally
{
if (conn.State != ConnectionState.Closed)
{
conn.Close();
}
}
}
}
}
希望本文所述对大家asp.net程序设计有所帮助。
标签:ASP.NET,数据库,操作类
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
使用Pycharm(Python工具)新建项目及创建Python文件的教程
2022-06-07 11:43:52
![](https://img.aspxhome.com/file/2023/0/103220_0s.jpg)
解决js相同的正则多次调用test()返回的值却不同的问题
2024-04-17 09:42:18
asp如何创建Word 文件?
2009-11-14 20:47:00
python中的mock接口开发示例详解
2023-03-05 00:53:29
Go语言io pipe源码分析详情
2024-01-31 00:21:46
MySQL中组合字段之concat()
2024-01-26 04:36:54
Python中OpenCV图像特征和harris角点检测
2023-08-04 22:32:56
![](https://img.aspxhome.com/file/2023/7/95907_0s.jpg)
Django 实现外键去除自动添加的后缀‘_id’
2022-11-16 08:06:35
Python字符串内置函数功能与用法总结
2022-08-17 00:29:29
Python 实现中值滤波、均值滤波的方法
2022-05-09 08:58:38
![](https://img.aspxhome.com/file/2023/0/121100_0s.jpg)
Python函数中参数是传递值还是引用详解
2022-10-13 02:45:18
![](https://img.aspxhome.com/file/2023/9/124109_0s.png)
python怎么去除字符串最后的换行符‘\\n’
2022-06-12 21:15:24
python怎样判断一个数值(字符串)为整数
2021-07-13 21:17:57
JS+ASP实现无刷新新闻列表之分页
2007-08-22 12:57:00
网页常用特效整理:中级篇
2013-07-15 13:43:32
Python基于回溯法子集树模板实现8皇后问题
2023-09-25 08:34:45
![](https://img.aspxhome.com/file/2023/4/104884_0s.jpg)
PyTorch加载模型model.load_state_dict()问题及解决
2022-11-08 07:03:53
![](https://img.aspxhome.com/file/2023/9/66439_0s.png)
利用ASP从远程服务器上接收XML数据
2007-08-23 12:49:00
深入解析MySQL索引数据结构
2024-01-19 23:40:25
![](https://img.aspxhome.com/file/2023/9/116749_0s.png)
Sql Server “因为文件组primary已满,未能为数据库XX对象XX分配空间”问题的解决
2010-05-16 21:27:00