UpLoadTools.csusing System;using System.Collections.Generic;using System.Web;using System.Web.UI;using System.IO;using System.Threading;namespace cofcms{ public class UpLoadTools { public static string[] UpLoadImage(string ServerPath) { //获取所有的上传控件 var files... Read More
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;/// <summary>/// SqlCheck 的摘要说明/// < Read More
using System;using System.Collections.Generic;using System.Web;using System.Text;using System.Text.RegularExpressions;namespace cofcms{ public class PagingCollection<T> { private int pagezise; public int Pagezise { get { return pagezise; } set { pagez... Read More
using System;using System.Data;using System.Configuration;using System.Collections;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.Drawing;public partial class CheckC Read More
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go -- =============================================
-- Author: <shipeng.wang>
-- Create date: <2009-09-11>
-- Description: <根据表名创建实体类的字段和属性>
-- =============================================
ALTER proc [dbo].[p_Wsp]
@tablename varchar(50)
a Read More
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go -- =============================================
-- Author: <shipeng.wang>
-- Create date: <2009-09-14>
-- Description: <根据数据库名创建实体类>
-- =============================================
create proc [dbo].[p_db_wsp]
@dbname varchar(50), --数 Read More
/*declare @n intexec sp_fenye 'select * from baseinfo','id desc','id',3,2,@count=@n outputselect @n*/-- =============================================-- Author: shipeng.wang-- Create date: 2010-04-27-- Description: 分页存储过程(对结果集进行分页)-- =========================================== Read More
访问外部数据时，opendatasource的使用范例：注意：sql2000默认是启用opendatasource功能的。但sql2005是默认不启用的。如果在sql2005中要使用opendatasource，则需要先开启。 开启方式： 方式一（手工修改sql配置）：在sql2005的配置工具-》sql server外围应用配置器-》即席远程查询-》勾选"启用OpenRowset和OpenDatasource支持"选项。 方式二（通过sql语句修改配置）： -- 允许配置高级选项 EXEC sp_configure 'show advanced options&# Read More
方法一。利用.NET自带的邮件类来实现 smtp 邮件传输协议 CDO 协助数据对象 切忌 用QQ做服务器 不行方法:引用System.Web.Mail命名空间,然后在发送时执行如下代码: MailMessage email = new MailMessage(); email.From = "发件人的Email地址"; email.To = "收件人的Email地址"; email.Subject = "找回密码"; //邮件的主题 email.Body = "您的密码是:dkdkdk"; //邮件的正文内容 M Read More
常用的数据库链接串 <!-- Access 2007: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/myFolder/myAccess2007file.accdb;Persist Security Info=False; Access 2000: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/mydatabase.mdb;User Id=admin;Password=; --> <add name="Access" connectionString... Read More