utility.cs

c#数据库访问自动生成代码程序

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Windows.Forms;
using System.Collections;
namespace MVC.Common
{
    class Utility
    {
        public static void  BindComboBox(DataSet ds, ComboBox cbb, string sDisplayMember, string sValueMember)
        {
            cbb.DataSource = ds.Tables[0].DefaultView;
            cbb.DisplayMember = sDisplayMember;
            cbb.ValueMember = sValueMember; 
        }


        public static void BindDataView(DataSet ds, DataGridView dgv,int iColCnt)
        {

            InitDataView(dgv, "PFName");           
            dgv.DataSource = ds.Tables[0].DefaultView;
            for (int i = iColCnt; i < ds.Tables[0].Columns.Count; i++)
            {
                dgv.Columns[i].Visible = false;
            }
                        
        }


        public static void InitDataView(DataGridView dgv, string dgvName)
        {
            ArrayList al = XmlControl.LoadDataGridViewInfo(dgvName);
            
            dgv.Columns.Clear();            

            for (int i = 0; i < al.Count; i++)
            {
                DataGridViewTextBoxColumn dc = new DataGridViewTextBoxColumn();
                dgv.Columns.Add(dc);                
                TableStruct ts = (TableStruct)al[i];

                dgv.Columns[i].DataPropertyName =ts.DataPropertyName;
                dgv.Columns[i].HeaderText = ts.HeaderText;
                dgv.Columns[i].SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
                dgv.Columns[i].Width = ts.Width;
            }

        }
    }




}