数据库操作asp.net 不指定

admin , 2007/09/28 09:33 , 代码片段,演示也有 , 评论(0) , 阅读(1425) , Via 本站原创 | |
按书上码下来的例子!
引用
#region预处理器指令使在使用Visual Studio 代码编辑器的大纲显示功能时指定可展开或折叠的代码 块.这个功能非常实用,尤其在编辑复杂的类时,可以使用代码结构更加清晰,在查询代码时可以快速地找到需要的代码行,初学者一定要学会运用这种预处理器指令的方法,养成浪好的编程习惯.

BaseClass.cs
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;

/// <summary>
/// BaseClass 的摘要说明
/// </summary>
public class BaseClass
{
  public BaseClass()
  {
    //
    // TODO: 在此处添加构造函数逻辑
    //
    }

    #region 显示客户端对话框
    ///<summary>
    ///说明:MessageBox用来在客户端弹出对话框.
    ///参数:TxtMessage对话框中显示的内容
    ///</summary>
    public string MessageBox(string TxtMessage)
    {
        string str;
        str = "<script language=javascript>alert('" + TxtMessage + "')</script>";
        return str;
    }
    #endregion


    #region 执行sql语句
    /// <summary>
    /// 说明:ExecSQL用来执行SQL语句
    /// 返回值:操作是否成功(True\False).
    /// 参数:sQueryString SQL字符串
    /// </summary>

    public Boolean ExecSQL(string sQueryString)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
        con.Open();
        SqlCommand dbcommand = new Sqlcommand(sQueryString, con);
        try
        {
            dbCommand.Execute.ExecuteNonQuery();
            con.Close();
        }
        catch (System.Exception e)
        {
            con.Close();
            return false;
        }
        return true;
    }
    #endregion;


    #region
    /// <summary>
    /// 说明:GetDataSet 数据集,返回数据源的数据集
    /// 返回值:数据集Data s at
    /// 参数:sQueryString SQL 字符串,TableName 数据表名称
    /// </summary>

    public System.Data.DataSet GetDataSet(string sQueryString,string TableName)
    {
        Sqlconnetion con = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
        con.Open();
        SqlDataAdapter dbAdapter = new SqlDataAdapter(sQueryString,con);
        DataSet dataset = new DataSet();
        dpaDaper.Fill(dataset,TableName);
        con.Close();
        return dataset;
    }
    #endregion
}
  


randomCode.cs

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;

/// <summary>
/// randomCode 的摘要说明
/// </summary>
public class randomCode
{
  public randomCode()
  {
    //
    // TODO: 在此处添加构造函数逻辑
    //
  }

    public string RandomNum(int n)//
    {
        string strchar = "0,1,2,3,4,5,6,7,8,9,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z";
        string[] VcArray = strchar.Split(',');
        string VNum = "";
        int temp = -1;

        Random rand = new Ranom();
        for(int i=1;i<n;i++)
        {
            if (temp!=-1)
            {
                rand =new Random(i*temp*unchecked((int)DataTime.Now.Ticks));

            }
            int t=rand.Next(61);
            if (temp !=-1 && temp == t)
            {
                return RandomNum(n);
            }
            temp=t;
            VNum+=VcArray[t];
        }
        return VNum;//返回生成的随机数
    }

}
发表评论

昵称

网址

电邮

打开HTML 打开UBB 打开表情 隐藏 记住我 [登入] [注册]