修改学生信息

把信息弄到listView中
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Day0401
{
    public partial class FrmMain1 : Form
    {
        public FrmMain1()
        {
            InitializeComponent();
        }
        public string Name;
        private void button2_Click(object sender, EventArgs e)
        {
            this.textBox1.Text = "";
            this.textBox2.Text = "";
            this.textBox3.Text = "";
            this.textBox4.Text = "";
        }
        DBHelper d = new DBHelper();
        public void ShowInfo() {

            d.OpenConnection();
            string str = "select Name, Type, Number, Price from dbo.shang where Name='"+Name+"'";
            SqlCommand cmd = new SqlCommand(str, d.Connection);
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            { 
                this.textBox1.Text=dr["Name"].ToString();
               this.textBox2.Text=dr["Type"].ToString();
               this.textBox3.Text=dr["Number"].ToString();
               this.textBox4.Text=dr["Price"].ToString();
                
            }
            dr.Close();
        
        }

        private void FrmMain1_Load(object sender, EventArgs e)
        {
            ShowInfo();
        }
    }
}



using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Day0401
{
    public partial class FrmMain : Form
    {
        public FrmMain()
        {
            InitializeComponent();
        }
        DBHelper d = new DBHelper();
        private void Form1_Load(object sender, EventArgs e)
        {   
            
            d.OpenConnection();
            string str = "select Name, Type, Number, Price from dbo.shang";
            SqlCommand cmd = new SqlCommand(str, d.Connection);
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read()) {
                ListViewItem item = new ListViewItem(dr["Name"].ToString());
                item.SubItems.Add(dr["Type"].ToString());
                item.SubItems.Add(dr["Number"].ToString());
                item.SubItems.Add(dr["Price"].ToString());
                listView1.Items.Add(item);
            }
            dr.Close();
        }

        private void 修改ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (listView1.Items.Count > 0)
            {
                
                FrmMain1 form = new FrmMain1();
                form.Name = this.listView1.SelectedItems[0].Text;
                //MessageBox.Show(form.Name);
                form.Show();
            }
            else {
                MessageBox.Show("请选择一列", "提示");
            }
        }