コード例 #1
0
        protected override object GetDataFromDataRow(DataTable dt, int i)
        {
            KeyDistrict tk = new KeyDistrict();

            tk.IdKeyDistrict   = dt.Rows[i].IsNull("MaTuKhoaQuanHuyen") == true ? 0 : (int)dt.Rows[i]["MaTuKhoaQuanHuyen"];
            tk.NameKeyDistrict = dt.Rows[i]["TuKhoaQuanHuyen"].ToString();
            tk.IdDistrict      = dt.Rows[i].IsNull("MaQuanHuyen") == true ? 0 : (int)dt.Rows[i]["MaQuanHuyen"];

            return((object)tk);
        }
コード例 #2
0
        public int getDistrict(String keyword)
        {
            connect();
            string query = "SELECT * FROM TUKHOAQUANHUYEN";

            adapter = new SqlDataAdapter(query, connection);
            DataSet dataset = new DataSet();

            adapter.Fill(dataset);
            ArrayList ls = ConvertDataSetToArrayList(dataset);

            foreach (Object o in ls)
            {
                KeyDistrict key = (KeyDistrict)o;
                keyword = FormatString.FormatSrt(keyword);
                String str = FormatString.FormatSrt(key.NameKeyDistrict);
                if (keyword == str)
                {
                    return(key.IdDistrict);
                }
            }
            disconnect();
            return(-1);
        }