Forms Data Controls :: Cascading Dropdown List In A GridView Control In Edit Mode Error
Aug 11, 2010
I'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>
View 3 Replies
Similar Messages:
Jan 10, 2011
I have a Members table with the following fields: LastName, FirstName, Address, CityID, ProvinceID, PostalCode.
I have added another field for the MemberTitleID.
During the Gridview Edit mode, I am trying to enable setting the MemberTitle using a drop-down list as shown below:
[Code]....
When I added the new field MemberTitleID in the Members Table, all of them were left un-initialized.
Here is the error I get when I click the edit button on the grid view :
[Code]....
[Code]....
View 1 Replies
Jun 16, 2010
I have a dropdown list in the edittemplate of a gridview and now it selects the first value that comes from the datasource. How can I get it to select it's original value? Where do I put the code?
View 9 Replies
Apr 16, 2010
I have packed the access 2007 project management database and moved it to SQL Server. I'm aware that SQL doesn't populate dropdown lists for the Status and completion Percentage columns. I have to have this done by April 21 and my professor is just now telling me he won't accept the textbox inputs due to data integrity and I don't have time to rebuild this entire site.
View 3 Replies
Jan 27, 2011
Using C# and sql server. I have a gridview which is populated using a sql query. I have 5 columns in the gridview ( projectid,project name,description,date,status). I'm using the Edit/update option that is available in the gridview to edit/update a user selected row. When I use this Text boxes appear. I want to have a drop down list for status instead of a text box with values Started,Inprocess,Complete, Inhold.
View 3 Replies
May 1, 2010
I have a gridview with edit functionality and using the EditItemTemplate section. I am trying to set focus to a textbox when user selects the edit mode.
[Code].....
View 6 Replies
Jun 17, 2010
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.
View 6 Replies
Aug 10, 2010
I have a DateTime Field in the database that only has the the date the time is all zeroes for each entry.
I have a gridview that displays the date only excep it edit mode. When the grid is in edit mode it also shows all the zeros for the the time. Is there way to not show the time in edit mode?
View 4 Replies
Feb 2, 2010
I have a problem where I have 4 dropdown lists which are populated from 1 drop down list depending on its value. The problem I have is that when the form is in edit mode the value for dropdown 1 is visible but when I click on dropdown 2 (or others) they appear to be unfiltered. However if I change the value in dropdown list 1 it will then filter dropdown 2 correctly. Am I missing something perhaps in the form load event. My code is currently in dropdown 1's selectedindexchanged and formview_databound if formview is in edit mode. Autopostback is true for all dropdown lists.
View 8 Replies
Mar 30, 2010
I have a grid view with edit and save buttons when I click on edit it is letting me edit it and if I click on save it is lettingme save the data that I have edited.
The thing is after save is done it is showing the data in edit mode i.e <edit item template > mode I am still seeing the textboxes if I refresh the page then I am seeing it normally.
How can I stop the gridview to show edit mode after the save is done?
View 4 Replies
Dec 4, 2010
- I want to put multiple rows of a gridview into edit mode
- I have not found any easy method to accomplish this task. I found a way to programmatically put a gridview into edit mode, but in testing the code below it works for only 1 row at a time :
[Code]....
View 5 Replies
Dec 17, 2011
I have a gridview with footer template which has dropdownlists.. I am populating these dropdownlists at row_created event of gridview..
When i want to update any record and when user clicks edit in the gridview i must get the dropdownlists and the values which were already selected previously for that particular item .. How to do this?
In the row data bound event i get all the dropdownlists populated but they are not the one which was selected. How to display values in dropdownlist which was already selected earlier?
View 1 Replies
Aug 18, 2010
How do I change these hyperlinks to say something other then Edit and Cancel?
View 4 Replies
Jun 9, 2010
I am attempting to use a CustomValidator control to validate a FileUpload control that is present in my Gridview's EditItemTemplate
[Code]....
I'm not calling the FileUpload control correctly, because I am getting the "Object reference..." error
View 9 Replies
Oct 11, 2010
i have a dropdown list in edit mode and read only mode. If users upload pictures, i want them to chose a category for the uploaded pics and display it in a gridview as below.(See Picture below). When i include "SelectedValue='<%# Bind("CategoryID")" in edit and item template mode, i get this error "'PictureReadOnlyCategories' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value "
When i removed the "SelectedValue='<%# Bind("CategoryID")" from edit and item template, i get the result on the pic below(screenshot). If u can see the pic below the category is not selected, it just display the -- No Category -- even when i chose a category for the pic. I want when a pic is uploaded and i category chosen, to display on the gridview. The code for the error message is below:
<EditItemTemplate>
<asp:DropDownList ID="pictureEditCategories" runat="server"
AppendDataBoundItems="True"
DataSourceID="categoriesDataSource"
DataTextField="Name" DataValueField="CategoryID"
SelectedValue='<%# Bind("CategoryID")
%>' ValidationGroup="PictureEdit" >
<asp:ListItem Value=""
Text="--No Category -- "/>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:DropDownList ID="PictureReadOnlyCategories" runat="server"
AppendDataBoundItems="True" DataSourceID="categoriesDataSource"
DataTextField="Name" DataValueField="CategoryID" Enabled="False"
SelectedValue='<%# Bind("CategoryID")
%>' ValidationGroup="PictureEdit"
>
<asp:ListItem Value="">-- No Category --</asp:ListItem>
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Title"
SortExpression="Title">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" EnableViewState="False"
Text='<%# Bind("Title") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4"
runat="server"
ControlToValidate="TextBox1"
Display="Dynamic"
ErrorMessage="must enter a title"
ValidationGroup="PictureEdit"></asp:RequiredFieldValidator>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("Title")
%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Description"
SortExpression="Description">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Columns="25" Rows="4"
Text='<%# Bind("Description")
%>' TextMode="MultiLine"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator5"
runat="server"
ControlToValidate="TextBox2"
Display="Dynamic"
ErrorMessage="you must enter a description"
ValidationGroup="PictureEdit"></asp:RequiredFieldValidator>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("Description")
%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Date Added"
SortExpression="UploadedOn">
<EditItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%# Bind("UploadedOn")
%>'></asp:Label>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("UploadedOn")
%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:ImageField DataImageUrlField="PictureID"
DataImageUrlFormatString="~/UploadedImages/{0}.jpg"
HeaderText="Image"
ReadOnly="True">
<ControlStyle Width="100px"
/>
</asp:ImageField>
</Columns>
<EditRowStyle BackColor="#2461BF"
/>
<FooterStyle BackColor="#507CD1"
Font-Bold="True" ForeColor="White"
/>
<HeaderStyle BackColor="#507CD1"
Font-Bold="True" ForeColor="White"
/>
<PagerStyle BackColor="#2461BF"
ForeColor="White" HorizontalAlign="Center"
/>
<RowStyle BackColor="#EFF3FB"
/>
<SelectedRowStyle BackColor="#D1DDF1"
Font-Bold="True" ForeColor="#333333"
/>
<SortedAscendingCellStyle BackColor="#F5F7FB"
/>
<SortedAscendingHeaderStyle BackColor="#6D95E1"
/>
<SortedDescendingCellStyle BackColor="#E9EBEF"
/>
<SortedDescendingHeaderStyle BackColor="#4870BE"
/>
</asp:GridView>
View 1 Replies
Feb 7, 2011
I am using a dropdownlist inside Edit template of a formview,, the problem it is not saving the value ,, Here is my code : I am only updating the (status)
[Code]....
View 1 Replies
Aug 24, 2010
I wanted to populate the dropdown list when selecting the edit button based on the officeid from the gridview.
My code:
<
asp:GridView
ID="gridassignserv"
runat="server"
[Code]....
View 2 Replies
Jul 19, 2010
How can I set a particular row into edit mode in code? Like when the Grid loads up I need the last row to be in Edit mode.
View 3 Replies
Jan 7, 2010
I am using gridview for my application, in the grid i am using dropdown list for two columns ,It's working when i run my application but when i am edit application ddl can't show the editable data ( it show only select).And one more thing that two columns are interrelated , one ddl(Itemgroup) is connected with(ItemName).
View 2 Replies
Apr 29, 2010
I have a basic list view, in the edit mode I have a dropdown list, and a checkbox, I want it so that if you choose "yes" from the drop down box the check boxs becomes enabled. I know I need to find the control but I keep getting object refrence error with this code.
[Code]....
the listview renders its layout / item template fine but when I click on edit to send it to edit mode it fails to find the dropdownlist ddlQA1YNM which is a bit ironic cause its the ddlQA1YNM that is making the call to ddlQA1YNM_ondatabound. Now it could be with the fact its on the databound stage. Not sure how that plays into the stack. I call ondatabound to determine what the dropdownlist value is and set the enabled status according on the load into edit mode.
View 6 Replies
Oct 21, 2010
I have a gridview and a template column:
<asp:TemplateField HeaderText="Active">
<EditItemTemplate>
<asp:CheckBox ID="chkbxActive" runat="server" Checked ='<%# Bind("Active") %>' />
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblActive" runat="server" Text='<%# Bind("Active") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
The item "Active" is a bit from the database And for the RowDataBound:
Const HeavyCheckMark As Char = ChrW(&H2714)
For Each row As GridViewRow In gvProductCodes.Rows
If gvProductCodes.EditIndex = -1 Then
' Selects the text from the Label which is inside the GridView control
Dim lblActive As String = CType(row.FindControl("lblActive"), Label).Text
lblActive = lblActive.Replace("True", HeavyCheckMark)
lblActive = lblActive.Replace("False", "")
'Replaces the text in each Label control
CType(row.FindControl("lblActive"), Label).Text = lblActive
Else
Dim chkbx As CheckBox = CType(row.FindControl("chkbxActive"), CheckBox)
End If
The check mark works fine when not in edit mode. But when in edit mode, the row that is being edited works as expected. But the other rows now show True or False. I want them to have the const HeavyCheckMark in it instead.
View 3 Replies
Jun 9, 2010
I have a dynamically built gridview in which every row in editing mode has 2 dropDownLists, i set autoPostBack property of first list to true in order to change the other list values according to the first, but upon postBack, the gridview is not in edit mode any more.
View 7 Replies
Feb 2, 2010
I have a webform with two gridviews; a textbox for the invoice number, and a button to kick everything into action. I programmatically handle the select statements in the VB.Net file because I need to iterate through the second gridview's table to perform calculations and then put those results into the first gridview's table. Then I bind them. It works just fine.
The first gridview has one row with the payment information. The second gridview has multiple rows with the items that the payment is handling.Now I need to handle the edit, update and cancel functionality. I tried using a sqlDataSource for edit, update and cancel because it is simple, but it requires a Select statement so I guess that idea is not going to happen. I put a commandField with showeditfield=true, but clicking edit gives an error that rowEdit isn't handled. I have put that sub gvInvoice_RowEditing in there, but being new at this I have no idea what to put into that sub.
I can programmatically create all that functionality in the code behind. Won't it be quicker and easier if I write sub's for Edit, Update and Cancel that tell the gridview what to do - trick it to automatically handle all that? Is there an example available demonstrating how to tell the gridview to go into edit mode and proceed as if it was using a sqlDataSource?As a final note: perhaps it would be simpler if I create a third gridview to handle the job of totaling all the cash and listing each check seperately.Here is my code. It probably isn't the most elegant approach, but it works.
[Code]....
View 1 Replies
Feb 2, 2010
I have a gridview placed on the Panel(Scrollbars set to Both).
If I click on Edit button of the gridview for example Row number 100 then the focus of the page goes to the top of page and I always scroll down to the particular record to make changes.
View 9 Replies
Oct 13, 2010
I have a grid view. When I click edit, the OnRowCommand fires and the row goes into edit state. Label becomes a TextBox. I then attempt to alter this value in some way and click update. This again fires the OnRowCommand event. The problem is, when I attempt to capture the new value, it instead just shows the original value.In my grid view I have:
<asp:TemplateField
HeaderText="Start Name">
<ItemTemplate>
<asp:Label
ID="lblStartName"
runat="server"
Text='<%#Bind("StartName")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox
ID="txtStartName"
runat="server"
Text='<%#Bind("StartName") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
In my code behinde i have
TextBox
textBox = (TextBox)row.Cells[4].FindControl("txtStartName");
View 4 Replies