C#数据库编程基础之部分控件应用及DataGridView的操作

 1. 我们来接着使用DataGridView,在上一篇关于类似QQ登录的文章里我们已经讲述了

怎么初步使用DataGridView来显示数据库里的数据,接下来我们来讨论怎么实现在

DataGridView里实现对一行或多行的数据删除以及对一行的数据添加。看下列代码:
 
        SqlConnection myconnection;
        SqlCommand mycommand;
        SqlDataReader mydatareader;
        DataTable table;

        //使窗口在载入后就显示数据库里的所有信息(类似QQ登录的文章里我们已经

讲述)
        private void DataGridView窗口_Load(object sender, EventArgs e)
        {
            myconnection = new SqlConnection("Data Source=.;Initial

Catalog=mydata;Integrated Security=True");
            myconnection.Open();
            mycommand = new SqlCommand("select * from xueshengxinxi",

myconnection);
            mydatareader = mycommand.ExecuteReader();
            table = new DataTable();
            table.Load(mydatareader);
            dataGridView1.DataSource = table;
            myconnection.Close();
            mydatareader.Close();
           

        }

        private void 删除_Click(object sender, EventArgs e)
        {
           
            myconnection = new SqlConnection("Data Source=.;Initial

Catalog=mydata;Integrated Security=True");
            myconnection.Open();
            var row = dataGridView1.SelectedRows; //dataGridView的

SelectedRow