给DataGridView添加右键菜单

本人以前用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;
            //添加新增