brian0031的专栏

DataTable dt_add = new DataTable();DataTable dt_copy = new DataTable();DataSet ds_add = new DataSet();dt_add = (DataTable)dataGrid

方法一:private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e){    e.CellStyle.Back

private void Form1_Load(object sender, EventArgs e){    sysdt2.Columns.Add("factory", System.Type.GetType("System.String"));    sysdt2

dataGridView移除多行(删除多行)以下步骤不是从数据库移除多行, 只是dataGridView移除多行 方法一:int row = dataGridView1.SelectedRows.Count;if (row == 0) {

dataGridView移除多行(删除多行)以下步骤不是从数据库移除多行, 只是dataGridView移除多行 方法一:int row = dataGridView1.SelectedRows.Count;if (row == 0) {

datagridview中输入密码，显示星号*private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e){    if (this.da

datagridview中输入密码，显示星号*private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e){    if (this.da

dataGridView中的复制private void copyToolStripMenuItem_Click(object sender, EventArgs e) //复制{    if (this.dataGridView1.GetCellCount(Data

datagridview添加行，在已经绑定数据源的情况下(否则会报错误: 当控件被数据绑定时，无法以编程方式向 DataGridView 的行集合中添加行)方法一：DataRow dr = ((DataTable)dataGridView1.DataSource).NewRow();((DataTable)dataGridView1.DataSource).Rows.Add(dr)

for (int i = 0; i {     DataRow drow = dt.NewRow();     if (dataGridView1.Rows[i].Cells[0].Value.ToString().Trim().Length == 0)        drow["完成日"] = DBNull.Value;     else        drow["完成日

DataTable不要导入重复项, 在datagridview中设定DataTable dt = new DataTable();dt.PrimaryKey = new DataColumn[] { dt.Columns["产品编号"], dt.Columns["号头"] };//产品编号,号头设置为"联合主键"，不要重复导入信息(重复信息)

DataTable dt = new DataTable();for (int i = dt.Rows.Count; i {    DataRow dr = dt.NewRow();    for (int j = 0; j     {        dr[dataGridView1.Columns[j].Name] = dataGridView1.Rows[i].Cell

private void pasteToolStripMenuItem_Click(object sender, EventArgs e) //粘贴{    if (this.dataGridView1.CurrentCell == null) return;    string paste = Clipboard.GetText();    paste = paste.ToStr

导入excel文件到datagridviewprivate DataSet ImportExcel(string filename, string sheet) //自定义函数{    DataSet ds = new DataSet();    using (OleDbConnection conn = new OleDbConnection("Provider=Microsof

datagridview控件快速清空数据且保留标题列:可以先清空datatable，然后再绑定空数据到datagridviewdt.rows.clear();datagridview.datasourse=dt;

int i = dataGridView1.Rows.Count - 1;dataGridView1.CurrentCell = dataGridView1[0, i]; // 强制将光标指向i行dataGridView1.Rows[i].Selected = true;   //光标显示至i行

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e){    if (dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value == null) //不能省略，如果省略，单元格编辑时按下esc会报错“未将对象引用设置到对象

private void delToolStripMenuItem_Click(object sender, EventArgs e){    if (dataGridView1.CurrentCell == null) return;    Int slt = da

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e){    int x = dataGridView1.CurrentCellAddress.X;

private void pasteToolStripMenuItem_Click(object sender, EventArgs e){    if (dataGridView1.CurrentCell == null) return;    int insrt = data

dataGridView的计算问题(相乘) private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e){    //总数量=每串数量*串数

SqlCommandBuilder 删除与更新的用法,附代码, 与 dataGridView 结合using System.Data.SqlClient;private void toolStripButton2_Click(object sender, EventArgs e) //保存{    if (dataGridView1.Rows.Count == 0) return;        

DataTable dtsve = new DataTable();private void toolStripButton6_Click(object sender, EventArgs e) //保存{    if (dataGridView1.Rows.Count > 0)

DataGridViewCheckBoxColumn dtchk = new DataGridViewCheckBoxColumn();dtchk.DataPropertyName = "chk";dtchk.HeaderText = "";dataGridView1.Colum

private void dataGridView1_KeyDown(object sender, KeyEventArgs e) //按下回车执行tab{    if (this.dataGridView1.Focused && e.KeyCode == Keys.Enter)

public DataGridViewTextBoxEditingControl CellEdit = null;private void dataGridView1_EditingControlShowing(object sender, DataGridV

private void copyToolStripMenuItem_Click(object sender, EventArgs e) //复制{    if (this.dataGridView1.GetCellCount(DataGridViewElementStates.

private void reversed_ToolStripMenuItem_Click(object sender, EventArgs e){    foreach ( DataGridViewRow drw in this.dataGridView1.Rows)    {

private void all_ToolStripMenuItem_Click(object sender, EventArgs e){    this.textBox1.Focus();    for (int i = 0; i     {        this.dataG

datagridview新增行，在有栏位的情况下DataRow dr = ((DataTable)dataGridView1.DataSource).NewRow();((DataTable)dataGridView1.DataSource).Rows.Add(dr); data

private void button2_Click(object sender, EventArgs e) //打开BOM查询{    form2 f2 = new form2(); //第二个表单form2    f2.ShowDialog(this);    dataGri

for (int i = 0; i {    try    {        Convert.ToDecimal(dataGridView1.Rows[i].Cells[3].Value);    }    catch    {        MessageBox.Show("输

private void dataGridView1_KeyDown(object sender, KeyEventArgs e){    if (e.KeyCode == Keys.Delete)    {        int maxrow = 0; //记录

using System.Data.SqlClient;private void toolStripButton2_Click(object sender, EventArgs e) //保存{    string str = string.Empty;

dataGridView1.DataSource = null;(有数据源时)或dataGridView1.Columns.Clear();(无数据源时)

方法一：((DataTable)dataGridView1.DataSource).Rows.Add(strArray);  方法二：dataGridView1.DataSource = null;dataGridView1.Columns.Add("产品编号

http://www.cnblogs.com/fengfeng/archive/2008/03/27/1125225.htmldataGridView的刷新(更新)，Refreshprivate DataTable _dtAdd = new DataTable();private void textBox11_TextChanged(object sender, EventArgs e