会员
周边
众包
新闻
博问
闪存
所有博客
当前博客
我的博客
我的园子
账号设置
简洁模式
...
退出登录
注册
登录
在云那方
首页
新随笔
联系
订阅
管理
公告
C#数据库操作类
using
System;
using
System.Data;
using
System.Data.SqlClient;
using
System.ComponentModel;
namespace
DAL
{
/**/
///
///
糸统用到的方法
///
public
class
ManageDAO
{
SqlConnection objConn;
public
ManageDAO()
{
string
conSQL
=
EtoonProductConfiguration.ConnectionString;
objConn
=
new
SqlConnection(conSQL);
}
//
执行
public
bool
ExecSQL(
string
str)
{
try
{
objConn.Open();
SqlCommand cmd
=
objConn.CreateCommand();
cmd.CommandText
=
str;
cmd.CommandTimeout
=
1000
;
cmd.ExecuteNonQuery();
objConn.Close();
objConn.Dispose();
return
true
;
}
catch
(SqlException e)
{
throw
e;
}
}
//
查询
public
DataSet FindMange(
string
sql)
{
try
{
objConn.Open();
DataSet dt
=
new
DataSet();
SqlDataAdapter da
=
new
SqlDataAdapter(sql,objConn);
da.Fill(dt);
objConn.Close();
objConn.Dispose();
return
dt;
}
catch
(SqlException e)
{
throw
e;
}
}
//
执行存储过程,带输出参数
public
string
ExecuteProc1(
string
procName,SqlParameter []sp,SqlParameter out_sp)
{
objConn.Open();
SqlCommand sqlCmd
=
objConn.CreateCommand();
sqlCmd.CommandText
=
procName;
sqlCmd.CommandType
=
CommandType.StoredProcedure;
try
{
foreach
(SqlParameter s
in
sp)
{
sqlCmd.Parameters.Add(s);
}
sqlCmd.Parameters.Add(out_sp);
out_sp.Direction
=
ParameterDirection.Output;
sqlCmd.ExecuteNonQuery();
objConn.Close();
return
out_sp.Value.ToString();;
}
catch
(SqlException ee)
{
throw
ee;
}
}
//
执行存储过程,返回真假(带参数)
public
bool
ExecuteProc(
string
procName,SqlParameter []sp)
{
objConn.Open();
SqlCommand sqlCmd
=
objConn.CreateCommand();
sqlCmd.CommandText
=
procName;
sqlCmd.CommandType
=
CommandType.StoredProcedure;
try
{
foreach
(SqlParameter s
in
sp)
{
sqlCmd.Parameters.Add(s);
}
sqlCmd.ExecuteNonQuery();
objConn.Close();
return
true
;
}
catch
(SqlException ee)
{
throw
ee;
}
}
//
执行存储过程,返回真假(不带参数)
public
bool
ExecuteProc(
string
procName)
{
objConn.Open();
SqlCommand sqlCmd
=
objConn.CreateCommand();
sqlCmd.CommandText
=
procName;
sqlCmd.CommandType
=
CommandType.StoredProcedure;
try
{
sqlCmd.ExecuteNonQuery();
objConn.Close();
return
true
;
}
catch
(SqlException ee)
{
throw
ee;
}
}
//
执行存储过程,返回记录集
private
DataSet FillClientproData(String commandText,SqlParameter[] prams)
{
objConn.Open();
SqlCommand command
=
objConn.CreateCommand();
command.CommandText
=
commandText;
command.CommandType
=
CommandType.StoredProcedure;
try
{
foreach
(SqlParameter parameter
in
prams)
command.Parameters.Add(parameter);
SqlDataAdapter ds
=
new
SqlDataAdapter(command);
DataSet data
=
new
DataSet();
ds.Fill(data);
return
data;
}
catch
(SqlException ee)
{
throw
ee;
}
}
}
}
posted on
2008-07-04 13:55
Rich.T
阅读(
601
) 评论(
2
)
编辑
收藏
举报
会员力量,点亮园子希望
刷新页面
返回顶部
Powered by:
博客园
Copyright © 2024 Rich.T
Powered by .NET 8.0 on Kubernetes