brian0031的专栏

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

const string conn = @"user=sa;pwd=AbzQ75691;database=erp;server=192.168.2.20";foreach (DataGridViewRow gvr in dataGridView1.Rows){    var con = new SqlConnection(conn);    var adapter = new Sq

在wincmd.ini中设置为0， 不用Windows 方式删除[Configuration]VistaDelete=0

太多的rundll32: 打开"控制面板-任务计划",将里面的计划全部删除, 然后中止rundll32.exe 进程即可.

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

dataGridView1.AllowUserToAddRows = true; int k = dataGridView1.Rows.Count;if (k > 1){    if (dt.Rows[k - 1]["产品编号"].ToString().Tri

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

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

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

SQL中删除重复的行(重复数据)，只保留一行方法一：使用在T-SQL的编程中分配一个列号码,以COL1,COL2组合来分区排序，删除DATABASE重复的行(重复数据)，只保留一行// COL1,COL2是数据库DATABASE的栏位delete a from (select COL1,COL2,row_number() over (partition by COL1,COL2