vs应用. net.frm窗体怎么显示数据库表后在表中插入按钮

Question

 

Answer 1

帮助到你能点个采纳吗，谢谢~

 

using System;
using System.Data;
using System.Windows.Forms;
namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            ////
            DataTable data = new DataTable();
            data.Columns.Add("编号");
            data.Columns.Add("楼栋");
            data.Columns.Add("房间号");
            data.Columns.Add("状态");
            data.Columns.Add("余额");
            data.Columns.Add("备注");
            data.Rows.Add("10101", "十栋", "101", "正常", "96.13", "教师宿舍");
            data.Rows.Add("70102", "七栋", "102", "正常", "20.25", "教师宿舍");
            ////上面这块自己改为读数据库填充datatable对象主要用这2个ado对象：System.Data.SqlClient.SqlConnection，System.Data.SqlClient.SqlDataAdapter



            dataGridView1.DataSource = data;

            DataGridViewButtonColumn col = new DataGridViewButtonColumn
            {
                Name = "充值",
                HeaderText = "充值",
                DefaultCellStyle = new DataGridViewCellStyle { NullValue = "充值" , Alignment= DataGridViewContentAlignment.MiddleCenter }
            };
            dataGridView1.Columns.Add(col);

            dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[6].Style.NullValue = " ";
        }

//注意要改datagriview添加CellContentClick事件
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            var colIndex = e.ColumnIndex;
            var rowIndex = e.RowIndex;
            if (colIndex == 6)
            {
                MessageBox.Show("点击充值列\n编号：" + dataGridView1.Rows[rowIndex].Cells[0].Value);
                //后续操作，显示其他Form之类的，
            }
        }
    }
}