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;
using System.Data.Common;

namespace DataGridViewDemo
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

    string conStr = "server=localhost;database=db\_EMS;integrated security=true";  
    SqlConnection conn;  
    SqlDataAdapter da;  
    DataSet ds;  
    private void Form1\_Load(object sender, EventArgs e)  
    {  
        //禁止添加行  
        dataGridView1.AllowUserToAddRows = false;  
        //禁止刪除行  
        dataGridView1.AllowUserToDeleteRows = false;  
        conn = new SqlConnection(conStr);  
        da = new SqlDataAdapter("select \* from tb\_pdic", conn);  
        ds = new DataSet();  
        da.Fill(ds);  
        dataGridView1.DataSource = ds.Tables\[0\];  
        //禁止對列進行排序（這個要在賦值datasource後）  
        for (int i = 0; i < dataGridView1.Columns.Count; i++)  
            dataGridView1.Columns\[i\].SortMode = DataGridViewColumnSortMode.NotSortable;  
        //選中時選中整行  
        dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;  
        //不同的行賦值不同的顏色  
        foreach(DataGridViewRow dgv in dataGridView1.Rows)  
        {  
            if(dgv.Index%2==0)  
            {  
                dataGridView1.Rows\[dgv.Index\].DefaultCellStyle.BackColor = Color.LightSalmon;  
            }  
            else  
            {  
                dataGridView1.Rows\[dgv.Index\].DefaultCellStyle.BackColor = Color.LightPink;  
            }  
        }  
        dataGridView1.ReadOnly = true;  
        //設置選中行的顏色  
        dataGridView1.DefaultCellStyle.SelectionBackColor = Color.LightSkyBlue;

    }

    private void dataGridView1\_CellClick(object sender, DataGridViewCellEventArgs e)  
    {  
        int id =(int) dataGridView1.Rows\[e.RowIndex\].Cells\[0\].Value;  
        conn = new SqlConnection(conStr);  
        da = new SqlDataAdapter("select \* from tb\_pdic where id=" + id, conn);  
        ds = new DataSet();  
        da.Fill(ds);  
        if (ds.Tables\[0\].Rows.Count > 0)  
        {  
            textBox1.Text = ds.Tables\[0\].Rows\[0\]\["name"\].ToString();  
            textBox2.Text = ds.Tables\[0\].Rows\[0\]\["money"\].ToString();  
        }  
    }  
}  

}