// 假设有一个Linq To Sql DataContext
var dbContext = new YourDataContext();

// 查询数据并绑定到DataGridView
var query = from item in dbContext.YourTable
            select item;
dataGridView1.DataSource = query.ToList();

private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
    if (dataGridView1.SelectedRows.Count > 0)
    {
        // 获取选中的行
        DataGridViewRow selectedRow = dataGridView1.SelectedRows[0];
        
        // 获取行对应的实体
        var selectedEntity = selectedRow.DataBoundItem as YourEntityType;
        
        if (selectedEntity != null)
        {
            // 现在可以使用selectedEntity进行操作
            Console.WriteLine($"Selected entity ID: {selectedEntity.Id}");
        }
    }
}

private void ProcessSelectedRows()
{
    var selectedEntities = new List<YourEntityType>();
    
    foreach (DataGridViewRow row in dataGridView1.SelectedRows)
    {
        var entity = row.DataBoundItem as YourEntityType;
        if (entity != null)
        {
            selectedEntities.Add(entity);
        }
    }
    
    // 现在selectedEntities包含所有选中的实体
}

// 定义实体类（通常由Linq To Sql设计器生成）
public partial class Product
{
    public int ProductID { get; set; }
    public string ProductName { get; set; }
    public decimal UnitPrice { get; set; }
}

// 数据访问
public List<Product> GetProducts()
{
    using (var db = new NorthwindDataContext())
    {
        return db.Products.ToList();
    }
}

// 窗体加载时绑定数据
private void Form1_Load(object sender, EventArgs e)
{
    dataGridView1.DataSource = GetProducts();
    dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
}

// 处理选择变化
private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
    if (dataGridView1.SelectedRows.Count == 0) return;
    
    var selectedProduct = dataGridView1.SelectedRows[0].DataBoundItem as Product;
    if (selectedProduct != null)
    {
        lblProductInfo.Text = $"Selected: {selectedProduct.ProductName} (${selectedProduct.UnitPrice})";
    }
}

// 更新按钮点击事件
private void btnUpdate_Click(object sender, EventArgs e)
{
    if (dataGridView1.SelectedRows.Count == 0) return;
    
    var selectedProduct = dataGridView1.SelectedRows[0].DataBoundItem as Product;
    if (selectedProduct != null)
    {
        using (var db = new NorthwindDataContext())
        {
            var productToUpdate = db.Products.Single(p => p.ProductID == selectedProduct.ProductID);
            productToUpdate.UnitPrice = selectedProduct.UnitPrice;
            db.SubmitChanges();
            MessageBox.Show("Update successful!");
        }
    }
}