comboxaddvalue.cs

进存销系统..适合书店的进销存..功能可以满足一般的需求.很简单

using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;

namespace BookStore.DataAccess
{
    public class ComboxAddValue
    {
        //本类用来把数据库中的ID和Name属性取出
        //Name为ComboBox的Items，ID为value
        public ArrayList items = new ArrayList();
        
        public ComboxAddValue(string table, string name)
        {
            string select = "select " + name + " from " + table;
            DataSet myDT = Narnu.GetDataSetBySqlString(select);
            for (int i = 0; i < myDT.Tables[0].Rows.Count; i++)
            {
                items.Add(myDT.Tables[0].Rows[i][0].ToString());
            }
        }
    }

    public class ComboboxItem
    {
        private int id = 0;
        private string name = null;

        public int ID
        {
            get
            {
                return id;
            }
            set
            {
                id = value;
            }
        }

        public string Name
        {
            get
            {
                return name;
            }
            set
            {
                name = value;
            }
        }
    }
}