如何将选定的记录值绑定到Winforms控件 [英] How to bind a selected record values to winforms controls

问题描述

如何使用C#.net将datagridview中的选定记录值绑定到winforms控件?

How to bind a selected record value from datagridview to winforms controls using C#.net?

推荐答案

要绑定datagridview中的选定记录值. >

公共无效fillGrid()
{

sqlcnn1 = obj_purchase.Connection_create();
sqlcnn1.Open();
SqlCommand cmdPayment =新的SqlCommand();
DataSet DSPayment = new DataSet();
SqlDataAdapter DAPayment =新的SqlDataAdapter();
字符串strPayment =从* PURCHASE_MASTER中选择*";
cmdPayment.CommandText = strPayment;
cmdPayment.Connection = sqlcnn1;
DAPayment.SelectCommand = cmdPayment;
cmdPayment.ExecuteNonQuery();
DAPayment.Fill(DSPayment);
如果(DSPayment.Tables [0] .Rows.Count> 0)
{
DGVpurchase.DataSource = DSPayment.Tables [0] .DefaultView;
}
sqlcnn1.Close();
}

To bind a selected record value from datagridview..


public void fillGrid()
{

sqlcnn1 = obj_purchase.Connection_create();
sqlcnn1.Open();
SqlCommand cmdPayment = new SqlCommand();
DataSet DSPayment = new DataSet();
SqlDataAdapter DAPayment = new SqlDataAdapter();
string strPayment = "select * from PURCHASE_MASTER";
cmdPayment.CommandText = strPayment;
cmdPayment.Connection = sqlcnn1;
DAPayment.SelectCommand = cmdPayment;
cmdPayment.ExecuteNonQuery();
DAPayment.Fill(DSPayment);
if (DSPayment.Tables[0].Rows.Count > 0)
{
DGVpurchase.DataSource = DSPayment.Tables[0].DefaultView;
}
sqlcnn1.Close();
}

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
DataGridViewCell cell = (DataGridViewCell)DGVpurchase.Rows[e.RowIndex].Cells[0];
if ((string)cell.Value.ToString().Trim() == "null" || (string)cell.Value.ToString().Trim() == "")
{
}
else
oldid = (string)cell.Value;
Show_data();

}

}

私人空白Show_data()
{
如果(oldid！= null)
{
obj_purchase.selectpurchase(oldid);
数据表dt1 = obj_purchase.selectpurchase(oldid);
txtProductId.Text =(string)dt1.Rows [0] [0];
txtProductName.Text =(string)dt1.Rows [0] [1];
txtQty.Text =(decimal.Round(decimal.Parse(dt1.Rows [0] [2] .ToString().Trim())，2)).ToString().Trim();
cmbUnit.Text =(string)dt1.Rows [0] [3];
txtcost.Text =(decimal.Round(decimal.Parse(dt1.Rows [0] [4] .ToString().Trim())，2)).ToString().Trim();
cmbVat.Text =(decimal.Round(decimal.Parse(dt1.Rows [0] [5] .ToString().Trim())，2)).ToString().Trim();
txtSalePrice.Text =(decimal.Round(decimal.Parse(dt1.Rows [0] [6] .ToString().Trim())，2)).ToString().Trim();
txtRemarks.Text =(string)dt1.Rows [0] [7];
ProductID =(string)dt1.Rows [0] [0];
ProductName =(string)dt1.Rows [0] [1];

txtProductId.Focus();

btnSave.Enabled = false;
btnDelete.Enabled = true;
btnUpdate.Enabled = true;
btnSearch.Enabled = false;
模式=编辑";
}
}

}

private void Show_data()
{
if (oldid != null)
{
obj_purchase.selectpurchase(oldid);
DataTable dt1 = obj_purchase.selectpurchase(oldid);
txtProductId.Text = (string)dt1.Rows[0][0];
txtProductName.Text = (string)dt1.Rows[0][1];
txtQty.Text = (decimal.Round(decimal.Parse(dt1.Rows[0][2].ToString().Trim()), 2)).ToString().Trim();
cmbUnit.Text = (string)dt1.Rows[0][3];
txtcost.Text = (decimal.Round(decimal.Parse(dt1.Rows[0][4].ToString().Trim()), 2)).ToString().Trim();
cmbVat.Text = (decimal.Round(decimal.Parse(dt1.Rows[0][5].ToString().Trim()), 2)).ToString().Trim();
txtSalePrice.Text = (decimal.Round(decimal.Parse(dt1.Rows[0][6].ToString().Trim()), 2)).ToString().Trim();
txtRemarks.Text = (string)dt1.Rows[0][7];
ProductID = (string)dt1.Rows[0][0];
ProductName = (string)dt1.Rows[0][1];

txtProductId.Focus();

btnSave.Enabled = false;
btnDelete.Enabled = true;
btnUpdate.Enabled = true;
btnSearch.Enabled = false;
Mode = "Edit";
}
}

这篇关于如何将选定的记录值绑定到Winforms控件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！