Display data to datagridview

Marvin Gapuz

private void CmbCombo_SelectedValueChanged(object sender, EventArgs e)

{

try

{

if (CmbCombo.SelectedValue != null && CmbCombo.SelectedIndex != -1)

{

if (CmbCombo.SelectedValue.ToString() != string.Empty && CmbCombo.SelectedValue.ToString() != "System.Data.DataRowView")

{

ComboCreationSP creationSP = new ComboCreationSP();

ComboCreationInfo creationInfo = new ComboCreationInfo();

creationInfo = creationSP.ComboMasterViewAllForProduct(Convert.ToDecimal(CmbCombo.SelectedValue));

for (int a = 0; a < 2; a++)

{

dgvSalesInvoice.Rows.Add();

dgvSalesInvoice.Rows[a].Cells["dgvtxtSalesInvoiceProductName"].Value = creationInfo.ProductName;

dgvSalesInvoice.Rows[a].Cells["DcDescription"].Value = creationInfo.ProductName;

dgvSalesInvoice.Rows[a].Cells["dgvtxtSalesInvoiceBrand"].Value = creationInfo.PBrandId;

dgvSalesInvoice.Rows[a].Cells["dgvtxtSalesInvoiceQty"].Value = creationInfo.Qty;

dgvSalesInvoice.Rows[a].Cells["dgvtxtSalesInvoiceRate"].Value = creationInfo.Rate;

dgvSalesInvoice.Rows[a].Cells["dgvtxtSalesInvoiceProductCode"].Value = creationInfo.ProductCode;

dgvSalesInvoice.Rows[a].Cells["dgvtxtSalesInvoiceBarcode"].Value = creationInfo.Barcode;

}

txtTotalAmount.Text =Convert.ToString(creationInfo.Amount);

}

catch (Exception ex)

{

MessageBox.Show(ex.ToString());

}

Please help, I use this code to display the data from the database to the datagridview, the problem is that it only displays the last data.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Can you check with the below link:
https://www.c-sharpcorner.com/UploadFile/mahesh/datagrid-in-wpf/
Aby C Paul7y ago
Kindly change your code like following way.

1. Change your increment value as per the count of your Data. As per your code It will get from creationInfo.

for (int a = 0; a < CountOfYourData; a++)

2. Add your data to a DataSet or DataTable and Bind grid from DataSet or DataTable

DataTable dt = new DataTable();

dt.Columns.Add("ProductName");

dt.Columns.Add("Description");

dt.Columns.Add("SalesInvoiceBrand");

dt.Columns.Add("SalesInvoiceQty");

dt.Columns.Add("SalesInvoiceRate");

dt.Columns.Add("SalesInvoiceProductCode");

dt.Columns.Add("SalesInvoiceBarcode");

for (int a = 0; a < CountOfYourData; a++)

{

dt.Rows.Add(creationInfo.ProductName, creationInfo.ProductName, creationInfo.PBrandId, creationInfo.Qty,creationInfo.Rate,creationInfo.ProductCode,creationInfo.Barcode);

}

dgvSalesInvoice.DataSource=Dt;
Jignesh Kumar7y ago
Hi,

You looping data but your loop has max value a<2.
for(int a = 0; a < countofYourresult ; a++)