boundryclass.cs

教师管理系统,登陆上去后可以在系统中对教师资料等等做管理

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace rsgl.baseClass1
{
    class boundryCLass
    {
        private string tableName;
        public string TableName
        {
            get { return tableName; }
            set { tableName = value; }
        }
        private string serverName;
        public string ServerName
        {
            get { return serverName; }
            set { serverName = value; }
        }
        private string databaseName;
        public string DatabaseName
        {
            get { return databaseName; }
            set { databaseName = value; }
        }
        private adoClass adoclass;
        private SqlConnection conn;
        private DataSet ds;
        public boundryCLass()
        {
            adoclass = new adoClass(serverName, databaseName);
            conn = adoclass.GetConn();
        }
        public boundryCLass(string tablename, string servername, string databasename)
        {
            this.tableName = tablename;
            this.serverName = servername;
            this.databaseName = databasename;
            adoclass = new adoClass(serverName, databaseName);
            conn = adoclass.GetConn();
        }

        public void dataSync(TextBox[] textboxs, DataGridView dgv)
        {
            
            for (int i = 0; i <textboxs.Length; i++)
            {
                textboxs[i].Text =dgv.CurrentRow.Cells[i].Value.ToString();
                
            }
           
        }
        public void DataGridViewBind(DataGridView dgv, Label[] labels)
        {
            ds = new DataSet();
            ds = adoclass.GetDataset("select * from departmentTable", "a");
            dgv.DataSource = ds;
            dgv.DataMember = "a";
            for (int i=0; i<labels.Length; i++)
            {
                dgv.Columns[i].HeaderText = labels[i].Text;
            }
        }

    }
}