绑定DatdGridview数据

  // 绑定DatdGridview数据,显示省份信息
        public void BindDateGridView()
        {
            this.dgvProvinceInfo.AutoGenerateColumns = false;
            this.dgvProvinceInfo.DataSource = wcf.GetProvinceInfo();//已经可以读取所有信息
            if (this.dgvProvinceInfo.Rows.Count > 0)
            {
                this.dgvProvinceInfo.Tag = dgvProvinceInfo.CurrentRow.Cells["ProvinceNo"].Value.ToString();//保存对象;//省份编号
            }
            else 
            {
                MessageBox.Show("没有数据可删除!");
            }
            
            string no = dgvProvinceInfo.CurrentRow.Cells["ProvinceNo"].Value.ToString();
            m_province mp = wcf.GetProvinceByNo(no);
            SetData(mp);//国家赋值
            //this.cmbCountryNo.Text = (dgvProvinceInfo.CurrentRow.Cells["ProvinceNo"].Value.ToString());//国家
            this.txtProvince_ab.Text = dgvProvinceInfo.CurrentRow.Cells["Province_ab"].Value.ToString();//简称
            this.txtnameen.Text = dgvProvinceInfo.CurrentRow.Cells["Name_en"].Value.ToString();//英文名
            this.txtnamecn.Text = dgvProvinceInfo.CurrentRow.Cells["Name_cn"].Value.ToString();//中文
        }
        /// <summary>
        /// 获取所有省份信息,不显示状态为删除信息,国家no显示对应国家表
        /// </summary>
        /// <returns></returns>
        public List<m_province> GetProvinceInfo()
        {
            using (var _DataEntities = new ntasystemEntities())
            {
                var q = from p in _DataEntities.m_province
                        where p.made_dist != "D"
                        orderby p.No descending
                        select p;
                //return _DataEntities.m_province.Where(p=>p.made_dist!="D").OrderByDescending(p => p.No).Take(5).ToList();
                return q.ToList();
            }
        }

 

posted @ 2014-11-09 20:03  清空回声  阅读(294)  评论(0)    收藏  举报