datagrid editcommand

  • Thread starter Thread starter Richard Roche
  • Start date Start date
R

Richard Roche

Is it possible to use a drop combo instead of a text box
when using the EditCommand in the Datagrid? Many table
columns are bound to 'lookup' tables, user's don't care
about the foreign keys, they want the text value. Any
advice, samples or places to read are appreciated.

Thanks.
 
Hi Richard,

We can change a Textbox to a DropDownList in Datagrid edit mode. Please see
the following steps:

1. Change the bound column to a template column. You can easily do this in
the properties builder of the Datagrid. Select the columns tab, and then
click the column in the "Select columns"listbox, and you will find a link
"convert this column to a template column" upon "OK" button. Click the link
then click OK.

2. Right click the Datagrid and move to "Edit Template", then select the
template column in the pop up menu, delete the textbox in the
EditItemTemplate cell and add a DropDownList.

3. In the code behind, initialize the DropDownList in the
DataGrid1_ItemDataBound event:

Here is a snippet:

private void DataGrid1_ItemDataBound(object sender,
System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.EditItem)
{
Control ctrl=e.Item.FindControl("DropDownList1");
if(ctrl!=null)
{
DropDownList dropdown=(DropDownList)ctrl;
dropdown.DataSource =DataGrid1.DataSource ;
dropdown.DataTextField = "id";
dropdown.DataValueField = "value";
dropdown.DataBind ();
}
}
}

You can check these links for more information:

Top Questions about the DataGrid Web Server Control
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vstecha
rt/html/vbtchtopquestionsaboutaspnetdatagridservercontrol.asp>

Datagrid ... Combo instead of Textbox
<http://www.dotnet247.com/247reference/msgs/5/28740.aspx>

DataGrid.EditCommand Event
<http://msdn.microsoft.com/library/en-us/cpref/html/frlrfSystemWebUIWebContr
olsDataGridClassEditCommandTopic.asp>

Please let me know if you need more information, thanks.

Best Regards,
Lewis

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| From: "Eric Wise" <[email protected]>
| References: <[email protected]>
| Subject: Re: datagrid editcommand
| Date: Thu, 31 Jul 2003 15:41:30 -0400
| Lines: 13
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
| Message-ID: <uS#[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: wva-guard-cn1.wva.army.mil 155.218.88.2
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:163902
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Read up on datagrid template fields.
|
| | > Is it possible to use a drop combo instead of a text box
| > when using the EditCommand in the Datagrid? Many table
| > columns are bound to 'lookup' tables, user's don't care
| > about the foreign keys, they want the text value. Any
| > advice, samples or places to read are appreciated.
| >
| > Thanks.
|
|
|
 
I am glad to hear it. Thanks very much for participating the community.

Regards,
Lewis

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Content-Class: urn:content-classes:message
| From: "Richard Roche" <[email protected]>
| Sender: "Richard Roche" <[email protected]>
| References: <[email protected]>
<uS#[email protected]>
<[email protected]>
| Subject: Re: datagrid editcommand
| Date: Fri, 1 Aug 2003 15:37:15 -0700
| Lines: 1
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcNYfXT0stH/1Y/KSiKm5zsyX5piWw==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet:164278
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Thanks, I have it working :>
|
 
Back
Top