首页 文章

如何获取一个数据网格视图的行的值并在C#中的其他数据网格视图中显示值?

提问于
浏览
-1
private void ChooseItem_Load(object sender, EventArgs e)
{
    grid();
}

public void grid() 
{
    SqlConnection conn = new SqlConnection(connStr);

    try
    {
        conn.Open();

        string query = "SELECT INT_NO,INT_CODE,INT_DESC FROM TBL_IGP_DETAIL";

        SqlCommand cmd = new SqlCommand(query, conn);
        cmd.ExecuteNonQuery();

        SqlDataAdapter da = new SqlDataAdapter(query, conn);
        DataTable dt = new DataTable();
        da.Fill(dt);

        dataGridChooseItem.AutoGenerateColumns = false;
        dataGridChooseItem.ColumnCount = 3;
        dataGridChooseItem.Columns[0].Name = "ItemNo";
        dataGridChooseItem.Columns[0].HeaderText = "Item No";
        dataGridChooseItem.Columns[0].DataPropertyName = "INT_NO";

        dataGridChooseItem.Columns[1].Name = "ItemName";
        dataGridChooseItem.Columns[1].HeaderText = "Item Name";
        dataGridChooseItem.Columns[1].DataPropertyName = "INT_CODE";

        dataGridChooseItem.Columns[2].Name = "User";
        dataGridChooseItem.Columns[2].HeaderText = "User";
        dataGridChooseItem.Columns[2].DataPropertyName = "INT_DESC";
        dataGridChooseItem.DataSource = dt;
    }
    catch(Exception ex) 
    {
        MessageBox.Show(ex.Message);
    }
}

private void dataGridChooseItem_CellClick(object sender, DataGridViewCellEventArgs e)
{
    int ItemNo = Convert.ToInt32(dataGridChooseItem.Rows[e.RowIndex].Cells[0].Value.ToString());
    string ItemName = dataGridChooseItem.Rows[e.RowIndex].Cells[1].Value.ToString() ;
    int Quantity = Convert.ToInt32(dataGridChooseItem.Rows[e.RowIndex].Cells[2].Value.ToString());
    PermanentInwardGatePass ig = new PermanentInwardGatePass();
    ig.Show();
    this.Hide();
}

public int ItemNo { get; set; }
public string ItemName { get; set; }
public int Quantity { get; set; }

我想从此数据网格视图中获取所选行的值,并且我想在另一个数据网格视图中显示此选定的行值 . 请告诉我用于此目的的正确事件 .

任何人都可以告诉我正确的代码吗?

1 回答

相关问题