1、GridColor属性用来获取或设置网格线的颜色
dataGridView1.GridColor=Color.Blue;
2、设置宽度 、高度
dataGridView1.Columns[].Width=;
dataGridView1.Rows[].Height = ;
3、设置字体
dataGridView1.DefaultCellStyle.Font = new Font("隶书",);
dataGridView1.Columns[].DefaultCellStyle.Font = new Font("宋体", );
dataGridView1.Rows[].DefaultCellStyle.Font = new Font("行楷", );4、设置货币在DataGridView控件中的显示
dataGridView1.Columns[].DefaultCellStyle.Format = "c";
5、设置DataGridView单元格的文本对齐方式
dataGridView1.Columns[].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
6、DataGridView控件可编辑的时候验证数据输入
private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{
if (e.ColumnIndex == )
{
int result = ;
string before = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
if(!int.TryParse(e.FormattedValue.ToString(),out result))
{
dataGridView1.Rows[e.RowIndex].ErrorText = "年龄必须为数值类型";
e.Cancel = true;
}
}
}
7、获取DataGridView控件中鼠标单击表格任意单元格的文本
//单击单元格
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
//MessageBox.Show(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString());
} //单击单元格内容
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
MessageBox.Show(dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString());
}
8、在单元格中换行
dataGridView1.DefaultCellStyle.WrapMode=DataGridViewTriState.True;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms; namespace DataGridView
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void btn_GridColor_Click(object sender, EventArgs e)
{
dgv_ShowGridColor.DataSource = new List<Student>()
{
new Student("张三",,),
new Student("李四",,),
new Student("王五",,)
};
//设置表头文本
dgv_ShowGridColor.Columns[].HeaderText = "姓名";
dgv_ShowGridColor.Columns[].HeaderText = "年龄";
//设置列宽度
dgv_ShowGridColor.Columns[].Width = ;
dgv_ShowGridColor.Columns[].Width = ;
//设置网格线颜色
dgv_ShowGridColor.GridColor = Color.Blue;
//设置全局字体
dgv_ShowGridColor.Font = new Font("隶书", );
//设置数据字体
dgv_ShowGridColor.DefaultCellStyle.Font = new Font("楷体", );
//设置数字数据显示
dgv_ShowGridColor.Columns[].DefaultCellStyle.Format = "c";
//设置数据填充样式 dgv的宽度一定要够长
dgv_ShowGridColor.Columns[].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
//设置对齐样式
dgv_ShowGridColor.Columns[].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//全局对齐样式
//dgv_ShowGridColor.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
//换行显示过长文本
dgv_ShowGridColor.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
//设置行高
//dgv_ShowGridColor.Rows[2].Height = 100;
////添加列
//dgv_ShowGridColor.Columns.Add("day", "日期");
//dgv_ShowGridColor.Columns.Remove("day");
//禁止添加行和列
//dgv_ShowGridColor.AllowUserToAddRows = false;
//dgv_ShowGridColor.AllowUserToDeleteRows = false;
//自动排序
//for (int i = 0; i < dgv_ShowGridColor.Columns.Count; i++)
//{
// dgv_ShowGridColor.Columns[i].SortMode = DataGridViewColumnSortMode.Automatic;
//}
//隔行换色
//for (int i = 0; i < dgv_ShowGridColor.Rows.Count; i++)
//{
// if (i % 2 == 0)
// {
// dgv_ShowGridColor.Rows[i].DefaultCellStyle.BackColor = Color.Gray;
// }
//} } private void Form1_Load(object sender, EventArgs e)
{
//SqlConnection myConn = new SqlConnection("server=(local);database=testDB;integrated security=true");
//SqlDataAdapter mysda = new SqlDataAdapter("select * from student", myConn);
//DataSet ds = new DataSet();
//mysda.Fill(ds);
//dgv_ShowGridColor.DataSource = ds.Tables[0];
////dgvData.RowHeadersVisible = false;
////btnAdd.Enabled = false;
//dgv_ShowGridColor.Columns[0].ReadOnly = true;
} private void button1_Click(object sender, EventArgs e)
{
dgv_ShowGridColor.DataSource = new List<Images>()
{
new Images(){_Im=Image.FromFile(System.Environment.CurrentDirectory+"\\Image\\1.bmp")},
new Images(){_Im=Image.FromFile(System.Environment.CurrentDirectory+"\\Image\\2.bmp")},
new Images(){_Im=Image.FromFile(System.Environment.CurrentDirectory+"\\Image\\3.bmp")},
new Images(){_Im=Image.FromFile(System.Environment.CurrentDirectory+"\\Image\\4.bmp")},
new Images(){_Im=Image.FromFile(System.Environment.CurrentDirectory+"\\Image\\5.bmp")},
new Images(){_Im=Image.FromFile(System.Environment.CurrentDirectory+"\\Image\\6.bmp")},
new Images(){_Im=Image.FromFile(System.Environment.CurrentDirectory+"\\Image\\7.bmp")}
};
dgv_ShowGridColor.Columns[].HeaderText = "图片";
dgv_ShowGridColor.Columns[].Width = ;
for (int i = ; i < dgv_ShowGridColor.Rows.Count; i++)
{
dgv_ShowGridColor.Rows[i].Height = ;
}
}
}
class Student
{
private string name;
private int age;
private int money;
public string _Name
{
get;
set;
}
public int _Age
{
get;
set;
}
public int _Money
{
get;
set;
}
public Student(string name, int age,int money)
{
this._Name = name;
this._Age = age;
this._Money = money;
}
}
class Images
{
private Image im;
public Image _Im
{
get;
set;
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms; namespace DataGridView中添加合计和平均值
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
List<Fruit> fruit;
private void button1_Click(object sender, EventArgs e)
{
fruit = new List<Fruit>()
{
new Fruit(){Name="ada",Price=},
new Fruit(){Name="adfa",Price=},
new Fruit(){Name="fddd",Price=}
};
dataGridView1.Columns.Add("Fruit", "水果");
dataGridView1.Columns.Add("Price", "价格");
//dataGridView1.DataSource = fruit;
foreach (Fruit f in fruit)
{
dataGridView1.Rows.Add(new string[]
{
f.Name,
f.Price.ToString()
});
}
float sum = ;
fruit.ForEach(
(pp) =>
{
sum += pp.Price;
}
);
dataGridView1.Rows.Add(new string[]{
"合计："+sum.ToString(),"均价："+(sum/fruit.Count).ToString()
});
}
}
class Fruit
{
private string name;
private int price;
public string Name
{
get;
set;
}
public int Price
{
get;
set;
}
}
}
eg
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data; namespace _19事务01
{
class SqlHelper
{
public static bool ExecDataBySqls(List<string> strSqls, string strConn)
{
SqlConnection sqlConn = new SqlConnection(strConn);
bool boolIsSucceed = false;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = sqlConn;
if (sqlConn.State == ConnectionState.Closed)
{
sqlConn.Open();
}
SqlTransaction sqlTran = sqlConn.BeginTransaction();//启动一个事务
try
{
sqlCmd.Transaction = sqlTran;//为事务创建一个命令
foreach (string item in strSqls)
{
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = item;
sqlCmd.ExecuteNonQuery();
}
sqlTran.Commit();//提交事务
boolIsSucceed = true;
}
catch
{
sqlTran.Rollback();//回滚事务，恢复数据
boolIsSucceed = false;
}
finally
{
sqlConn.Close();
strSqls.Clear();
}
return boolIsSucceed;
}
public static DataSet DataBanding(string connStr,string selectCmdText)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataAdapter sda = new SqlDataAdapter(selectCmdText, conn);
DataSet ds = new DataSet();
sda.Fill(ds, "Student");
return ds;
}
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient; namespace _19事务01
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
string connStr = "Server=(local);DataBase=testDB;Integrated Security=true";
string selectCmdText = "select * from Student";
private void Form1_Load(object sender, EventArgs e)
{ dataGridView1.DataSource = SqlHelper.DataBanding(connStr, selectCmdText).Tables[];
} private void button1_Click(object sender, EventArgs e)
{
List<string> strSqls = new List<string>();
string strDelete =string.Format("delete from student where stuNumber='{0}'",txtDStuNumber.Text);
string strInsert = string.Format("insert into student values('{0}','{1}',{2})", txtStuNumber.Text, txtStuName.Text, txtStuAge.Text);
string strSelect = "select * from student where stuNumber='2010181055'";
strSqls.Add(strDelete);
strSqls.Add(strInsert);
strSqls.Add(strSelect);
if (SqlHelper.ExecDataBySqls(strSqls, connStr))
{
MessageBox.Show("事务执行成功");
}
//dataGridView1.DataSource = SqlHelper.DataBanding(connStr, selectCmdText).Tables[0];
Form1_Load(sender,e);
MessageBox.Show("加载成功");
}
}
}
using(SqlConnection myConn=new SqlConnection(connectionText))
{
if(myConn.State==ConnectionState.Closed)
{
myConn.Open();
}
//将数据显示到DataGridView中
string selectCommandText = "select * from student";
SqlDataAdapter mySDA = new SqlDataAdapter(selectCommandText,myConn);
DataSet myDS = new DataSet();
mySDA.Fill(myDS,"student");
dgvShow.DataSource=myDS.Tables[0];
//DataTable myDT = new DataTable();
//for (int i = 0; i < dgvShow.Rows.Count;i++ )
//{
//}
}