I have question how can make cascading dropdownlist in gridview edit mode
the first dropdown is for departments and second is for classes
the primary table to be updated is employees table
How do I fill ProductNameID on selection of ProductCategoryID dropdown by passing
ProductCategoryID .SelectedValue...
aspx Code
<asp:GridView ID="gridPosition" runat="server" AutoGenerateColumns="False" ShowFooter="True" OnRowDataBound="gridPosition_onRowDataBound"
DataKeyNames="SaleDetailID" OnRowEditing="gridPosition_RowEditing"
OnRowCancelingEdit="gridPosition_RowCancelingEdit" OnRowUpdating="gridPosition_RowUpdating"
OnRowDeleting="gridPosition_RowDeleting" ShowHeaderWhenEmpty="True" CssClass="manage-admin"
Width="500px" GridLines="None">
[Code] .....
I have two dropdownlists inside a repeater. And based on the value I pick in the first dropdownlist the second needs to get populated (both need to be populated from the DB via stored proc). I am adding the code I have so far but it's not complete
<asp:Repeater ID="rpt" runat="server" OnItemDataBound="rpt_ItemDataBound">
<ItemTemplate>
<tr>
[Code].....
I have created two dropdown lists. The 2nd DDL depends for values on the 1st DDL. I have written code on the SelectedIndexChanged event of 1st DDL to change values of 2nd DDL. also i have used detailsview. In the template field i have used 2 DDL mentioned above. they are having SelectedValue='<%# Bind("") %>' property. Everything works fine but when i tried to edit record in detailsview & select value from 1st DDL then it gives me following error.
Server Error in '/' Application. Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. 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.InvalidOperationException: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.
I have two comboboxes say DDL 1 : Artist , DDL 2: Albums and a Gridview containing ( album name, artist name, no.of tracks, year, etc), What I want to achieve is: when an option(artist1) in DDL1 is chosed, then the albums related to DDL1 needs to display in DDL 2 and also it must update the appropriate values in the gridview( artistname, albums(album name -no of songs, year)etc...(language: Asp.net(VB)-Sql server ).
I looked at your article regarding cascading dropdownlists and was really useful but in my case I want to use two drop down lists and a grid view.
I want to implement Cascading dropdownlist in ASP.Net GridView
View 1 RepliesI'm trying to follow this article on cascading dropdown list in a GridView control in edit mode (except I'm using C#) [URL] I keep getting this error message "ProjectID is neither a DataColumn nor a DataRelation for table DefaultView."
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if ((e.Row.RowState & DataControlRowState.Edit) == DataControlRowState.Edit)
{
DataRowView dv = (DataRowView)e.Row.DataItem;
//// Preselect correct value in Projects list
DropDownList listProjects = (DropDownList)e.Row.FindControl("DropDownList1");
listProjects.SelectedValue = dv["ProjectID"].ToString(); // *****************this is where I get the error *********
// Databind list of categories in dependent drop-down list
DropDownList listCategories = (DropDownList)e.Row.FindControl("DropDownList2");
SqlDataSource dsc = (SqlDataSource)e.Row.FindControl("sdsDDL2");
dsc.SelectParameters["ProjectName"].DefaultValue = dv["ProjectName"].ToString();
listCategories.DataBind();
listCategories.SelectedValue =(dv["CategoryID"].ToString());
}
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>" SelectCommand="SELECT
TE.TimeEntryID,
P.ProjectName,
CAT.CategoryName,
TE.TimeEntryDescription,
TE.TimeEntryDuration,
TE.TimeEntryDate
FROM dbo.aspnet_starterkits_TimeEntry TE inner join
dbo.aspnet_starterkits_ProjectCategories CAT on
TE.CategoryID=CAT.CategoryID inner join
dbo.aspnet_starterkits_Projects P on
CAT.ProjectID=P.ProjectID
Where TimeEntryUserID=(SELECT UserId FROM dbo.aspnet_Users WHERE
UserName=@UserName) AND
TE.TimeEntryDate=@WeekEnding
" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE dbo.aspnet_starterkits_TimeEntry
SET
TimeEntryDescription=@TimeEntryDescription,
TimeEntryDuration=@TimeEntryDuration,
TimeEntryDate=@TimeEntryDate
WHERE
TimeEntryID=@original_TimeEntryID">
<SelectParameters>
<asp:ControlParameter ControlID="UserList" Name="UserName"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="WeekEnding2" Name="WeekEnding"
PropertyName="Text" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="TimeEntryDescription" />
<asp:Parameter Name="TimeEntryDuration" />
<asp:Parameter Name="TimeEntryDate" />
<asp:Parameter Name="original_TimeEntryID" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" BorderWidth="0px"
BorderStyle="None" Width="100%" CellPadding="2" PageSize="25"
DataKeyNames="TimeEntryID" onrowdatabound="GridView1_RowDataBound"
onrowupdating="GridView1_RowUpdating" >
<Columns>
<%--<asp:CommandField ShowEditButton="True" />--%>
<asp:BoundField DataField="TimeEntryID" HeaderText="ID"
SortExpression="TimeEntryID" InsertVisible="False" ReadOnly="True"
ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:TemplateField HeaderText="Project" SortExpression="ProjectName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList1"
runat="server"
DataSourceID="sdsDdlProjectsEdit"
DataTextField="ProjectName"
DataValueField="ProjectID"
AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDdlProjectsEdit"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT ProjectID,ProjectName FROM dbo.aspnet_starterkits_Projects">
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("ProjectName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Category" SortExpression="CategoryName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList2"
runat="server"
DataSourceID="sdsDDL2"
DataTextField="CategoryName"
DataValueField="CategoryID">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDDL2"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT CategoryID,CategoryName FROM dbo.aspnet_starterkits_ProjectCategories WHERE ProjectID=@ProjectID">
<SelectParameters>
<asp:Parameter Name="ProjectID" />
</SelectParameters>
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:BoundField DataField="TimeEntryDescription" HeaderText="Description"
SortExpression="TimeEntryDescription" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField DataField="TimeEntryDuration" HeaderText="Hours"
SortExpression="TimeEntryDuration" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField ApplyFormatInEditMode="True" DataField="TimeEntryDate"
DataFormatString="{0:d}" HeaderText="Week Ending"
SortExpression="TimeEntryDate" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:CommandField ShowEditButton="True" HeaderText="Edit" ButtonType="Image" EditImageUrl="images/icon-edit.gif"
UpdateImageUrl="images/icon-save.gif" CancelImageUrl="images/icon-cancel.gif" />
</Columns>
</asp:GridView>
implementing cascading static dropdownlist in asp.net
View 1 Repliesi'm trying to implement a cascading dropdownlist inside a partial view.
this is the code:
[code]....
i have a table with three columns as ID,baseid,name.
[code]...
i will display all baseid 0 values in first dropdownlist1
based on the selection corresponding values will be shown in dropdownlist2 (like when desc1 is selected desc1212 &desc2323 will be shown in dropdownlist2. now i want to edit/add details to the table from aspx page.
I am having two dropdownlist in my project,one dropdownlist for empid, another dropdownlist for month, if the user select the empid, the values are retrieved in the textbox.
In the second dropdownlist, if the user select the month in the dropdownlist it will display the leave details, its all working fine, if the user again select the first dropdownlist that means empid, I want to show the second dropdownlist as select month, how can do this.....
i want to edit gridview a gridview column when the user selects particular value in the dropdownlist of gridview?
View 8 RepliesI have a grid view on my page and and i have a datasource for it,
i also included properties like edit/delete and all
Whenever i hit edit i want a dropdownlist instead of a text box ,can we do this?
I have create a grid view with a dropdownlist for one of the columns. This works fine, but when I click edit and then update I get an error saying it cant update due to null value. I'm sure it because the parameter in the update of SqlDataSource1 is not referring to the value select in the edit item template, but I cant figure out how to do this.
My code is below.
<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
ConnectionString="<%$
ConnectionStrings:BlazeBillzConnectionString %>"
SelectCommand="SELECT
[Prod_Sold_ID], [Order_Date], [Billing_Period] FROM [ProductsSoldTable] where Prod_Sold_ID < 130"
DeleteCommand="DELETE
FROM [ProductsSoldTable] WHERE [Prod_Sold_ID] = @Prod_Sold_ID"
InsertCommand="INSERT
INTO [ProductsSoldTable] ([Order_Date], [Billing_Period]) VALUES (@Order_Date, @Billing_Period)"
UpdateCommand="UPDATE
[ProductsSoldTable] SET [Order_Date] = @Order_Date, [Billing_Period] = @Billing_Period WHERE [Prod_Sold_ID] = @Prod_Sold_ID">
<DeleteParameters>
<asp:Parameter
Name="Prod_Sold_ID"
Type="Int32"
/>
</DeleteParameters>
<InsertParameters>
<asp:Parameter
Name="Order_Date"
Type="DateTime"
/>
<asp:Parameter
Name="Billing_Period"
Type="Int32"
/>
</InsertParameters>
<UpdateParameters>
<asp:Parameter
Name="Order_Date"
Type="DateTime"
/>
<asp:Parameter
Name="Billing_Period"
Type="Int32"
/>
<asp:Parameter
Name="Prod_Sold_ID"
Type="Int32"
/>
</UpdateParameters>
</asp:SqlDataSource>
</div>
<asp:GridView
ID="GridView1"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="Prod_Sold_ID"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField
DataField="Prod_Sold_ID"
HeaderText="Prod_Sold_ID"
InsertVisible="False"
ReadOnly="True"
SortExpression="Prod_Sold_ID"
/>
<asp:BoundField
DataField="Order_Date"
HeaderText="Order_Date"
SortExpression="Order_Date"
/>
<asp:TemplateField
HeaderText="Billing_Period"
SortExpression="Billing_Period">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList2"
runat="server"
DataSourceID="SqlDataSource5"
DataTextField="Discription"
DataValueField="Bill_Per_Id"
Height="17px"
Width="134px">
</asp:DropDownList>
<asp:SqlDataSource
ID="SqlDataSource5"
runat="server"
ConnectionString="<%$
ConnectionStrings:BlazeBillzConnectionString %>"
SelectCommand="SELECT
[Bill_Per_Id], [Discription] FROM [Billing_Periods]">
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:DropDownList
ID="DropDownList1"
runat="server"
DataSourceID="SqlDataSource2"
DataTextField="Discription"
DataValueField="Bill_Per_Id"
Height="19px"
SelectedValue='<%#
Bind("Billing_Period") %>'
Width="171px">
</asp:DropDownList>
<asp:SqlDataSource
ID="SqlDataSource2"
runat="server"
ConnectionString="<%$
ConnectionStrings:BlazeBillzConnectionString %>"
SelectCommand="SELECT
[Bill_Per_Id], [Discription] FROM [Billing_Periods]">
</asp:SqlDataSource>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField
ShowEditButton="True"
/>
</Columns>
</asp:GridView>
I have created a Gridview (using ObjectDataSource) for Edit/Updates. I am getting an error on my DropDownList which is configured with the list items Yes and No only for both text and values.
Most of my data in my SQL table has values of either Yes or No, however there are some records that are BLANK or even NULL sometime.These rows fail in my GridView when attempting to Edit.
I tried going into the DDL Edit List items and adding a Blank with and empty value however each time i try to save the page VWD removes it.
How do i account for reverse lookups of all possible values Yes/No/Blank or Empty/NULL in my DDL?
I read your article on ASPSnippets and everything worked great. I am having one problem and this is preventing me from moving forward. When I select the edit for a row (I only have two columns), the drop down comes back blank (no records). I have looked at the code multiple times and can't see where I made a mistake. is it possible to control the width of the drop down list? I can't tell if the column automatically adjusts because I am not returning any records.
using System;
using System.Collections.Generic;
using System.Linq;
[Code].....
I have gridview that has month as a column. When the user clicks a row's edit button, that row goes into edit mode. I have created a drop-down list for month in edit mode with the values 1-12. Right now, the drop-down list shows 1. I would like it to show the current value for that row. How do I do this? Here's the code for my gridview:
[Code]....
Here's some applicable code from the code behind:
[Code]....
I have the following code in a GridView...
[Code]....
I am trying to bind dropdownlist in Gridview under EditItemTemplate under RowBound event. But it gives me blank rows in the drop down list.Here is my Design
<asp:TemplateField HeaderText="Description">
<ItemTemplate>
<asp:Label ID="lblDescription" runat="server" Text='<%# Bind("Description") %>' Width="400px"></asp:Label></ItemTemplate>
[code]....
I see the dropdown but the dropdown is blank, but there are rows in the database for this column and in the footer row it is working fine.
I've got 3 SqlDataSource controls, and 2 dropdownlists and 1 detailsview on a page. The first SqlDataSource is associated with the first dropdownlist, and second SqlDataSource (which is filtered based upon the selection chosen in the first dropdownlist) is associated with the second dropdownlist and the third SqlDataSource (which is filtered both by the selection of the first dropdownlist and the second dropdownlist) is associated with the detailsview. The idea is the user selects something in the first dropdownlist, and it is supposed to update what is returned by the second SqlDataSource control and second dropdownlist, and that in turn is supposed to change what is returned in the third SqlDataSource control and it's associated detailsview. All of the dropdownlists have AutoPostback set to True.
View 11 RepliesI have a problem with my dropdownlist on edit he doesn't want to add any of his parameters to the update. I tried controlparameter and normall parameter both didn't work The folowing I have: Dropdownlist with Datasource: I Have a gridview with templatefields: I have the following asp.net code:
[Code]....
I have the following Business Layer where it connects to:
[Code]....
I created 3 category table. categry1,categry2,categry3. product table.
And then use of gried view add ,edit ,update ,delete product . in product table.
In gridview retrive data from product table . i select categry from dropdownlist in gridview categry1, categry2, categry3 and save update dropdown list category value dynamically in product table. not define value static in source code.
When select category 1 change on selected index change categary 2 or 3.
In my code I used text box to ediit update delete. but here i will use dropdownlist.
This is my first post on this forum. I have a Gridview with the following Columns
1. Edit Column
2. User_ID (Read Only)
3. Email (Read Only)
4. Role ( A Dropdownlist with 2 list Items namely "Admin" & "QA Lead")
I have used wizard to populate a "Gridview" and the embedded "Dropdownlist" control in it. This is my reference: [URL] My Problem: The Data populates perfectly in Grid and Dropdownlist. But, when I Press "Edit" button the Dropdownlist goes into edit mode in the form of a "Texbox". (i dont want this) I still want it to be an editable dropdownlist.
I have a dropdown list inside a gridview:
[Code]....
I have a Gridview showing the MemberLastName, MemberFirstName, MemberBirthYear, MemberGender, MemberRelationship.
During Edit mode, I have managed to display a DropDownList for the Relationships.What I am trying to achieve now, is that, based on the Gender of the member I would like to limit the items in the Relationships dropdownlist.
e.g if the Gender is Male, then only display Male Relationships
What is the best way to achieve this scenario?Here is my snippet of code for the event. The code is commented out as it throws an exception.
[Code]....