Fill Dataset value into DataGridView cell in ADO.NET

Bineesh Viswanath

11y1.3kLearn iOS Programming

Sir,

I am in the function of fetching dataset value into a cell in DataGridView in ADO.NET.

I am getting a error in the function i wrote to fetch data. Here the screenshot:-

dgvtxtAddProduct is the comboBox cell. If this is wrong, how can i fetch data into DataGridView ComboBox Cell?

Here the MS SQL Query:-

9 Replies

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

Prateek Singla11y ago
this will work only if he is using unique id as first column
0
Rajeesh Menoth11y ago
Hi,

That's good..without change before you just check this one..

//change this line and add table[0] ;
dgvtxtAddProduct.DataSource = ds.Tables[0];
0
Bineesh Viswanath11y ago
Finally my issue has been solved.

I didn't added code, but changed the DataTable replaced Dataset. Here the code:-

0
Rajeesh Menoth11y ago
Hi,

Ref the following articles:

1) http://www.c-sharpcorner.com/UploadFile/0f68f2/programmatically-binding-datasource-to-combobox-in-multiple/

2) http://www.asp.net/web-forms/overview/ajax-control-toolkit/combobox/how-do-i-use-the-combobox-control-cs
0
Prateek Singla11y ago
You have to add DataPropertyName which is primary key of your table

dgvtxtAddProduct.DataPropertyName = "PID";
0
Manas Mohapatra11y ago
Sorry, I assumed that it is a dropdown list.
Please add below code:

dgvtxtAddProduct.DataSource = ds;
dgvtxtAddProduct.DataPropertyName = "PID";
dgvtxtAddProduct.DisplayMember = "PNAME";
dgvtxtAddProduct.ValueMember = "PID";

As per your error, please check/debug datatable columns names. Make sure that it has PID and PNAME columns are there.
0
Bineesh Viswanath11y ago
Dear Manas,

The cell in DataGridView is a DataGridViewComboBoxColumn. It doesn't shows DataValueField and DataTextField in code intellisense.

0
Rajeesh Menoth11y ago
Hi Bineesh VP,

In your gridview cell contain dropdown list then you can follow Manas Mohapatra solution.

Please ref this example : http://www.aspdotnet-suresh.com/2010/10/how-to-populate-dropdown-based-on-other.html
0
Manas Mohapatra11y ago
If dgvtxtAddProduct is a dropdown control please see below code:

dgvtxtAddProduct.Datasource = myFetchedDataTable;
dgvtxtAddProduct.DataValueField = "PName";
dgvtxtAddProduct.DataTextField = "PID";
dgvtxtAddProduct.Databind();

Before you bind data set to combobox please debug what are columns present.
0