opdatabase.cs

程序学生信息管理系统(SQL2000+ASP.NET+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>
/// Class1 的摘要说明
/// </summary>
/// 
namespace SMS
{
    public class OPDataBase
    {
        public OPDataBase()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
       
       
# region 一:返回对象方法集;
        //返回一个SqlDataReader对象；
        public SqlDataReader getDataReader(string sqlstr)
        {
            //SqlConnection conn = new SqlConnection(getConnection());
            //conn.Open();
            SqlConnection conn = sqlConnection();
            conn.Open();

            SqlCommand cmd = new SqlCommand(sqlstr, conn);
            SqlDataReader dr;
            dr = cmd.ExecuteReader();

            return dr;

        }
        //返回一个连接SqlConnection对象，来创建连接。
        public SqlConnection sqlConnection()
        {

            SqlConnection conn = new SqlConnection(getConnection());

            return conn;



        }
        //返回DataSet对象的方法,需要SQL语句
        public DataSet getDataset(string sql)
        {

            SqlConnection conn = sqlConnection();
            conn.Open();
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet(); ;
            da.Fill(ds);
            return ds;



        }
        //返回连接字符串；
        public string getConnection()
        {
            string conn = ConfigurationSettings.AppSettings["dsn"];
            return conn;


        }
#endregion
#region   二:绑定 GridView 控件的方法集;
        
        //数据梆定到GridView上的方法，需要输入：查询语句str，GridView对象，主键字锻，三个参数。
        public void BinData(string str, GridView gridView, string datakeynames)
        {
            SqlConnection conn = sqlConnection();
            conn.Open();

            SqlDataAdapter da = new SqlDataAdapter(str, conn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            gridView.DataSource = ds;
            gridView.DataKeyNames = new string[] { datakeynames };
            gridView.DataBind();



        }
        //数据梆定到GridView上的方法，需要输入：查询语句str，GridView对象，两个参数。
        public void BinData(string str, GridView gridView)
        {
            SqlConnection conn = sqlConnection();
            conn.Open();

            SqlDataAdapter da = new SqlDataAdapter(str, conn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            gridView.DataSource = ds;
            gridView.DataBind();
        }
        public void BinData(string str, GridView gridView,Label lable)
        {
            SqlConnection conn = sqlConnection();
            conn.Open();

            SqlDataAdapter da = new SqlDataAdapter(str, conn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            try
            {
                gridView.DataSource = ds;
                gridView.DataBind();
            }
            catch (SqlException ex)
            {
                lable.Text = ex.Message.ToString();
            }
            finally
            {
                conn.Close();
                da.Dispose();
            }
        }   
       
       


        //改变时间格式并绑定到 GridView 控件,Cells为数组, 用来填写要改变时间格式的GridView 控件的列号,
        //注意的是, GridView 控件列号是从0开始的!
        public void BinData(string str, GridView gridView, string field, int[] Cells)
        {
            SqlConnection conn = sqlConnection();
            conn.Open();

            SqlDataAdapter da = new SqlDataAdapter(str, conn);
            DataSet ds = new DataSet();
            da.Fill(ds, "Table1");
            gridView.DataSource = ds;
            gridView.DataBind();
       for (int i = 0; i <= gridView.Rows.Count - 1; i++)
            {
                DataRowView drv = ds.Tables["Table1"].DefaultView[i];
      
                DateTime dt = Convert.ToDateTime(drv[field]);
               foreach (int a in Cells)
                {
                  gridView.Rows[i].Cells[a].Text = dt.ToLongDateString();
                  
                }

                
            }
                   
               
                




        }

       
        #endregion
#region  三:执行SqlCommand命令方法集;
        //删除，需要删除的语句。
        public void DeletData(string sql)
        {


            SqlConnection conn = new SqlConnection(getConnection());
            conn.Open();
            SqlCommand cmd = new SqlCommand(sql, conn);
            try
            {
                cmd.ExecuteNonQuery();

            }
            catch { }

        }
       
        //SqlCommand命令，需要SQL语句和 LableID控件显示异常!
        public void BindCommand(string sql, Label lable1)
        {
            SqlConnection conn = new SqlConnection(getConnection());
            conn.Open();
            SqlCommand cmd = new SqlCommand(sql, conn);
            try
            {
                cmd.ExecuteNonQuery();
                lable1.Text = "执行成功!";
            }
            catch (SqlException ex)
            {
                lable1.Text = ex.Message.ToString();
            }
            finally
            {
                cmd.Dispose();
                conn.Close();
            }

        }
        //SqlCommand命令，需要SQL语句
        public void BindCommand(string sql)
        {
            SqlConnection conn = new SqlConnection(getConnection());
            conn.Open();
            SqlCommand cmd = new SqlCommand(sql, conn);
            try
            {
                cmd.ExecuteNonQuery();
            }
            catch
            {

            }
            finally
            {
                cmd.Dispose();
                conn.Close();
            }


        }
# endregion
      
      
    }

}