本文实例讲述了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优化技巧总结》、《asp.net字符串操作技巧汇总》、《asp.net操作XML技巧总结》、《asp.net文件操作技巧汇总》、《asp.net ajax技巧总结专题》及《asp.net缓存操作技巧总结》。
希望本文所述对大家asp.net程序设计有所帮助。
微软将会在今年下半年发布Win10 21H2,带来Sun Valley界面更新,解决当前Win10系...
就像之前写的mysql全面优化详解一样,就是因为这样工具应用十分广泛,所以对这样...
项目用的是ssh,使用jquery的$.post访问struts2的Action,哪里都没有报错,可就...
本文实例讲述了php回调函数处理数组操作。分享给大家供大家参考,具体如下: arr...
复制代码 代码如下: %@ Language=VBScript %%Response.Expires =0 % DOCTYPE htm...
1.创建一个类MyUserlogDBHelper去继承SQLiteOpenHelper在该类里面创建表。 packa...
Get方法在超链接后边紧跟要传递的参数对于用户是可见的如:http://tieba.baidu.c...
本文实例讲述了yii 框架实现按天,月,年,自定义时间段统计数据的方法。分享给...
在开发过程中,数据库是必不可少的一环,但大多数情况下开发者们还是在用命令行...
一. XML的大本营 XML是由W3C(World Wide Web Consortium)国际组织负责开发和制定...