要在VS2005中使用sqlhelper类,必须把Microsoft.ApplicationBlocks.Data.dll引用到项目中.
1.通过存储过程查询的方法SqlHelper.ExecuteDataset(数据库连接字符, 存储过程字符, 参数数组);
2.通过字符串查询的方法SqlHelper.ExecuteDataset(数据库连接字符, CommandType.Text , 查询字符串,参数数组);
3.通过存储过程插入的方法SqlHelper.ExecuteScalar(数据库连接字符, 存储过程字符, 参数数组);
4.通过字符串插入的方法SqlHelper.ExecuteScalar(数据库连接字符, CommandType.Text , 插入及刷新字符串,参数数组);
5.通过存储过程刷新的方法SqlHelper.ExecuteNonQuery(数据库连接字符, 存储过程字符, 参数数组);
6.通过字符串刷新的方法SqlHelper.ExecuteNonQuery(数据库连接字符, CommandType.Text , 刷新字符串,参数数组);
运用实例
?
?
using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;
using System.IO;
namespace SK.VideoDAL
{
?/// <summary>
?/// File 的摘要说明。
?/// </summary>
?
public class File
?{

/// <summary>
/// 文件数据访问类
/// </summary>
public File()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
/// <summary>
/// 添加文件
/// </summary>
/
// <param name="FileClassID">文件分类编号</param>
/// <param name="SetCommend">推荐方式</param>
/// <param name="SetTop">固顶方式</param>
/// <param name="Name">文件名称</param>
/// <param name="Intro">简介</param>
/// <param name="FileSize">大小</param>
/// <param name="Grade">评级</param>
/// <param name="Keyword">关键字</param>
/// <param name="PreviewUrl">预览图地址</param>
/// <param name="MemberID">发布人ID</param>
/// <param name="FileTypeID">文件类别编号</param>
/// <param name="DownRequire">下载要求</param>
/// <param name="NeedPoint">下载所需点数</param>
/// <param name="Status">状态</param>
public object Add(object FileClassID,object SetCommend,object SetTop,object Name,objec
t Intro,
object FileSize,object Grade,object Keyword,object PreviewUrl,object MemberID,object FileTypeID,
object DownRequire,object NeedPoint,object Status,object Actor,object Level,object Region)
{
SqlParameter[] oParms = new SqlParameter[17];
oParms[0]=new SqlParameter("@FileClassID",FileClassID);
oParms[1]=new SqlParameter("@SetCommend",SetCommend);
oParms[2]=new SqlParameter("@SetTop",SetTop);
oParms[3]=new SqlParameter("@Name",Name);
oParms[4]=new SqlParameter("@Intro",Intro);
oParms[5]=new SqlParameter("@FileSize",FileSize);
oParms[6]=new SqlParameter("@Grade",Grade);
oParms[7]=new SqlParameter("@Keyword",Keyword);
oParms[8]=new SqlParameter("@PreviewUrl",PreviewUrl);
oParms[9]=new SqlParameter("@MemberID",MemberID);
oParms[10]=new SqlParameter("@FileTypeID",FileTypeID);
oParms[11]=new SqlParameter("@DownRequire",DownRequire);
oParms[12]=new SqlParameter("@NeedPoint",NeedPoint);
oParms[13]=new SqlParameter("@Status",Status);
oParms[14]=new SqlParameter("@Actor",Actor);
oParms[15]=new SqlParameter("@Level",Level);
oParms[16]=new SqlParameter("@Region",Region);

return SqlHelper.ExecuteScalar(Data.ConnString, CommandType.Text ,"INSERT INTO [File] ( [FileClassID], SetCommend,SetTop,[Name],[Intro], [FileSize], [Grade], [Keyword], [PreviewUrl], MemberID,FileTypeID,[CreateTime], [UpdateTime],Downloads,Hits,DownRequire,NeedPoint,Status,Actor,[Level],Region) VALUES(@FileClassID,@SetCommend,@SetTop,@Name,@Intro,@FileSize,@Grade,@Keyword,@PreviewUrl,@MemberID,@FileTypeID,getdate(),getdate(),0,0,@DownRequire,@NeedPoint,@Status,@Actor,@Level,@Region);
select @@IDENTITY", oParms);
}
/// <summary>
/// 更新指定的文件信息
/// </summary>
/// <param name="FileID">文件编号</param>
/// <param name="FileTypeID">文件类别编号</param>
/// <param name="FileClassID">文件分类编号</param>
存储过程 字符串转数组/// <param name="SetCommend">推荐方式</param>
/// <param name="SetTop">固顶方式</param>
/// <param name="Name">文件名称</param>
/// <param name="Intro">简介</param>
/// <param name="FileSize">大小</param>
/// <param name="Grade">评级</param>
/// <param name="Keyword">关键字</param>
/
// <param name="PreviewUrl">预览图地址</param>
/// <param name="DownRequire">下载要求</param>
/// <param name="NeedPoint">下载所需点数</param>
/// <param name="Status">状态</param>
public void Update(object FileID,object FileTypeID,object FileClassID,object SetCommend,object SetTop,
object Name,object Intro,object FileSize,object Grade,object Keyword,object PreviewUrl,
object DownRequire,object NeedPoint,object Status,object Actor,object Level,object Region)
{
SqlParameter[] oParms = new SqlParameter[17];
oParms[0]=new SqlParameter("@FileID",FileID);
oParms[1]=new SqlParameter("@FileTypeID",FileTypeID);
oParms[2]=new SqlParameter("@FileClassID",FileClassID);
oParms[3]=new SqlParameter("@SetCommend",SetCommend);
oParms[4]=new SqlParameter("@SetTop",SetTop);
oParms[5]=new SqlParameter("@Name",Name);
oParms[6]=new SqlParameter("@Intro",Intro);
oParms[7]=new SqlParameter("@FileSize",FileSize);
oParms[8]=new SqlParameter("@Grade",Grade);
oParms[9]=new SqlParameter("@Keyword",Keyword);
oParms[10]=new SqlParameter("@PreviewUrl",PreviewUrl);
oParms[11]=new SqlParameter("@DownRequire",DownRequire);
oParms[12]=new SqlParameter("@NeedPoint",NeedPoint);
oParms[13]=new SqlParameter("@Status",Status);
oParms[14]=new SqlParameter("@Actor",Actor);
oParms[15]=new SqlParameter("@Level",Level);
oParms[16]=new SqlParameter("@Region",Region);

SqlHelper.ExecuteNonQuery(Data.ConnString, CommandType.Text," update [File] set File
TypeID=@FileTypeID,FileClassID=@FileClassID,SetCommend=@SetCommend,SetTop=@SetTop,[Name]=@Name,Intro=@Intro,FileSize=@FileSize,Grade=@Grade,Keyword=@Keyword,PreviewUrl=@PreviewUrl,UpdateTime=getdate(),DownRequire=@

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。