Forms Data Controls :: Binding Dropdown List Using Dataset Or Datareader?
Jan 25, 2011
- i have two drop down lists- ddl_SelectClient, ddl_SelectApplication
- when a client is selected in ddl_SelectClient, i have to show the list of the clients applications in ddl_SelectApplication
- i have written the below code in the ddl_SelectClient_SelectedIndexChanged routine to do the same
- i am getting the error("Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack") in the catch block when the ddl_SelectApplication gets binded
I want to bind data from database to Dynamic Grid-view Control with textbox and dropdown using dataset.
I have successfully inserted data to database using this code but now i want to fetch inserted data to same grud view control. i have tried following code. but not getting ans.
SetInitialRow(); string ID = 101; foreach (GridViewRow row in Gridview2.Rows) { string str1 = "Select * from VendorInvoiceDetails where Invoice_ID='" + ID + "'"; DataSet ds1 = GEN.GetDataByQuery(str1);
one drop down list cointains all country list ,when we select thet particular country the other drop down list has to show all the states in that country ,this is what i am thinking to do ,can some one guide me how to do ,and give you give some reference links
I know how to bind a simple objects to a dropdown list. However I am having problems binding my objects which contains sub objects to the control.i.e. with simple object i just do ddl.DataValueField = "myproperty" with my objects they contains sub objects which i want to bind. I have tried ddl.DataValueField = "sub-object.myproperty" which doesnt work.
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'm having a method that exports content from the database to excel files. The method taks as paramaters a DataReader param and a int param - the number of rows. For the number of rows i'm using a dataset, wich i fill using the same query as for the datareader. So I'm executing it twice... Is there a way I can avoid that? get the number of rows from the datareader?
We are in the process of migrating our current asp.net gridviews to silverlight grids. The challenge that I am facing here is that in the gridview, the grid is bind to a dataset/datatable. But in silverlight, I do not have dataset/datatable available in the silverlight class. So only option is to create a Webservice and convert the dataset that I am currently getting from business layer to a class that imlements IList<> (unless there are any other ways). Now to convert this dataset to Ilist, I have to loop through the dataset to load the List. In my current dataset I have almost 10,000 records or even more in some cases. So the response time will be really slow.Are there anyways to
1) Load the List from dataset directly without looping through ?
2) Fetch the data from database directly to a List without having loading the dataset ?
i have this xml file which i read using the DataSet.ReadXml( path ) method . The tables created from the Xml file is Related in such a maner that each product has many options. Product is in one table and Options are in another.Now all i want to do is display the related tables in One Gridview. For your reference below is the products Xml file,
[Code]....
Now this is what i have done in the Code behind , have a look below
[Code]....
Now the Grid works Great if i want to Display Individual tables out from Dataset but not when they are related . Please do shine your Knowledge on what should be done to display Child ~ Master relationship. By the way , its a definite NO for someone who would show me that link from msdn about displaying XML data using Xmldatasource and gridview [That's a lousy way to display data]
I have a databound dropdownlist and have a problem with the default value it selects.When I attempt to edit a record the dropdownlist shows the first value in the list rather than the current value. I want the dropdown list to display the current value.
I'm sure this is very simple but I'm very new to ASP.NET.
web form (table) with 32 dropdown fileds.paging implemented (100 rows per page)populate down button next to each controlfreeze pane implemented for first three columnsWorkinguser will change values of each drop down at runtime inorder to update the information in database.when populate down button is clicked, all the dropdown values below will be replaced with current selectio
I am trying to create a cascading dropdown list using two dropdown lists in Visual Studio 2008 Professional connecting to a SQL Server 2008 Standard database on my local machine. I have added the two dropdown lists, as well as a CascadingDropDown extenders from the AJAX Control Toolkit that corresponds with the first dropdown list. The problem I am running into is that despite the fact that I have a CascadingDropDown extender for the first dropdown list so far, and the extender is configured properly, the first dropdown list is showing Unbound in Design view. I also don't see a TargetControlID entry in the properties window for the externder.
I hard coded the TargetControlID to the extender in the Source view and, although I am not receiving any dynamic errors from the TargetControlID entry (meaning, the TargetControlID is a valid parameter, and the dropdown list I entered for that parameter exists on the same page), the dropdown list doesn't populate properly and when in Design view, not only do I not see an entry for the CascadingDropDown extender, but the target dropdown list shows as being "Unbound."
A couple of things I want to point out first:
1) I am using Master pages on this site for the header, footer and navigation. The opening and closing <form> tags, as well as the <ScriptManager> entry are in the Master page, not the content pages. I did this with the assumption that at runtime, each page would have the proper <form> tags and <ScriptManager> entry to function properly.
2) I have been able to add a CascadingDropDown extender to a page in Design view (and it initially displays properly), but by the time I have added all of the properties settings to apply it to its corresponding dropdown list, the entry appears normal in Source view but no longer appears in Design view. When I run the page, the dropdown list does not populate. Obviously, I assume that this is related to the dropdown list showing in Design view as being Unbound, but I don't know how to get the dropdown list to recognize that I have a CascadingDropDown extender that is supposed to apply to it.
Here is what the two elements look like in Source view:
To create these, I have been following Joe Stagner's example in his video on the topic (http://www.asp.net/ajax/videos/use-aspnet-ajax-cascading-drop-down-control-to-access-a-database) virtually word for word. I have set up two TableAdapters/DataSets, one for each dropdown list, and the datasets are able to accurately pull the appropriate data from the database, so I know those are working properly. I believe the problem is that the dropdown list isn't binding with the CascadingDropDown extender properly. It wouldn't bother me that I don't see a TargetControlID entry in the properies window for the CascadingDropDown extender, although I have a feeling that the absense of that property is related to the fact that the dropdown list is not binding to the extender. I searched online for causes to this problem, but I wasn't able to find any solutions.
I am binding a Datagrid using a query and the dropdown using different query.On the page load i am binding both Datagrid and Dropdown successfully.But on PageIndexChanged event i am unable to bind Dropdown,but binding the grid.How to proceed in this case.
I want to dynamically bind dataset values into datagrid's header datafield.
Is it possible? To be more clear, when you click on datagrid's (Collection) from properties window, you get selected columns created from Bound column. So in those columns I want to dynamically display dataset's table values in those columns.
i.e like ds.Tables[0].Rows[0][0].
Is it possible to do it in Datagrid ItemDataBound function like,
e.Item.Cells[1].Text = ds.Tables[0].Rows[0][0]
or something like this? I know the above code is wrong and wont work since I tried it out and while building it throwed error saying, Cannot implicitly convert type 'object' to 'string'.
I trying to change data on a map control on a dropdown selection that loops through vb and is supposed to refresh the control with the new selecctions. When I change the dropdown, the new recordset is generated but the control does not refresh with the new data, just flashes and shows the last results from the onload command.
