Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > datagrid editcommand

Reply
Thread Tools

datagrid editcommand

 
 
Richard Roche
Guest
Posts: n/a
 
      07-31-2003
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.
 
Reply With Quote
 
 
 
 
Eric Wise
Guest
Posts: n/a
 
      07-31-2003
Read up on datagrid template fields.

"Richard Roche" <(E-Mail Removed)> wrote in message
news:024501c3578c$ee23afe0$(E-Mail Removed)...
> 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.



 
Reply With Quote
 
 
 
 
Lewis Wang [MSFT]
Guest
Posts: n/a
 
      08-01-2003
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/de...-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...mWebUIWebContr
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" <(E-Mail Removed)>
| References: <024501c3578c$ee23afe0$(E-Mail Removed)>
| 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#(E-Mail Removed)>
| 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!tk2msftn gp13.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.
|
| "Richard Roche" <(E-Mail Removed)> wrote in message
| news:024501c3578c$ee23afe0$(E-Mail Removed)...
| > 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.
|
|
|

 
Reply With Quote
 
Richard Roche
Guest
Posts: n/a
 
      08-01-2003
Thanks, I have it working :>
 
Reply With Quote
 
Lewis Wang [MSFT]
Guest
Posts: n/a
 
      08-04-2003
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" <(E-Mail Removed)>
| Sender: "Richard Roche" <(E-Mail Removed)>
| References: <024501c3578c$ee23afe0$(E-Mail Removed)>
<uS#(E-Mail Removed)>
<(E-Mail Removed)>
| Subject: Re: datagrid editcommand
| Date: Fri, 1 Aug 2003 15:37:15 -0700
| Lines: 1
| Message-ID: <04a401c3587d$74f47540$(E-Mail Removed)>
| 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 :>
|

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
datagrid not visible when databind() on editcommand =?Utf-8?B?amFjb2JyeWNl?= ASP .Net 1 02-15-2005 06:25 PM
datagrid editcommand question bill yeager ASP .Net 1 11-28-2004 05:21 PM
EditCommand on a Nested DataGrid... Linus ASP .Net 0 10-08-2004 12:37 AM
Re: datagrid EditCommand event Craig Deelsnyder ASP .Net 0 07-09-2004 05:46 PM
Non-displayed values in DataGrid that stay accessible in EditCommand event? Mike ASP .Net 0 12-05-2003 11:32 PM



Advertisments