I have a gridview that has an edit button. I want to have dropdownlists in the edit template, which I have. I cannot get the dropdowns into the update sql. Is that done with code behind or is there another way to do it?
[Code]....
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
[Code]....
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 RepliesI 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]....
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 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>
I have a set of dataset with different column retrieved from DB. I need to present the datasets in one GridView (or other ListView etc...) without specifying the column_header. It should present automaticly since the GridView is bind to the DataSet.
In additional, I want this GridView to handle multiple rows edit and update the dataset, idealy, show data in textboxs in initially.How could I set the GridView to edit_model without hardcode column_header and textboxs in 'itemtemplate' or filed.
How could I achieve the bulk edit and update, so that I can assign 'mydataview1.table' to the dataset.
How can I Edit and update record in Gridview using viserd..
in asp.net c#
I have a gridview and am using the Edit - Update function to update one field in my gridview. I have the textbox appearing as I want it and am able to update the data for that cell.
The problem I have is refreshing the gridview after the update. The Update and cancel are still shown instead of the gridview refreshing back to the Edit statement after the update.
I have a drop down list inside my dropdown edit template and want the select value to get updated on user Updatebutton.
Now the problem is i am able to get the selected value from dropdown under RowUpdating event but unable to set it to e.newvalue .
Just to let you know i am permorming Trim operation on alias created for that specific field bound to dropdown.
My code is :
[Code]....
Can't tell what is wrong here . It worked fine and I didn't did anything special in code-behind
I don't see any error just the same data in gridview
[Code]....
Using the pubs database, my GridView groups titles by publisher. Everything displays correctly; I just can't edit anything. I click on "Edit" an the Textboxes don't appear. What am I doing wrong? Should my FillGrid() function be returning all the records or just the ones from that particular publisher group? Here is my .aspx code:
[Code]....
...and here is my code behind:
[Code]....
I want to set up a gridview that will display data like this
[Code]....
and that allows editing. Is it possible to have multiple update statements when editing from he gridview? Each day will need a separate update state since the data will be stored in the database like this
[Code]....
I think for each row I would need 7 update statements - one for each day. Is this possible with the gridview edit button?
How to do bulk edit/update with checkboxes in GridView control where in the selection of editting a row needs to have some info brought from db for validation on update?
View 10 Repliesmy gridview doesn't return to readonly mode after an update. i have set the editindex to -1did the databind() for the gridview too. but nothing works.setting keepineditmode to false doesn't work either.he documentation says that the gridview automatically returns to readonly after pressing the update button.my gridview is on a panel, and that panel is on an update panel.
View 6 RepliesI want to Add, edit, delete and update the records using gridview with validations.
I am not using any default datasources like sqldatasource or accessdatasource.
Want to do it in code behind.
Validations should be used as if some one try to update the value as blank or do not enter characters/numbers like that.
I have a gridview that pulls data from two tables, CLIENT and PAYMENT. I want to add the edit, delete functions to the gridview for the payment portion of the table, that is to edit or delete the payments but not the client. I've manually enabled the edit, delete functions and input the queries. I've also deleted the textboxes from the templates which draw from the CLIENT table so they cannot be edited. Everything looks good on the surface until I actually go to edit or delete anything, and it has no effect.Here's the structure of the two tables:
CLIENT PAYMENT
ClientID Pk PaymentNumber Pk
FName CLIENT$ClientID Fk
LName PaymentDate
ContactNo NULL PaymentAmount
ArrivalDate PaymentDetails NULL
DepartureDate NULL
CurrentResident
Here's the update query:
UPDATE [PAYMENT] SET [PaymentDate] = @PaymentDate, [PaymentAmount] = @PaymentAmount, [PaymentDetails] = @PaymentDetails WHERE [PaymentNumber] = @original_PaymentNumber AND [CLIENT$ClientID] = @original_CLIENT$ClientID AND [PaymentDate] = @original_PaymentDate
AND [PaymentAmount] = @original_PaymentAmount AND (([PaymentDetails] = @original_PaymentDetails) OR ([PaymentDetails] IS NULL AND @original_PaymentDetails IS NULL))
Finally, here's the delete query:
DELETE FROM [PAYMENT] WHERE [PaymentNumber] = @original_PaymentNumber AND [CLIENT$ClientID] = @original_CLIENT$ClientID AND [PaymentDate] = @original_PaymentDate AND [PaymentAmount] = @original_PaymentAmount AND (([PaymentDetails] = @original_PaymentDetails)
OR ([PaymentDetails] IS NULL AND @original_PaymentDetails IS NULL))
I want to know how to Edit and Update data from gridview. I have a gridview that generate data from a sqlcommand.Then I want to update the data directly from the gridview, I added the manually the Edit,Update,Cancel manually from the Command Field.How to Edit and Update the data directly from the selected row in the Gridview?
View 2 RepliesIm a newbie, hoping any experts can lend a hand. I have a gridview table connected to an SQL database. I have auto generated the update and delete methods to allow me to edit the gridview.
However, I would like the editable data in the gridview to be replaced by a selectable drop-down box. The drop down box is referencing an sql table for selection.
how to edit data in grid view manually without auto generate in gridview + ajax.
View 4 Repliesi made this: when i try to upgrade some data it says me:
View 6 RepliesHow can we edit update gridview data in gridview using stored procedure asp.net c#
View 2 Replies[Code]....
all of a sudden my GridView has stopped firing the row update event. Friday I was working on it and was working flawlessly. Now I haven't made any changes to the code and all of a suddent has stopped working (yes rediculously bizarre and have been banging my head all day thinking what the something is wrong with it, excuse my french).
Everyone of those events fire except the update. I click the update button and nothing happens.
In my Girdview, I set: AutoGenerateDeleteButton="True" , and AutoGenerateEditButton="True".
The Buttons show at the first column of the gridview, how can move them to the last column?