DataGridView删除行

最新推荐文章于 2024-06-19 17:06:24 发布

weixin_34209406

最新推荐文章于 2024-06-19 17:06:24 发布

阅读量617

点赞数

原文链接：http://www.cnblogs.com/haik/archive/2009/12/01/1614877.html

版权

单元格赋值

DataGridView1.Rows.Add()'首先新增一空行

方法一： DataGridView1.Item("Column1", 1).Value = "adsfsdf" '其中Column1是列名称（列的name属性值）并非列的text值，1代表第1行

方法二：
DataGridView1.Rows(1).Cells(0).Value = "Test” '其中1是第一行，0是第0个单元格，datagridview中起始行号和列号及单完格都从0开始计

删除行

方法一：

DataGridView1.Rows.Remove(DataGridView1.CurrentRow)'删除当前光标所在行
DataGridView1.Rows.Remove(DataGridView1.Rows(DataGridView1.Rows.Count - 1))'删除最后一行
DataGridView1.Rows.Clear()'删除所有行

方法二：

             tnck = "料件进口合同表"
            Dim ds As New DataSet()
            Dim sql As String
            objSqlConnection.Open()
            sql = "delete from " + tnck + " where 序号='" & DataGridView1.CurrentRow.Cells("序号").Value & "'"
            Dim sda As SqlDataAdapter
            sda = New SqlDataAdapter(sql, objSqlConnection)
            ds = New DataSet
            sda.Fill(ds, tnck)
            DataGridView1.DataSource = ds.Tables(tnck)
            objSqlConnection.Close()
            MsgBox("删除完成！")

方法三

        private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
        {
            r = e.RowIndex; //获取当前选择行的行号
            c = dataGridView1.Rows[r].Cells[1].Value.ToString(); //根据当前选择行的行号匹配得到(Cells[0])0列的数据
        }
完整的一个例子

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace led
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnSend_Click(object sender, EventArgs e)
        {
            if (this.serialPort1.IsOpen)
            {
                this.serialPort1.Close();
            }
            this.serialPort1.PortName = this.cbSerial.Text;

this.serialPort1.Open();

            System.Drawing.Bitmap bmp = new Bitmap(this.tbCurrent.Width, this.tbCurrent.Height);
            this.tbCurrent.DrawToBitmap(bmp,new Rectangle(0,0,bmp.Width,bmp.Height));
            Until.SendBmp(this.serialPort1, bmp);
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            FillAllData(0);
        }

        private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
        {
            this.tbContent.Text = this.dgvData["content", e.RowIndex].Value.ToString();
            this.tbCurrent.Text = this.dgvData["content", e.RowIndex].Value.ToString();
            this.tbCurrentSortid.Text = this.dgvData["sortid", e.RowIndex].Value.ToString();
            id = e.RowIndex;
        }
        private int id;

        private void button2_Click(object sender, EventArgs e)
        {
            if (this.tbContent.Text == "")
            {
                MessageBox.Show("输入内容不能为空");
                return;
            }
            int count = Until.GetLineCount(tbContent);
            string[] temp = new string[50];
            for (int i = 0; i < count; i++)
            {
                DB.insertLED(Until.GetLine(tbContent, i));
            }
            FillAllData(this.dgvData.Rows.Count);
            datachange = true;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (this.tbContent.Text == "")
            {
                MessageBox.Show("输入内容不能为空");
                return;
            }
            int count = Until.GetLineCount(tbContent);
            if (count > 1)
            {
                MessageBox.Show("修改只限于1行,不能多于一行");
                return;
            }
            if (DB.updateLEDcontent(tbContent.Text,dgvData["id",id].Value.ToString()) > 0)
            {
                FillAllData(id);
                datachange = true;
            }
        }

        private void FillAllData(int selectid)
        {
            this.dgvData.DataSource = DB.selectLEDcontent();
            this.dgvData.Columns["id"].Visible = false;
            this.dgvData.Columns["content"].HeaderText = "显示内容";
            this.dgvData.Columns["content"].Width = 300;
            this.dgvData.Columns["sortid"].HeaderText = "序号";
            this.dgvData.Columns["inputtime"].HeaderText = "最近修改时间";
            this.dgvData.Columns["inputtime"].Width = 200;

            if (selectid > dgvData.Rows.Count - 1)
            {
                selectid = dgvData.Rows.Count - 1;
            }
            this.dgvData.CurrentCell = this.dgvData.Rows[selectid].Cells["content"];
        }

        private void button4_Click(object sender, EventArgs e)
        {
            DB.updateLEDsortid(dgvData["id", id].Value.ToString(), this.tbCurrentSortid.Text, this.nudNewSortid.Value.ToString());
            FillAllData((int)this.nudNewSortid.Value);
            datachange = true;
        }

        private void button3_Click(object sender, EventArgs e)
        {
            DB.updateLEDsortidlast(dgvData["id", id].Value.ToString(), this.tbCurrentSortid.Text);
            FillAllData(this.dgvData.Rows.Count);
            datachange = true;
        }

        private void button5_Click(object sender, EventArgs e)
        {
            this.timer1.Interval = (int)this.nudTime.Value * 1000;
            LoadData();
            this.timer1.Enabled = true;
        }

        private bool datachange = false;
        private string[] datatemp;
        private int datan = 0;
        private void timer1_Tick(object sender, EventArgs e)
        {
            if (datachange)
            {
                LoadData();
                datan = 0;
                datachange = false;
            }
            try
            {
                this.tbCurrent.Text = datatemp[datan];
            }
            catch
            {
                datan = 0;
                this.tbCurrent.Text = datatemp[datan];
            }
            datan++;
            //SendBySPort(this.textBox1);
        }

        private void LoadData()
        {
            datachange = true;
            datan = 0;
            DataTable dt = DB.selectLEDcontent();
            int i = 0;
            datatemp = new string[dt.Rows.Count];
            foreach (DataRow r in dt.Rows)
            {
                datatemp[i] = r["content"].ToString();
                i++;
            }
        }

        private void SendBySPort(TextBox tb)
        {
            if (this.serialPort1.IsOpen)
            {
                this.serialPort1.Close();
            }
            this.serialPort1.PortName = this.cbSerial.Text;

this.serialPort1.Open();

            System.Drawing.Bitmap bmp = new Bitmap(this.tbCurrent.Width, this.tbCurrent.Height);
            tb.DrawToBitmap(bmp, new Rectangle(0, 0, bmp.Width, bmp.Height));
            Until.SendBmp(this.serialPort1, bmp);
        }

        private void button6_Click(object sender, EventArgs e)
        {
            this.timer1.Enabled = false;
        }

        private void btnDeleteContent_Click(object sender, EventArgs e)
        {
            DB.deleteLED(dgvData["id", id].Value.ToString());
            FillAllData(id);
        }
    }
}

转载于:https://www.cnblogs.com/haik/archive/2009/12/01/1614877.html