dataGridView常用的数据绑定

  由于本人刚大学毕业，对asp.net刚入门，对技术也不太精通，容易忘记，所以记录下来了，很常用呀！

 

        /// <summary>
        /// 加载Grid
        /// </summary>
        /// <param name="dt_List">表对象</param>
        private void binderGird(DataTable dt_List)
        {
            // 清空 dgvOfficeRebate 中的列
            this.dataGridView1.Columns.Clear();

            // 清空 dgvOfficeRebate 中的行
            this.dataGridView1.Rows.Clear();

            // 设置 dgvOfficeRebate 中的列
            this.dataGridView1.Columns.Add("ssKey", "设置的Key值");
            this.dataGridView1.Columns.Add("ssValues", "对应的Value值");
            this.dataGridView1.Columns.Add("ssText", "说明");
            this.dataGridView1.Columns.Add("Text", "操作");
            this.dataGridView1.Columns.Add("ssOperateId", "当前权限使用人");
            this.dataGridView1.Columns.Add("permission", "分配权限 ");
            DataGridViewRow row = null;

            // 遍历返利信息集合
            for (int j = 0; j < dt_List.Rows.Count; j++)
            {
                row = new DataGridViewRow();

                // 设置行内容对齐方式(水平垂直剧中)
                row.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;

                // 加载数据载体控件
                for (int i = 0; i < this.dataGridView1.Columns.Count; i++)
                {
                    if (i != 3 && i != 5)
                    {
                        row.Cells.Add(new DataGridViewTextBoxCell());
                    }
                    else
                    {
                        row.Cells.Add(new DataGridViewButtonCell()); //加载为按钮形式
                    }
                }

                // 填充行内容
                row.SetValues(dt_List.Rows[j]["ssKey"].ToString().Trim(), dt_List.Rows[j]["ssValues"].ToString().Trim()
                    , dt_List.Rows[j]["ssText"].ToString().Trim(), "修 改", dt_List.Rows[j]["ssOperateId"].ToString().Trim(), "分配权限");

                // dgvOfficeRebate 加载行
                this.dataGridView1.Rows.Add(row);
            }
            dataGridView1.Columns[2].Width = 400;
        }

       

               //点击事件
        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                if (e.ColumnIndex == 3)
                {

                    //调用修改窗体

                     addSystemSetting objaddSystemSetting = new addSystemSetting(_objservices, UserInfo);
                    objaddSystemSetting.F = 1;
                    objaddSystemSetting.objSystemSetting = this;
                    objaddSystemSetting.objdr = dataGridView1.SelectedRows[0];
                    objaddSystemSetting.ShowDialog();

                }
                else if (e.ColumnIndex == 5)
                {
                    if (UserInfo.uParentId == 0 && UserInfo.uId == 10)
                    {

                        //调用分配权限窗体
                        PermissionAllot pa = new PermissionAllot();
                        pa.UserInfo = this.UserInfo;
                        pa._objservices = this._objservices;
                        pa.objSystemSetting = this;
                        pa.objdr = dataGridView1.SelectedRows[0];
                       pa.ShowDialog();
                    }
                     else
                    {
                       MessageBoxForm fo = new MessageBoxForm("对不起，您没有该权限。如果您需要该权限请与  总管理员联系！", "操作提示：", MessageBoxIcon.Exclamation);
                      fo.ShowDialog();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

   //模糊查询
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                binderGird(_objservices.GetListBystrwhere(textBox1.Text.Trim()));
            }
            catch { }
        }