Go homepage(回首页) Upload pictures (上传图片) Write articles (发文字帖)
The author:(作者)delvpublished in(发表于) 2014/1/23 3:12:10 Asp.net数据库操作类,c#_[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 { /// /// SqlServerDataBase 的摘要说明 /// public class SqlServerDataBase { private string strError = null; private int intCount = 0; public SqlServerDataBase() { // // TOD 在此处添加构造函数逻辑 // } /// /// 公开方法DBConn,返回数据库连接 /// /// public SqlConnection DBconn() { string strConn = "Server=(local);Database=GlobalMeetings;Uid=sa;pwd="; try { return new SqlConnection(strConn); } catch (Exception) { return null; } } /// /// 公开属性ErrorMessage,返回错误信息 /// public string ErrorMessage { get { return strError; } } /// /// 根据查询语句从数据库检索数据 /// /// 查询语句 /// 数据库连接 /// 有数据则返回DataSet对象,否则返回null 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(); } } } /// /// 更新数据库 /// /// Update Sql语句 /// 数据库连接 /// 更新成功返回true public bool Update(string UpdateString, SqlConnection SqlConn) { return udiDataBase(UpdateString, SqlConn); }
赞