Forms Data Controls :: Dropdown List In Gridview - Selected Index While Saving The Record
Oct 22, 2010
I am developing page for maintaing employee record using Visual Studio 2008, MS SQL server 2005. I am able to fetch and display all the employee information in gridview, the gridview have the dropdown list to display the employee type [ Part Time, Full Time, Permanent , Contract ], in the item template i am having dropdown list. IN the dropdown list i am displaying this. But While saving the record in gridview the droppdown selected index are changed to 0 of other dropdown list.
the user may be change the dropdown value from permanent to contract, or so. but while click on the save button in gridview, all the previous selection are gone, and always showing the first record of dropdown list. I know this is happening because we are doing dropdown list bind on onRowDataBound.
I have a details view control which contains a dropdown list.
I would like to update a row in the DV based on when the selected index change event occurs in another row of the
So far I know that 1) Place code in detailsview1.rowupdating event .
2) Make a row copy, not sure about the syntax here
Dim aRow As DetailsViewRow = Me.DetailsView1.Rows(DetailsView1.Rows.Item(?)) 3) Find my DDL Dim aDDL as dropdownlist = CType(aDDL.cells(?).Findcontrol("Dropdownlist3"0, dropdownlist) If aDLL.selected IndexChanged then Dim aTextbox as textbox = Ctype(detaislview.cells(?).findcontrol("Textbox6", textbox6) aTextbox.text = now()
In the following code i want to save the value selected by user from drop downlist into database. but whatever value is selected by user, first value of dropdown lsit is saved to database
View <% =Html.DropDownList("lstUsertype", (SelectList)ViewData["UserTypeID"])%> Controller public ActionResult CreateUser() { UmUser _UmUser = new UmUser(); UMRepository _UMRepository = new UMRepository(); EvoLetDataContext db = new EvoLetDataContext(); ViewData["UserTypeID"] = new SelectList(_UMRepository.FillUserTypes(), "UserTypeID", "UserType",2); return View(_UmUser); } [AcceptVerbs(HttpVerbs.Post)] public ActionResult CreateUser(UmUser _umUser) { //try //{ if (ModelState.IsValid) { //try //{ UserRepository _UserRepository = new UserRepository(); _UserRepository.Add(_umUser); _UserRepository.Save(); return RedirectToAction("Details", new { id = _umUser.UserID }); /*} catch { ModelState.AddModelErrors(_umUser.GetRuleViolations()); }*/ } return View(); //} /*catch { return View(); }*/ }
We are developing our application on a 64 bit server. We are using a dropdownlist to filter and display departments in a htmltable(hide and show rows) on every selectedindexchanged event.
The issue is it is firing properly for the first time, but it is not doing a post back there after. We have even given autopostback=true. We are using AJAX for hiding and showing the rows of the htmltable.
create List of dynamic asp:Label, asp:textbox and asp:button when asp:dropdown selected index changed Dropdown List - ddlLang - English, Italian, French, German
If English is selected from ddlLang Create new asp:Label, asp:textbox and asp:button. If French is selected create another new asp:Label, asp:textbox and asp:button. In the same way so on.... and when button submit clicked get all dynamic text box values and label values to Save to DB.
i have design a web application having suppliers table using SqlDatasource..
i have a master page in my design and other form are bound to a context menu..
Now i have displayed the records in the gridview..all i wanted is after i select a record in the gridview it will display the selected record in detailview from another aspx form..
i was able to create the link to another aspx form but the data that it display is the first data from the gridview not the data that i select.
i have a drop down list and a text box, inside a listview row (and this is a repeating layout). i populate each dropdownlist with same contents ( these contents/items come from a custom collection object).
i have added a required field validator in the listview's item template, that has its validation group = the validation group of the drop down list, and validates if the textbox is blank or not. this validation takes place on the selected index changed of the drop downlist for that row.
1. on selected index changed, EACH dropdownlist validates only its corressponding textbox perfectly (which is what i want)
but if i enter some text in one of the textboxes after doing 1, the dropdownlist for THAT particular row, assigns the correct value to the text entered. but for other rows (for which i changed their corresponding ddls to test the required field validation and for which the text boxes are still blank), their ddls by itself assign the values to the blank text without validating.
markup of code for listview is [Code]....
code behind for the ddl selected index changed is [Code]....
method GetIndexFromId retrieves index of the custom object inside a collection depending on the Id (which is a property) of the object.
i notice that the ddl selectedindexchanged is being hit as many number of times as many rows i change (i.e as many ddls in different rows i change to check the required field validation)
I have a small problem with drop down list. I have a aspx page which shows the information of a customer and there is an Edit button, which will take the customer to the edit information page. On the edit information page, I have drop down lists and I want the selected value in the drop down list to have the current value of the current customer on Page Load event.
For every search result I create a dropdown list with 2 month booking overview.
<ddl> <item value = "1"> January - February </item> <item value = "2"> February - March </item>
etc.
Then I call function to generate 2 months calendar view, which has two parameters generate(startmonth as Integer, sku as string)
Everything works when I hardcode starmonth as some integer.
I spent all day with no progress on how to pass value. I need a guide. I guess second problem will be to restore changed dropdown values on Postback, but one step at a time.
But what I want to do, to pass selected item value, to function, that would change view for property associated with this dropdown.
I need to feach the selected value of a dropdown list which is in gridview at gridview_RowUpdating event.this is the way I have done that, but it is not working can sombody guide me to do this.DropDownList itemCode = gvTest.Rows[e.RowIndex].Cells[0].FindControl("itemCode") as DropDownList; if (itemCode != null) { Session["itemCode"] = itemCode.SelectedValue.Trim(); }
I have a gridview. .When I add new data to gridview, I want to change gridview selectex index dynamically. I want to set gridview selectedindex the new added data .
i know how to find the index of selected row in asp gridview , but i need to find the index of selected column in asp gridview ?for ex:i have i gridview contains columns with header ( the header is the primary key i looking for ) , this grid contain linkbutton , i want to get the column header name on click on linkbutton ?
I have Gridview1 that brings up the columns Resorts, Seasons, Seasons_ID, Resorts_ID, and User_ID
The three ID's are all foreign keys from related tables, and they are together a combined primary key of the table being accessed (they were defined that way to prevent duplicate entries for any User/Resort/Season combination).
Now the problem: I want to use the selected row from that gridview in the WHERE clause of a SQLDatasource by setting the WHERE clause up like:
WHERE (([Resort_ID] = @Resort_ID) AND ([Season_ID] = @Season_ID) AND ([User_ID] = @User_ID)) , with the parameters each coming from statements like
Gridview1.SelectedValue
When I select a row in the Gridview, I get the following error:
Operand type clash: uniqueidentifier is incompatible with int
I am pretty sure this has to do with the User_ID being in the WHERE clause.
So I have tried something like this to access the selected index:
Gridview1.DataKeys(Gridview1.SelectedIndex).Value
This does not work, as it seems to return only the first key (of three) in the DataKeyNames list.
So the question: How can I use the SelectedIndex of that gridview for such a purpose when the key contains a UserID?
I have a gridview where I am opening a popup page when user selects a row. If I am not using update panel then Select button is able to open popup page.
If I am adding Update panel, the popup page is unable to open. What could be the cause?
I am stuck at this point "Displaying a dropdown list of Categories with a --None -- Option. I want the gridview control to display 2 dropdown list one in read-only mode and the other in edit mode. When a record is in read-only mode, the dropdownlist's enabled property will be set to false."When it's on a read-only mode, it doesn't display the selected Category. it shows but the "No Category". When i click on edit to edit or change category, it doesn't display the selected category.
The example is given below( I am reading the book Sams Teach yourself ASP.NET 2.0 by Scott Mitchell. page 628)
<asp:Label ID="UserIdValue" runat="server" Visible="False"></asp:Label> <asp:SqlDataSource ID="picturesDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Pictures] WHERE ([UserId] = @UserId) ORDER BY [UploadedOn] DESC" DeleteCommand="DELETE FROM [Pictures] WHERE [PictureID] = @PictureID" InsertCommand="INSERT INTO [Pictures] ([UserId], [CategoryID], [Title], [Description], [UploadedOn]) VALUES (@UserId, @CategoryID, @Title, @Description, @UploadedOn)" UpdateCommand="UPDATE [Pictures] SET [UserId] = @UserId, [CategoryID] = @CategoryID, [Title] = @Title, [Description] = @Description, [UploadedOn] = @UploadedOn WHERE [PictureID] = @PictureID"> <DeleteParameters> <asp:Parameter Name="PictureID" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="UserId" /> <asp:Parameter Name="CategoryID" Type="Int32" /> <asp:Parameter Name="Title" Type="String" /> <asp:Parameter Name="Description" Type="String" /> <asp:Parameter Name="UploadedOn" Type="DateTime" /> </InsertParameters> <SelectParameters> <asp:ControlParameter ControlID="UserIdValue" Name="UserId" PropertyName="Text"/> </SelectParameters> <UpdateParameters> <asp:Parameter Name="UserId"/> <asp:Parameter Name="CategoryID" Type="Int32" /> <asp:Parameter Name="Title" Type="String" /> <asp:Parameter Name="Description" Type="String" /> <asp:Parameter Name="UploadedOn" Type="DateTime" /> <asp:Parameter Name="PictureID" Type="Int32" /> </UpdateParameters> </asp:SqlDataSource> <br /> <asp:SqlDataSource ID="categoriesDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId)"> <SelectParameters> <asp:ControlParameter ControlID="UserIdValue" Name="UserId" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> <br /> <asp:SqlDataSource ID="maxPictureIDDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT MAX(PictureID) FROM Pictures WHERE UserId = @UserId"> <SelectParameters> <asp:ControlParameter ControlID="UserIdValue" Name="UserId" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> <br /> <asp:Label ID="cannotUploadImageMessage" runat="server" Text="The photo could not be added to your album either because you did not specify a file to upload or the file specified was not a JPEG image with the file extension .JPG"></asp:Label> <br /> <asp:DetailsView ID="dvPictureInsert" runat="server" DataSourceID="PicturesDataSource" Height="50px" Width="125px" AutoGenerateRows="False" CellPadding="4" DataKeyNames="PictureID" DefaultMode="Insert" ForeColor="#333333" GridLines="None"> <AlternatingRowStyle BackColor="White" /> <CommandRowStyle BackColor="#D1DDF1" Font-Bold="True" /> <EditRowStyle BackColor="#2461BF" /> <FieldHeaderStyle BackColor="#DEE8F5" Font-Bold="True" /> <Fields> <asp:TemplateField HeaderText="Picture"> <InsertItemTemplate> <asp:FileUpload ID="imageUpload" runat="server" /> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="imageUpload" Display="Dynamic" ErrorMessage="There was no file selected" ValidationGroup="PictureAdd"></asp:RequiredFieldValidator> </InsertItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Category" SortExpression="CategoryID"> <EditItemTemplate> <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("CategoryID") %>'></asp:TextBox> </EditItemTemplate> <InsertItemTemplate> <asp:DropDownList ID="pictureCategory" DataSourceID="categoriesDataSource" runat="server" DataTextField="Name" DataValueField="CategoryID" SelectedValue='<%# Bind("CategoryID") %>' Visible='<%# Bind("CategoryID") %>' AppendDataBoundItems="True"> <asp:ListItem Selected="True" Value="">-- Select Category --</asp:ListItem> </asp:DropDownList> </InsertItemTemplate> <ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryID") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Title" SortExpression="Title"> <EditItemTemplate> <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox> </EditItemTemplate> <InsertItemTemplate> <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Title") %>'></asp:TextBox> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1" Display="Dynamic" ErrorMessage="you must provide a name for the title" ValidationGroup="PictureAdd"></asp:RequiredFieldValidator> </InsertItemTemplate> <ItemTemplate> <asp:Label ID="Label2" runat="server" Text='<%# Bind("Title") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Description" SortExpression="Description"> <EditItemTemplate> <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("Description") %>'></asp:TextBox> </EditItemTemplate> <InsertItemTemplate> <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Description") %>'
I have got a test page setup trying to figure out and learn how to nest gridview.. i finally have a working configuration,but my issue now is that if i select a record from my gridview,the nested gridview opens as expected.But when i select another record from the list in the parent gridview the first selection i made stays open and as i pick more and more, all the nested gridviews stay open.Is there something i can do within my
GridView1_SelectedIndexChanging event to hide the previous gridview and display only the selected row gridview?
I have a gridview with dropdown boxes. As soon as the complete gridview is databound, I want to loop through ALL the rows and set the values of the dropdown boxe in a row based on the value of another column in the same row. The gridview is databound, all data shows up. The condition "If ddl.Items(j).Value = searchstring Then" evaluates as true, but somehow the selected item in the dropdownbox is NOT changed and remains "<ignore>"
