sqldb.cs

visual studio 2005开发环境下采用C#语言开发的简单留言本源码

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>
/// SqlDB 的摘要说明
/// </summary>
public class SqlDB
{
	public SqlDB()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public const string constr = "data source=;uid=sj;pwd=;database=aspnet";

    //获取数据集
    public static DataSet getdataset(string sql)
    {
        SqlConnection con = new SqlConnection(constr);
        con.Open();
        SqlCommand cmd=new SqlCommand(sql);
        SqlDataAdapter sda=new SqlDataAdapter(sql,con);
        DataSet ds=new DataSet();
        sda.Fill(ds);
        con.Close();
        return ds;
    }

    //执行SQL语句，返回所影响的行数
    public static int runsql(string sql)
    {
        SqlConnection con = new SqlConnection(constr);
        con.Open();
        SqlCommand cmd=new SqlCommand(sql,con);
        int result=cmd.ExecuteNonQuery();
        con.Close();
        return result;
    }

    /// <summary>
    /// 判断是否是数字
    /// </summary>
    /// <param name="str">字符串</param>
    /// <returns></returns>
    public static bool IsNumeric(string str)
    {
        if (str == null || str.Length == 0)
            return false;
        System.Text.ASCIIEncoding ascii = new System.Text.ASCIIEncoding();
        byte[] bytestr = ascii.GetBytes(str);
        foreach (byte c in bytestr)
        {
            if (c < 48 || c > 57)
            {
                return false;
            }
        }
        return true;
    }
}