给DataGridView添加右键菜单

最新推荐文章于 2023-08-09 14:59:02 发布

tdtxflsh

最新推荐文章于 2023-08-09 14:59:02 发布

阅读量7.5k

点赞数 2

CC 4.0 BY-SA版权

分类专栏： C＃学习笔记文章标签： object exception null security insert button

本文链接：https://blog.youkuaiyun.com/tdtxflsh/article/details/6248211

本人以前用PB做过一些开发，挺喜欢DATAWINDOW的。在学习C＃时发现给DataGirdView加上右键菜单的效果和PB中的DATAWINDOW有相同的效果。其中数据库的操作应用的SQLDataAdatper，下面源码奉上，欢迎朋友们提出指正和意见。

首先，先建立一个Form窗口取名为DataGridViewDemo 从工具箱中选择控件，并设置属性如下

DataGridView name属性 dataGridView

TextBox name属性 txtContent

Button name属性 btSave Text 属性保存

Button name 属性 btExit Text属性退出

DataGridViewDemo 类代码如下

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 C15Demo
{
    public partial class DataGridViewDemo : Form
    {
        //全局变量
        private SqlDataAdapter adapter = null;
        private DataTable dt = null;
        public DataGridViewDemo()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 初始化SQLDataAdapter类添加对数据表的增删改操作
        /// </summary>
        private void InitAdapter()
        {
            SqlConnection connection = new SqlConnection();
            connection.ConnectionString = "Persist Security Info=false;Integrated Security=SSPI;Initial Catalog=Northwind;server=(local)";
            adapter = new SqlDataAdapter("select ProductID,ProductName,UnitPrice,Discontinued from Products", connection);
            adapter.FillLoadOption = LoadOption.OverwriteChanges;
            //添加修改命令
            SqlCommand UpdataCommand = new SqlCommand();
            UpdataCommand.Connection = connection;
            UpdataCommand.CommandText = "Update Products set ProductName = @ProductName,UnitPrice=@UnitPrice,Discontinued = @Discontinued where ProductID=@Productid ";
            UpdataCommand.Parameters.Add("@ProductID", SqlDbType.Int, 4, "ProductID");
            UpdataCommand.Parameters.Add("@ProductName", SqlDbType.VarChar, 50, "ProductName");
            UpdataCommand.Parameters.Add("@UnitPrice", SqlDbType.Money, 20, "UnitPrice");
            UpdataCommand.Parameters.Add("@Discontinued", SqlDbType.Bit, 1, "Discontinued");
            adapter.UpdateCommand = UpdataCommand;
            //添加新增
            SqlCommand InsertCommand = new SqlCommand();
            InsertCommand.Connection = connection;
            InsertCommand.CommandText = "Insert into Products (ProductName,UnitPrice,Discontinued)values(@ProductName,@UnitPrice,@Discontinued) ";
            InsertCommand.Parameters.Add("@ProductName", SqlDbType.VarChar, 50, "ProductName");
            InsertCommand.Parameters.Add("@UnitPrice", SqlDbType.Money, 20, "UnitPrice");
            InsertCommand.Parameters.Add("@Discontinued", SqlDbType.Bit, 1, "Discontinued");
            adapter.InsertCommand = InsertCommand;
            //添加删除
          &