dbhelper.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;
using System.Data.SqlClient;

/// <summary>
/// DBHelper 的摘要说明
/// </summary>
public class DBHelper
{
    //使用sa登陆方式
    //private static string strCon = "server=.;database=SelectCourseTC;uid=sa;pwd=sa.;";

    //使用windows验证登陆方式
    private static string strCon = @"Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SelectCourseTC;Data Source=59C5BFFE376B407\SQLEXPRESS;";

    public static UserInfo sqllogin(string strSql)
    {
        SqlConnection con = new SqlConnection();
        con.ConnectionString = strCon;

        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = strSql;

        con.Open();
        SqlDataReader dr = cmd.ExecuteReader();

        UserInfo userinfo = null;

        if (dr.Read())
        {
            userinfo = new UserInfo();
            userinfo.UserID = dr.GetInt32(0);
            userinfo.UserLoginID = dr.GetString(1);
            userinfo.UserPwd = dr.GetString(2);
            userinfo.UserName = dr.GetString(3);
            userinfo.UserStauts = dr.GetInt32(4);
            userinfo.ScID = dr.GetInt32(5);
        }

        dr.Close();

        con.Close();

        return userinfo;
    }

    public static scInfo sqlsclogin(string strSql)
    {
        SqlConnection con = new SqlConnection();
        con.ConnectionString = strCon;

        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = strSql;

        con.Open();
        SqlDataReader dr = cmd.ExecuteReader();

        scInfo scinfo = null;

        if (dr.Read())
        {
            scinfo = new scInfo();
            scinfo.ScID = dr.GetInt32(0);
            scinfo.ScName = dr.GetString(1);
            scinfo.ScContent = dr.GetString(2);
            scinfo.ScNum = dr.GetInt32(3);
            scinfo.ScMax = dr.GetInt32(4);
            scinfo.ScTeacher = dr.GetString(5);
        }

        dr.Close();

        con.Close();

        return scinfo;
    }

    public static int sqlinit(string strSql)
    {
        SqlConnection con = new SqlConnection();
        con.ConnectionString = strCon;

        SqlCommand cmd = con.CreateCommand();
        cmd.CommandText = strSql;

        con.Open();

        int i = cmd.ExecuteNonQuery();

        con.Close();

        return i;

    }

    public static DataTable sqlLoad(string strSql)
    {
        SqlDataAdapter da = new SqlDataAdapter(strSql, strCon);
        DataTable dt = new DataTable();

        da.Fill(dt);

        return dt;

    }
}