Data Presentation Controls

Re: Drop Down List in a GRIDVIEW

priyappated — Tue, 07 Oct 2008 09:30:01 GMT

try this out it helped me a lot

http://www.codeproject.com/KB/aspnet/GridviewItemDropdown.aspx

Re: Drop Down List in a GRIDVIEW

newtoaspnet2008 — Mon, 06 Oct 2008 13:52:03 GMT

Hello Sir,

is there any possibility that you can post a sample or example. I really appreciate it.

Thanks

Re: Drop Down List in a GRIDVIEW

nikhil.jha — Sat, 04 Oct 2008 11:16:14 GMT

Hi,

As mentioned in my previous reply, you can achieve the desired result programmatically. For this, do not bind the columns of the gridview statically but bind them dynamically inside GridView1_RowDataBound as explained earlier. Get the records in a dataset. Inside GridView1_RowDataBound, assign the values to all the labels (Title, Price etc.) and then loop through the records for adding the corresponding Sizes to ddlSizes. Repeat the same for remaining titles.

Re: Drop Down List in a GRIDVIEW

Qin Dian Tang - MSFT — Fri, 03 Oct 2008 07:02:10 GMT

Hi newtoaspnet2008,

Have you initialized DropDownList bound with a data source? If not, you cannot set SelectedValue for it before bound it, because there is no value in it and how the selected one comes. So I think you need to give a data source to DropDownList by setting DataSourceID with data source control or setting manually in RowDataBound event of GridView.

Thanks,

Re: Drop Down List in a GRIDVIEW

newtoaspnet2008 — Thu, 02 Oct 2008 17:56:49 GMT

Hello All,

here is the complete code: and regarding breakpoint this might be very silly and dumb but there is no option to insert a breakpoint in ASPX page. i know how to do it the code behind page(ASPX.CS).

if i run it in debug mode it just show the same error what i posted earlier.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DDLinGV.aspx.cs" Inherits="DDLinGV" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

</head>

<body>

<div>

<asp:TextBox id="txtSearch" runat="server" />

<asp:Button id="btnSearch" runat="server"

Text = "Search"

OnClick = "btnSearch_OnClick" />

<br />

<asp:Panel ID="SearchPanel" runat="server" Visible="false">

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:WSLocalDBConnectionString %>"

SelectCommand="SELECT [ItemNumber], [Title], [Price], [SizeName],[Description],[ShortTitle],[ShortDescription],[TitleImage],[ThumbnailImage] FROM [SearchTable] WHERE (([Title] LIKE '%' + replace(@Title, ' ', '%') + '%') OR ([ShortDescription] LIKE '%' + replace(@ShortDescription, ' ', '%') + '%') OR ([ShortTitle] LIKE '%' + replace(@ShortTitle, ' ', '%') + '%') OR ([Description] LIKE '%' + replace(@Description, ' ', '%') + '%') OR ([ItemNumber] LIKE '%' + replace(@ItemNumber, ' ', '%') + '%') OR ([SizeName] LIKE '%' + replace(@SizeName, ' ', '%') + '%'))" OnSelecting="SqlDataSource1_Selecting" >

<asp:Parameter Name="Title" Type="String" />

<asp:Parameter Name="ShortDescription" Type="String" />

<asp:Parameter Name="ShortTitle" Type="String" />

<asp:Parameter Name="Description" Type="String" />

<asp:Parameter Name="ItemNumber" Type="String" />

<asp:Parameter Name="SizeName" Type="String" />

</SelectParameters>

</asp:SqlDataSource>

<br />

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"

CellPadding="4" DataKeyNames="ItemNumber" DataSourceID="SqlDataSource1" ForeColor="#333333"

GridLines="None" AllowSorting="True">

<asp:BoundField DataField="ItemNumber" HeaderText="Item" InsertVisible="False"

SortExpression="ItemNumber" HtmlEncode="False" />

<asp:BoundField DataField="Title" HeaderText="Product Name" SortExpression="Title" HtmlEncode="False" />

<asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" DataFormatString="{0:c}" HtmlEncode="False" />

<asp:BoundField DataField="SizeName" HeaderText="Sizes" SortExpression=SizeName HtmlEncode="False" />

<asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" HtmlEncode="False" />

<asp:TemplateField HeaderText="Available Sizes">

<asp:DropDownList ID="ddlSizes" runat="server" DataTextField="SizeName" AppendDataBoundItems="true"

DataValueField="ItemNumber" SelectedValue="<%# Bind('SizeName') %>" />

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</asp:Panel>

</div>

</form>

</body>

</html>

------------------ CODE BEHIND ------------

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class DDLinGV : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void btnSearch_OnClick(object sender, EventArgs e)
    {
        SearchPanel.Visible = true;
        GridView1.DataBind();

       
    }

    protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        e.Command.Parameters["@Title"].Value = txtSearch.Text;
        e.Command.Parameters["@ShortDescription"].Value = txtSearch.Text;
        e.Command.Parameters["@ShortTitle"].Value = txtSearch.Text;
        e.Command.Parameters["@Description"].Value = txtSearch.Text;
        e.Command.Parameters["@ItemNumber"].Value = txtSearch.Text;
        e.Command.Parameters["@SizeName"].Value = txtSearch.Text;


            }
}

