您的位置: 首页  >  文章  >  C#编程-81：DataGridView常用操作综合实例

C#编程-81：DataGridView常用操作综合实例

分类: 文章 • 2025-03-15 20:04:03
C#编程-81：DataGridView常用操作综合实例

  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9.  
  10. namespace DataGridViewLastTest
  11. {
  12.     public partial class Form1 : Form
  13.     {
  14.         public Form1()
  15.         {
  16.             InitializeComponent();
  17.         }
  18.          
  19.         DataTable dt;
  20.         int valTotal = 500;//总数量       
  21.         int valPerPage = 9;//每页条数
  22.  
  23.         int pageNum = 0;//总页数
  24.         int currentPage = 1;//当前页
  25.         int valCurrent = 0;//当前条数
  26.         int valStartIndex = 0;//每页起始条数
  27.         int valEndIndex = 0;//当前页终止条数
  28.  
  29.         //生成数据表
  30.         private void GenerageData()
  31.         {
  32.             dt = new DataTable("ClerkSalary");
  33.             dt.Columns.Add("姓名", Type.GetType("System.String"));
  34.             dt.Columns.Add("姓别", Type.GetType("System.String"));
  35.             dt.Columns.Add("工资", Type.GetType("System.Int32"));
  36.             string familyName = "赵钱孙李周吴郑冯陈褚卫蒋沈韩杨朱秦尤许何吕施张";
  37.             string lastName=@"那日丹桂梢头缀黄花绽竹篱抛情引墨顿成诗情也依依爱也依依
  38.                             天涯两相望月人独伤悲红笺小字寄相思情也难追爱也难追
  39.                             聊期花共月闲看绿着珠滴水涌泉歌诗儒词也狂书笔也狂书
  40.                             瑶琴闲置久知音日渐疏往事思来总不如词也成枯笔也成枯";
  41.             string gender = "男女";
  42.             Random random = new Random();
  43.             for (int i = 0; i < valTotal; i++)
  44.             {
  45.                 //新增行方法一：
  46.                 //DataRow dr = dt.NewRow();
  47.                 //dr[0] = familyName[random.Next(0, familyName.Length)].ToString()
  48.                 //    + lastName[random.Next(0, lastName.Length)].ToString()
  49.                 //    + lastName[random.Next(0, lastName.Length)].ToString();
  50.                 //dr[1] = gender[random.Next(0, gender.Length)].ToString();
  51.                 //dr[2] = random.Next(1800, 10000);
  52.                 //dt.Rows.Add(dr);
  53.  
  54.                 //新增行方法二：
  55.                 string name = familyName[random.Next(0, familyName.Length)].ToString()
  56.                     +lastName[random.Next(0, lastName.Length)].ToString() 
  57.                     +lastName[random.Next(0, lastName.Length)].ToString();
  58.                 string Gender=gender[random.Next(0,gender.Length)].ToString();
  59.                 int salary = random.Next(1800,10000);
  60.                 dt.Rows.Add(new object[] { name,Gender,salary});
  61.             }
  62.          
  63.         }
  64.  
  65.         //加载当前页的数据
  66.         private void LoadData()
  67.         {
  68.             DataTable dtTemp = dt.Clone();
  69.             //只有一页
  70.             if (currentPage == pageNum) valEndIndex = valTotal - 1;
  71.             //不止一页
  72.             else valEndIndex = currentPage * valPerPage;
  73.             valStartIndex = valCurrent;
  74.             //更新显示
  75.             txtCurrentPage.Text = currentPage.ToString();
  76.             lblTotalPage.Text = "/" + Convert.ToString(pageNum);
  77.             //从数据表中读取当前数据
  78.             for (int i = valStartIndex; i <= valEndIndex; i++)
  79.             {
  80.                 dtTemp.ImportRow(dt.Rows[i]);
  81.                 valCurrent++;
  82.             }
  83.             //通过bindingSource1作为桥梁绑定数据
  84.             bindingSource1.DataSource = dtTemp;
  85.             bindingNavigator1.BindingSource = bindingSource1;
  86.             dataGridView1.DataSource = bindingSource1;
  87.             //设置不同行显示背景
  88.             dataGridView1.RowsDefaultCellStyle.BackColor = Color.Pink;
  89.             dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.Violet;
  90.         }
  91.    private void Form1_Load(object sender, EventArgs e)
  92.         {
  93.             try
  94.             {
  95.                 GenerageData();
  96.                 pageNum = (valTotal % valPerPage == 0) ? (valTotal / valPerPage) : (valTotal / valPerPage + 1);
  97.                 LoadData();
  98.             }
  99.             catch (Exception ex)
  100.             {
  101.                  
  102.                 throw;
  103.             }
  104.         }
  105.          
  106.         private void dataGridView1_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
  107.         {
  108.             //绘制行号
  109.             Rectangle rect = new Rectangle(e.RowBounds.Location.X,e.RowBounds.Location.Y,dataGridView1.RowHeadersWidth,e.RowBounds.Height);
  110.             TextRenderer.DrawText(e.Graphics,(e.RowIndex+1+valStartIndex).ToString(),dataGridView1.RowHeadersDefaultCellStyle.Font,rect,dataGridView1.RowHeadersDefaultCellStyle.ForeColor,TextFormatFlags.VerticalCenter|TextFormatFlags.Right);
  111.             //选中时显示不同的背景
  112.             if (e.RowIndex >= dataGridView1.Rows.Count - 1) return;
  113.             var row =dataGridView1.Rows[e.RowIndex];
  114.             Color oldForeColor = new Color();
  115.             Color oldBackColor = new Color();
  116.             if (row == dataGridView1.CurrentRow)
  117.             {
  118.                 if (row.DefaultCellStyle.ForeColor != Color.White)
  119.                 {
  120.                     oldForeColor = row.DefaultCellStyle.ForeColor;
  121.                     row.DefaultCellStyle.ForeColor = Color.White;
  122.                 }
  123.                 if (row.DefaultCellStyle.BackColor != Color.Blue)
  124.                 {
  125.                     oldBackColor = row.DefaultCellStyle.BackColor;
  126.                     row.DefaultCellStyle.BackColor = Color.Blue;
  127.                 }
  128.  
  129.             }
  130.             else
  131.             {
  132.                 row.DefaultCellStyle.ForeColor = oldForeColor;
  133.                 row.DefaultCellStyle.BackColor = oldBackColor;
  134.             }
  135.              
  136.         }
  137.  
  138.         private void bindingNavigator1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
  139.         {
  140.             if (e.ClickedItem.Text == "上一页")
  141.             {
  142.                 currentPage--;
  143.                 if (currentPage <= 0)
  144.                 {
  145.                     MessageBox.Show("已经是第一页");
  146.                     currentPage++;
  147.                     return;
  148.                 }
  149.                 else
  150.                 { 
  151.                     valCurrent=valPerPage*(currentPage-1);
  152.                 }
  153.                 LoadData();
  154.             }
  155.             if (e.ClickedItem.Text =="下一页")
  156.             {
  157.                 currentPage++;
  158.                 if (currentPage > pageNum)
  159.                 {
  160.                     currentPage--;
  161.                     MessageBox.Show("已经是最后一页");
  162.                     return;
  163.                 }
  164.                 else
  165.                 {
  166.                     valCurrent = valPerPage * (currentPage - 1);
  167.                 }
  168.                 LoadData();
  169.             }
  170.              
  171.         }
  172.     }
  173. }

相关推荐