Exemple #1
0
        public void CityInfo(ComboBox cobox, string SQLstr, int n)
        {
            cobox.Items.Clear();
            DataClass.MyMeans MyDataClass = new EMS.DataClass.MyMeans();
            SqlDataReader     MyDR        = MyDataClass.getCmd(SQLstr);

            if (MyDR.HasRows)
            {
                while (MyDR.Read())
                {
                    if (MyDR[n].ToString() != "" && MyDR[n].ToString() != null)
                    {
                        cobox.Items.Add(MyDR[n].ToString());
                    }
                }
            }
        }
Exemple #2
0
        public void CoPassData(ComboBox cobox, string TableName)
        {
            cobox.Items.Clear();
            DataClass.MyMeans MyDataClass = new EMS.DataClass.MyMeans();
            SqlDataReader     MyDR        = MyDataClass.getCmd("select * from " + TableName);

            if (MyDR.HasRows)
            {
                while (MyDR.Read())
                {
                    if (MyDR[1].ToString() != "" && MyDR[1].ToString() != null)
                    {
                        cobox.Items.Add(MyDR[1].ToString());
                    }
                }
            }
        }