DataGridView初始化——添加列、添加行号、连接数据库、单击单元格在文本框中显示

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<pre name="code" class="csharp"> /// <summary>
        /// 单击DataGridView中的单元格，在文本框中显示单击的信息
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if(e.RowIndex>0)
            {
                txtName.Text = dgvManager.CurrentRow.Cells[2].Value.ToString();
                txtDirector.Text = dgvManager.Rows[e.RowIndex].Cells["Movie_Director"].Value.ToString();
                DateTime datetoDay = new DateTime().Date;                                               //new一个时间对象 目的是将电影发行时间的小时,分和秒给去掉 保留到最小单位为日
                datetoDay = Convert.ToDateTime(dgvManager.Rows[e.RowIndex].Cells["Data_Released"].FormattedValue);//将当前行的日期单元格的值 赋给 时间对象datetoDay           
                txtRelease.Text = datetoDay.ToShortDateString();                                         //通过ToShortDateString()方法 将日期后的00:00:00 给剔除掉 并赋给 txtDate文本框
                label5.Text = "ID:" + dgvManager.Rows[e.RowIndex].Cells["ID"].Value.ToString();

            }
        }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<pre name="code" class="csharp">/// <summary> 
/// 为DataGridView添加列 
/// </summary> 
/// <param name="dgv">形参，传入创建的dgv对象</param> 
/// <param name="column">列对象</param> /// <param name="dgvReadonly">dgv只读属性</param> 
/// <param name="dgvName">dgv列名称，最好与数据库相应的名称相同</param> 
/// <param name="dgvDatapropertyname">dgv对应数据库名称</param>
 /// <param name="dgvHeadertext">显示的列名</param> 
public void AddDgvColumns(DataGridView dgv, DataGridViewColumn column, bool dgvReadonly, string dgvName, string dgvDatapropertyname, string dgvHeadertext, int dgvWidth, bool dgvVisible) 
{ 
column.ReadOnly = dgvReadonly; 
column.DataPropertyName = dgvDatapropertyname; 
column.Name = dgvName; 
column.HeaderText = dgvHeadertext; 
column.Width = dgvWidth; 
column.Visible = dgvVisible; 
dgv.Columns.Add(column); 
}

1

1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
  /// <summary>
        /// 初始化DataGridView
        /// </summary>
        /// <param name="dgv"></param>
        public void DgvInitial(DataGridView dgv)
        {
            if (dgv != null && dgv.ColumnCount > 0)
            {
                dgv.Columns.Clear();
            }
            dgv.AllowUserToAddRows = true;
            dgv.AllowUserToDeleteRows = true;
            dgv.AllowUserToResizeColumns = true;
            dgv.AllowUserToOrderColumns = true;

            DataGridViewCheckBoxColumn checkBoxColumn = new DataGridViewCheckBoxColumn();
            checkBoxColumn.Width = 30;//DataGridViewCheckBoxColumn 承载 DataGridViewCheckBoxCell 对象的集合
            dgv.Columns.Add(checkBoxColumn);

            this.AddDgvColumns(dgv, new DataGridViewTextBoxColumn(), true, "ID", "ID", "编号", 60, true);
            this.AddDgvColumns(dgv, new DataGridViewTextBoxColumn(), true, "Movie_Name", "Movie_Name", "电影", 80, true);
            this.AddDgvColumns(dgv, new DataGridViewTextBoxColumn(), true, "Movie_Director", "Movie_Director", "导演", 80, true);
            this.AddDgvColumns(dgv, new DataGridViewTextBoxColumn(), true, "Data_Released", "Data_Released", "发行日期", 80, true);
            this.AddDgvColumns(dgv, new DataGridViewTextBoxColumn(), true, "UserType", "UserType", "用户类型", 80, true);

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
        /// <summary>
        /// 为表格添加行号
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        /// <param name="GVmain"></param>
        public void AddGridView_HangHao(object sender, DataGridViewRowPostPaintEventArgs e, DataGridView GVmain)
        {
            try
            {                //添加行号                
                SolidBrush v_SolidBrush = new SolidBrush(GVmain.RowHeadersDefaultCellStyle.ForeColor);//设置行标题默认样式的前景色
                int v_LineNo = 0;
                v_LineNo = e.RowIndex + 1;
                string v_Line = v_LineNo.ToString();
                e.Graphics.DrawString(
                    v_Line,
                    e.InheritedRowStyle.Font,
                    v_SolidBrush,
                    e.RowBounds.Location.X + 15,
                    e.RowBounds.Location.Y + 5);
            }
            catch (Exception ex)
            {
                MessageBox.Show("添加行号时发生错误，错误信息：" + ex.Message, "操作失败");
            }
        }

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
        /// 连接数据库
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public DataTable dgvDataSource(string sql)
        {
            try
            {
                
                string connstr = "server=.;database=movie;Integrated Security=true;";
                SqlConnection conn = new SqlConnection(connstr);
                conn.Open();
                SqlCommand cmd = new SqlCommand(sql, conn);
                SqlDataAdapter sda = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                sda.Fill(dt);
                int n = cmd.ExecuteNonQuery();
                conn.Close();
                return dt;
            }
            catch (Exception e)
            {
                Console.WriteLine("{0} has errow!", e);
                return null;
            }
        }