Example #1
0
        protected override object GetDataFromDataRow(DataTable dt, int i)
        {
            KeyWard tkp = new KeyWard();

            tkp.IdKeyWard   = (int)dt.Rows[i]["MaTuKhoaPhuong"];
            tkp.NameKeyWard = dt.Rows[i]["TuKhoaPhuong"].ToString();
            tkp.IdWard      = (int)dt.Rows[i]["MaPhuong"];
            return((object)tkp);
        }
Example #2
0
        public int getWard(String keyword)
        {
            connect();
            string query = "SELECT * FROM TUKHOAPHUONG";

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

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

            foreach (Object o in ls)
            {
                KeyWard key = (KeyWard)o;
                keyword = FormatString.FormatSrt(keyword);
                String str = FormatString.FormatSrt(key.NameKeyWard);
                if (str == keyword)
                {
                    return(key.IdWard);
                }
            }
            disconnect();
            return(-1);
        }