c# 从零到精通 读取连接数据库-并将读取到的数据添加到dataGridView1 选中状态 全选
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Test07
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

    private void Form1_Load(object sender, EventArgs e){SqlConnection con = new SqlConnection("server=(local);uid=sa;pwd=;database=db_16");con.Open();DataSet ds = new DataSet();SqlDataAdapter da = new SqlDataAdapter("select * from tb_emp", con);da.Fill(ds);this.dataGridView1.DataSource = ds.Tables[0].DefaultView;}private void button1_Click(object sender, EventArgs e){this.dataGridView1.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;int Cont = dataGridView1.GetCellCount(DataGridViewElementStates.Selected);//选取单元格的数目即有行又有列if (Cont > 0){if (dataGridView1.AreAllCellsSelected(true))//判断是否选重了所有的值。{MessageBox.Show("你选重了所有的值", "全部选中了");}else{System.Text.StringBuilder sb = new System.Text.StringBuilder();for (int i = 0; i < Cont; i++){sb.Append("Row: ");sb.Append(dataGridView1.SelectedCells[i].RowIndex.ToString());sb.Append(", Column: ");sb.Append(dataGridView1.SelectedCells[i].ColumnIndex.ToString());sb.Append(Environment.NewLine);}sb.Append("Total: " + Cont.ToString());MessageBox.Show(sb.ToString(), "Selected Cells");}}}
}

}