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()); } } } }
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()); } } } }