datagridview重叠_datagridview绑定list_datagridview右键菜单(3)

}

3. //修改数据,并将数据提交到

private Boolean dbUpdate()

{

string strSql = "select ProductsSpecID,ProductsSpec,ProductsSpecUnit,ProductsID from tbl_product_detail_master";

System.Data.DataTable dtUpdate = new System.Data.DataTable();

dtUpdate = this.dbconn(strSql);

dtUpdate.Rows.Clear();

System.Data.DataTable dtShow = new System.Data.DataTable();

//dtShow = (DataTable)this.bindSource.DataSource;

dtShow = (System.Data.DataTable)this.dgselect.DataSource;

int p1 = dtShow.Rows.Count;

// try

// {

for (int i = 0; i < dtShow.Rows.Count; i)

{

DataRowState rowState=new DataRowState();

rowState=dtShow.Rows[i].RowState;

if (rowState==DataRowState.Added || rowState==DataRowState.Detached || rowState==DataRowState.Modified)

{

if (this.dgselect["Del", i].Value.ToString() == "1")

{

dtShow.Rows[i].Delete();

}

}

}

for (int i = 0; i < dtShow.Rows.Count; i)

{

dtUpdate.ImportRow(dtShow.Rows[i]);

}

int num = dtUpdate.Rows.Count;

try

{

this.conn.Open();

trans = this.conn.BeginTransaction();

MySqlCommandBuilder CommandBuiler;

CommandBuiler = new MySqlCommandBuilder(this.adapter);

this.adapter.Update(dtUpdate);

trans.Commit();

this.conn.Close();

}

catch ( Exception ex)

{

MessageBox.Show(ex.Message.ToString());

trans.Rollback();

return false;

}

dtUpdate.AcceptChanges();

return true;

}

----------------

一、单元内容的操作

// 取得当前单元内容

Console.WriteLine(DataGridView1.CurrentCell.Value);

// 取得当前单元的列 Index

Console.WriteLine(DataGridView1.CurrentCell.ColumnIndex);

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/tongxinshuyu/article-50070-3.html