使用SunnyUI的datagridview常用代码(个人常用)

2023-01-08,,

1、窗体加载时初始化grid

private void LayOut() {

dgv.Font = new System.Drawing.Font("微软雅黑", 9F);
dgv.AutoGenerateColumns = false;
dgv.AllowUserToAddRows = false;
dgv.AllowUserToResizeColumns = true;
dgv.AllowUserToOrderColumns = true;

DataGridViewCheckBoxColumn checkBoxColumn = new DataGridViewCheckBoxColumn();
checkBoxColumn.Width = 40;
checkBoxColumn.Name = "Check";
checkBoxColumn.HeaderText = "全选";
dgv.Columns.Add(checkBoxColumn);

CommonUtil.AddDgvColumns2(dgv, "id", "ID", 110);
CommonUtil.AddDgvColumns2(dgv, "name", "名称", 0, false);
CommonUtil.AddDgvColumns(dgv, "Img", "照片", 90);

}

2、添加公共类

//公共类
public class CommonUtil{
public static void AddDgvColumns(DataGridView dgv, string dgvName, string dgvHeadertext, int dgvWidth = 50, bool dgvVisible = true, bool dgvReadonly = true, bool _Frozen = false)
{
  if (dgvName == "Img")
  {
    DataGridViewImageColumn column = new DataGridViewImageColumn();
    column.ImageLayout = DataGridViewImageCellLayout.Zoom;
    column.Name = dgvName;
    column.DataPropertyName = dgvName;
    column.HeaderText = dgvHeadertext;
    column.Width = dgvWidth;
    column.Visible = dgvVisible;
    column.Frozen = _Frozen;//是否冻结
    dgv.Columns.Add(column);
 }
else
{
     dgvWidth = dgvWidth < 2 ? 2 : dgvWidth;
    DataGridViewColumn column = new DataGridViewTextBoxColumn();
    column.Frozen = _Frozen;//是否冻结
    column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
    column.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
    column.ReadOnly = dgvReadonly;
    column.Name = dgvName;
    column.DataPropertyName = dgvName;
    column.HeaderText = dgvHeadertext;
    column.Width = dgvWidth;
    column.Visible = dgvVisible;
    column.MinimumWidth = dgvWidth;
//column.SortMode = DataGridViewColumnSortMode.NotSortable;
    dgv.Columns.Add(column);
  }
} public static void AddDgvColumns2(DataGridView dgv, string dgvName, string dgvHeadertext, int dgvWidth = 50, bool dgvVisible = true, bool dgvReadonly = true, bool _Frozen = false)
{
dgvWidth = dgvWidth < 2 ? 2 : dgvWidth;
DataGridViewColumn column = new DataGridViewTextBoxColumn();
column.Frozen = _Frozen;//是否冻结
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; column.ReadOnly = dgvReadonly;
column.Name = dgvName;
column.DataPropertyName = dgvName;
column.HeaderText = dgvHeadertext;
column.Width = dgvWidth;
column.Visible = dgvVisible;
column.MinimumWidth = dgvWidth;
if (!dgvReadonly)
{
column.HeaderText = dgvHeadertext + "*";
}
//column.SortMode = DataGridViewColumnSortMode.NotSortable;
dgv.Columns.Add(column);
}
}

3、数据绑定

private void LoadList(){
  string sql="select * from user";
  DataSet ds=new DataSet();
  SqlHelper.ExecuteDataSet(ref ds, sql);
  DataTable dt2 = ds.Tables[1];
dt.Columns.Add("Img", typeof(Image));
dgv.Columns["Img"].DefaultCellStyle.NullValue = null;
dgv.DataSource = dt2;
for (int i = 0; i < dgv.RowCount; i++)
{
string imgpath = dgv.Rows[i].Cells["imgUrl"].Value.ToString();
dgv.Rows[i].Cells["Img"].Value = CommonUtil.GetFtpImage(imgpath);//获取照片对象
}
}

分页使用别的方式

使用SunnyUI的datagridview常用代码(个人常用)的相关教程结束。