统计下DataAccess常用方法 我常用。。public bool insert(string sql) 哈哈~~~增删改查类似 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Raptier生成数据库访问类程序通过业务逻辑层,访问数据逻辑层,然后访问数据控制层,由数据控制层访问数据库访问类,数据库访问类操作数据库 /****************************************************************** * Copyright(c) KiteSoft Studio * Description : * CreateDate : 2006-04-13 10:30:58 * Creater : Johnson Cao * LastChangeDate: * LastChanger : * Version Info : * ******************************************************************/using System;using System.Collections;using System.Data;namespace KiteSoft.Data{ /// <summary> /// Summary description for IDataAdapter. /// </summary> public interface IDataAccess { #region Member DataSourceType DataSourceType { get; set; } string ConnectionString { get; set; } Exception LastException { get; } ConnectionState State { get; } bool SupportStoredProcedure { get; } #endregion #region Connect Management bool Connect(); bool Connect(string connectionString); bool Disconnect(); void BeginTransaction(); void Rollback(); void Commit(); #endregion #region Data Operation bool ExecuteNonQuery(string SQL, params object[] Params); bool ExecuteNonQueryByProc(string ProcName, params object[] Params); // Ojbect operation object LoadSingleObject(Type ObjectType, string SQL, params object[] Params); object LoadSingleObjectByProc(Type ObjectType, string ProcName, params object[] Params); bool LoadSingleObject(object AObj, string SQL, params object[] Params); bool LoadSingleObjectByProc(object AObj, string ProcName, params object[] Params); bool LoadList(IList List, Type ObjectType, string SQL, params object[] Params); bool LoadListByProc(IList List, Type ObjectType, string ProcName, params object[] Params); object LoadScalar(string SQL, params object[] Params); object LoadScalarByProc(string ProcName, params object[] Params); // DataSet operation DataTable LoadSchema(string TableName); bool FillDataSet(DataSet dataSet, string tableName, string SQL, params object[] Params); bool FillDataSetByProc(DataSet dataSet, string tableName, string ProcName, params object[] Params); IDataReader ExecuteReader(string SQL, params object[] Params); IDataReader ExecuteReaderByProc(string ProcName, params object[] Params); #endregion }} public static string FieldAsString(System.Data.DataRow row,string FieldName,string Format) { if (row.IsNull(FieldName)) { return ""; } object item = row[FieldName]; if (item.GetType() == System.Type.GetType("System.DateTime")) { DateTime d; d = (DateTime)item; return d.ToString(Format); } return item.ToString(); } 用nhibernate 来访问数据库中的数据很方便 c# 窗体猴子选大王 数组类问题 datareader C#程序问题 帮忙解决这个问题 在VS中如何绑定快捷键,并实现自己写的功能,比如空格键。(窗体上默认是文本框获得焦点) 急问请教关于C#中画图处理 关于使次窗体关闭,主窗体保留的问题,请高手指点,谢谢! 已经存在一个资源文件,如何通过已经有的程序将其还原为一个页面? 【分享】类似WinHex的十六进制显示控件 关于LISTVIEW SqlDataReader 读取结果的问题 为什么我的vs,已安装的模板那么少?
生成数据库访问类
程序通过业务逻辑层,访问数据逻辑层,然后访问数据控制层,由数据控制层访问数据库访问类,数据库访问类操作数据库
* Copyright(c) KiteSoft Studio
* Description :
* CreateDate : 2006-04-13 10:30:58
* Creater : Johnson Cao
* LastChangeDate:
* LastChanger :
* Version Info :
* ******************************************************************/
using System;
using System.Collections;
using System.Data;namespace KiteSoft.Data
{
/// <summary>
/// Summary description for IDataAdapter.
/// </summary>
public interface IDataAccess
{
#region Member
DataSourceType DataSourceType { get; set; }
string ConnectionString { get; set; }
Exception LastException { get; }
ConnectionState State { get; }
bool SupportStoredProcedure { get; }
#endregion #region Connect Management
bool Connect();
bool Connect(string connectionString);
bool Disconnect();
void BeginTransaction();
void Rollback();
void Commit();
#endregion #region Data Operation
bool ExecuteNonQuery(string SQL, params object[] Params);
bool ExecuteNonQueryByProc(string ProcName, params object[] Params);
// Ojbect operation
object LoadSingleObject(Type ObjectType, string SQL, params object[] Params);
object LoadSingleObjectByProc(Type ObjectType, string ProcName, params object[] Params);
bool LoadSingleObject(object AObj, string SQL, params object[] Params);
bool LoadSingleObjectByProc(object AObj, string ProcName, params object[] Params);
bool LoadList(IList List, Type ObjectType, string SQL, params object[] Params);
bool LoadListByProc(IList List, Type ObjectType, string ProcName, params object[] Params);
object LoadScalar(string SQL, params object[] Params);
object LoadScalarByProc(string ProcName, params object[] Params); // DataSet operation
DataTable LoadSchema(string TableName);
bool FillDataSet(DataSet dataSet, string tableName, string SQL, params object[] Params);
bool FillDataSetByProc(DataSet dataSet, string tableName, string ProcName, params object[] Params);
IDataReader ExecuteReader(string SQL, params object[] Params);
IDataReader ExecuteReaderByProc(string ProcName, params object[] Params);
#endregion
}
}
{
if (row.IsNull(FieldName))
{
return "";
} object item = row[FieldName];
if (item.GetType() == System.Type.GetType("System.DateTime"))
{
DateTime d;
d = (DateTime)item;
return d.ToString(Format);
}
return item.ToString();
}