Populating DropDownList in a DataGrid

Question

I am currently developing a small program in C#.NET. Since I am just beginning to learn this language, I decided to work on DataGrid since it is a very good component used throughout the web.
Let's say I have a DataGrid (dgOne) and within dgOne I have 2 columns. I also have a button called btnShow.
First column contains DDL (ddlOne).
Second column contains TextBox (txtOne).
What I want to achieve is that upon the click of btnShow I will populate dgOne with values retrieved from the database.
I have tested the codes populating only a single DDL (not in a DataGrid) and it works fine. I just somehow can't get the program to populate the DDL. Anyone would be able to guide this newbie out? Any suggestions, advices, links will be greatly appreciated.

nilesh rathod · Answer

sfdf dsgdfsg dsffdsg

nilesh rathod · Answer

ytryrt dgdsfg dg dsfgd

Maruli Lee · Answer

Hi Sanoj,
Could you please provide me with a snippets on how to work with DataTable?
Thank you for your help time and time again.

sanoj kumar · Answer

Hai Lee,
Are you sure the dataview have data?
I am using Datatable for purposes like this.
I think it can done using datatable.
Fill datas to datatable and give it as datasource,it will work.

Maruli Lee · Answer

That was what I think of initially but after I did that, the grid is still not showing up. Wonder what's wrong. The code is below:
private void btnShow_Click( object sender, System.EventArgs e)
{
pTable = getCharges();
if (pTable != null )
{
pTable.DefaultView.Sort = "CHARGEID";
DataView pDV = pTable.DefaultView;
dgCharges.DataSource = pDV;
dgCharges.DataBind();
}

sanoj kumar · Answer

Hai Lee, I am again
I don't know what you meant, if you want to display the grid when button pressed then
don't bind the grid at page load do it in the button pressed event.
All the best...

Maruli Lee · Answer

Hey again Sanoj,
I have managed to populate the DDLs as well as show the datagrid upon page load.
What I did was:
1. Upon page load, I bind the datagrid
2. Populate the DDL inside the datagrid_ItemDataBound event
I have another question please. I do not want the grid to show up (and the DDL to populate themselves) upon page load. I only want to do that when user click on a button because I would like to filter the data based on a UniqueID that user will be entering into a textbox.
Any ideas/suggestions?

sanoj kumar · Answer

Hai Lee,
I think i got your problem.
Do you have any dataset to bind the datagrid?
To view your datagrid you must bind it.because
the datagrid have no values to display.so not load.
In your case you can do it before the for each loop.
And note that if there is no rows in datagrid that
foreach loop will never execute.
If you haven't the need to bind grid You can use datatable.
If nee more help reply.

Maruli Lee · Answer

Hi Sanoj,
My aspx code is as follow:
The records that I retrieved from the database are stored inside a DataSet:
CHARGEID " type="xs:string" minOccurs="0" />
CHARGEDESC " type="xs:string" minOccurs="0" />
What I want to achieve is to populate the DDL upon clicking on a button (btnShow). Currently I did it like this:
private void btnShow_Click( object sender, System.EventArgs e)
{
try
{
SWIFTDS.FS_FR_CHARGESMASTERDataTable pTable = null ;
pTable = getCharges();   //Retrieve data from db
pTable.DefaultView.Sort = "CHARGEID";
int i = 0;
foreach (DataGridItem di in dgCharges.Items)
{
if (di.ItemType == ListItemType.Item || di.ItemType == ListItemType.AlternatingItem)
{
((DropDownList)dgCharges.Items[i].FindControl("cboCharges")).DataSource=pTable;
((DropDownList)dgCharges.Items[i].FindControl("cboCharges")).DataValueField="CHARGEDESC";
((DropDownList)dgCharges.Items[i].FindControl("cboCharges")).DataTextField="CHARGEDESC";
((DropDownList)dgCharges.Items[i].FindControl("cboCharges")).DataMember ="CHARGEID";
((DropDownList)dgCharges.Items[i].FindControl("cboCharges")).DataBind();
}
i++;
}
}
catch ( System.Exception er)
{
// Do something here
}
}
Despite doing this, I still did not see anything when I clicked on the Show button. I didn't even see the datagrid at all. Is there anything that I missed out?

sanoj kumar · Answer

I thing your code will just like this
look it(I only added 1 column).
the second column will come after
i'm using DataReader to bind DDL.
All the best.