Thanks a lot, i really appreciate it.

Re: Drop Down List in a GRIDVIEW

nikhil.jha — Thu, 02 Oct 2008 17:48:35 GMT

Hi,

You may add the the items to the drop down lists inside GridView1_RowDataBound(object sender, GridViewRowEventArgs e). Place a condition as -

if (e.Row.RowType != DataControlRowType.Header && e.Row.RowType != DataControlRowType.Footer)

{

}

Now within this if block, loop through the items and add Price as well as Size to the corresponding dropdownlist.

Dont bind the dropdownlists in the gridview definition itself if you are going for this approach.

Hope this helps.

Re: Drop Down List in a GRIDVIEW

engineerachu — Thu, 02 Oct 2008 17:33:39 GMT

Can you post the code?

Re: Drop Down List in a GRIDVIEW

renitdaniel — Thu, 02 Oct 2008 17:06:01 GMT

Could you put a breakpoint in there and tell me what value ou are receiving?

Re: Drop Down List in a GRIDVIEW

newtoaspnet2008 — Thu, 02 Oct 2008 16:46:13 GMT

Hello Sir,

if i try like SelectedValue="<%# Bind('SizeName') %> i am getting the following error

'ddlSizes' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentOutOfRangeException: 'ddlSizes' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

Source Error:

Line 20:     {
Line 21:         SearchPanel.Visible = true;
Line 22:         GridView1.DataBind();
Line 23: 
Line 24:

Thanks I appreciate it

Re: Drop Down List in a GRIDVIEW

renitdaniel — Thu, 02 Oct 2008 16:35:58 GMT

Yes he is right, try SelectedValue.. 'text' is not a property of DDL, my bad

Re: Drop Down List in a GRIDVIEW

Ganesh@Nilgris — Thu, 02 Oct 2008 16:30:38 GMT

newtoaspnet2008:

Hello Sir,

i tried the way you have adviced, i am getting the following error

'ddlSizes' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

any suggestions sir

Thanks i appreciate it

u cant use "Text" property . there is no text property for dropdownlist . u have to use "SelectedValue"

Re: Drop Down List in a GRIDVIEW

newtoaspnet2008 — Thu, 02 Oct 2008 16:10:46 GMT

Hello Sir,

i tried the way you have adviced, i am getting the following error

'ddlSizes' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

any suggestions sir

Thanks i appreciate it

Re: Drop Down List in a GRIDVIEW

renitdaniel — Thu, 02 Oct 2008 15:02:07 GMT

Try something like this:

<asp:GridView ID="GridView1" runat="server" DataKeyName="ItemNo" DataSource = "DataSource_Name">

<asp:TemplateField>

<asp:Label ID="lblItemNo" runat="server" Text='<%# Bind("ItemNo") %>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Sizes" >

<asp:DropDownList ID="ddSizes" runat="server" DataTextField="Size" DataValueField="ItemNo" AppendDataBoundItems="true"

Text="<%#Bind('Size') %>">

</asp:DropDownList>

</ItemTemplate>

</asp:TemplateField>

</asp:GridView>

Re: Drop Down List in a GRIDVIEW

newtoaspnet2008 — Thu, 02 Oct 2008 14:22:12 GMT

Hello there,

i am still stuck, all i am trying to is for every itemNo in the gridview i want to display its (itemno) sizes in dropdownlist. is there anyway to do this.

i really appreciate it.

Thanks

Re: Drop Down List in a GRIDVIEW

renitdaniel — Tue, 30 Sep 2008 20:07:16 GMT

Hey there

Check this link out http://www.webswapp.com/codesamples/aspnet20/dropdownlist_gridview/default.aspx

The coding is given in the links below the page. Im assuming it is similar to what you are trying to implement.

Data Presentation Controls

Re: Drop Down List in a GRIDVIEW

Re: Drop Down List in a GRIDVIEW

Re: Drop Down List in a GRIDVIEW

Re: Drop Down List in a GRIDVIEW

Re: Drop Down List in a GRIDVIEW

Re: Drop Down List in a GRIDVIEW

Re: Drop Down List in a GRIDVIEW

Re: Drop Down List in a GRIDVIEW

Re: Drop Down List in a GRIDVIEW

'ddlSizes' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value

Re: Drop Down List in a GRIDVIEW

Re: Drop Down List in a GRIDVIEW

'ddlSizes' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value

Re: Drop Down List in a GRIDVIEW

'ddlSizes' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value

Re: Drop Down List in a GRIDVIEW

Re: Drop Down List in a GRIDVIEW

Re: Drop Down List in a GRIDVIEW

'ddlSizes' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

'ddlSizes' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value

'ddlSizes' has a SelectedValue which is invalid because it does not exist in the list of items.
Parameter name: value