Dropdownlist - Multiple Datasources?
Mar 21, 2011
problem: bad design but this is what they want.I have a datasource which binds to a dropdownlist. This is fine. this displays companies (with companyID as the DataValueField)they then, underneath, want a seperator and then after that, a list of "groups".of course, DDL cannot have multiple Datasources. So how can I bind from 2 sources into 1 DDL? I cannot seem to think of a way. Even adding the items at the end of the databinding will not help as the GroupID maybe the same as a CompanyID for the DataValue.
View 4 Replies
Similar Messages:
Feb 26, 2010
I have one grid in which i use one datasource to get several data . Now i want to ad a column in my grid and bind that column with a column from another datasource.
View 9 Replies
May 19, 2010
I have two AccessDataSources each returning one row.
I want to use the data in each row to populate content on my page, so I figured I would use a [Code].... or [Code].....
However, I would not necessarily want the labels bound to a particular DataSource placed together.
For example, I might want labels from the following columns in order [Code]....
:
[Code]....
Note: No language preference (C#/VB).
View 2 Replies
Mar 17, 2011
I have a gridview. Its data is populated programmatically by a switch :
string c = dropdownlist1.Text;
switch (c) {
case "abuse":
gridview.datasourceid = sqlview1;[code]...
I want to change the color of the field with service count > 2
I tried to look at ondatabound event handler but my issue is being able to look through the data and change the color conditionally.
View 19 Replies
Aug 12, 2012
i have 3 drop down list in my page
1-ddlzone1
2-ddldistrict1
3-ddlstore1
this is ddlzone1 code
protected void DDLzone1_SelectedIndexChanged(object sender, EventArgs e) {
DDLstore1.Items.Clear();
DDLstore1.Items.Add(new ListItem("select center", ""));
DDLstore1.AppendDataBoundItems = true;
SqlCommand _cmd = new SqlCommand("selectcenter", _cn);
[CODE].....
View 1 Replies
Feb 25, 2016
I am not able to find the projects related to working with excel sheets by using ClosedXML to refer. I have an excel book which contains two sheets.
In sheet 01: In column A: In B: In C:
Student name01 Student's phone number blabla
Student name02 Student's phone number blabla
Student name03 Student's phone number blabla
In sheet 02: In column A: In B: In C:
course name01 computerscience blabla
course name02 dhfsthshbstgs blabla
course name03 garsfghsefrgs blabla
now, I would like to see in two comboboxes (all the words/text presented in the column A) from two sheets, the student name and course name and then I want select any student name and course name of my choice. Afterwards, when I click on a button, my program should display the students phone number and the course name (from column B from both sheets) and related things present in the Column C D E.. of the selected things in combobox in a label or a in a textbox.
PS: I solved the following problem: I can select student name in one combobox and print the the corresponding data from the only one column B (but I worked only with one sheet). It is bit complicated for me to continue with two sheets.
View 1 Replies
Mar 8, 2010
I have an ObjectDataSource (but perhaps this question is the same for all kinds of DataSources which support parameter collections):
<asp:ObjectDataSource ID="MyObjectDataSource" runat="server"
TypeName="MyData"
OldValuesParameterFormatString="original_{0}"
SelectMethod="GetMyData" >
<SelectParameters>
<asp:ControlParameter ControlID="MyTextBox" Name="MyParameter" Type="String" />
</SelectParameters>
</asp:ObjectDataSource>
As you can see there is a ControlParameter bound to a TextBox on the aspx page. So the content of this TextBox is a parameter for my SelectMethod. But there is a special button on the page: When this button is clicked and a postback occurs I don't want that the DataSource extracts the content of the TextBox to control the selection, instead I want to set a specific hard value "x" as the selection parameter.
How can I do that? Can I "disable" in some way the ControlParameter when this specific button is clicked and set my special value instead? Or is there any other way?
View 1 Replies
Nov 13, 2010
How do you control database server access when you use datasources in VB 2010?How do you access multiple tables from a store procedure using datasources?
Explanation:My experience is with VB.NET for the most part. I've written a lot of apps drawing data through dataadapters into datasets and processing them to provide reports in aspx.
I'm starting to work in VB 2010 and those elements are no longer available. What appears to be the weapon of choice is the datasource.What I'm not seeing: 2 important things that I can't work without:
1. Control over when the database server is hit with a connection request; daMyQuery.Fill (MyDataSet) was an explicit command that I could use to collect my data on demand. From that point on, I could use the dataset as I wished to populate whatever controls or structures I wished - the database server was no longer needed and wasn't hit by my apps until another pageload.
2. Multiple Tables in a query result; This must be there, I just can't find the method by which to reference different tables in my SQL output. Previous, I would have a dataadapter which would use a stored procedure to deliver a dataset of multiple - sometimes many - tables for use in the application. I can't find the equivalent on a datasource.
So my two big-ticket needs - requests for assistance, really - are listed above: How do you get at multiple tables returned from a stored procedure;and;How do you keep datasources for hitting the dbserver whenever you use it if there is no equivalent to a 'fill' method?
I guess another - how would you walk through the rows of a dataset?
View 15 Replies
Feb 16, 2010
i saw this post on[URL] so the problem is .... if there is a datasource in some editeitem template in grid view .... it won't be accessible from out of the edit-item field.....
here's my code...
[Code]....
that i have here is ID-column which contains a linqdatasource taking a where parameter from a dropdownlist and they are both in the same edit-template field.
and i have in another column (CourseTypeID-column ... edit-item template) a dropdownlist ..... now this dropdownlist i want to bind it to the linqdatasource exists in the ID-column (edit-item template)..... is that possible in the designer (or from) not code behind ..... and how ????
View 4 Replies
Mar 29, 2011
I've been filtering my gridviews with the FilterExpression of the underlying ObjectDataSource etc. I am wondering how I can implement filtering on my GridViews if I just directly databind it to a datatable etc?
View 5 Replies
Dec 22, 2010
I have created a web application will will eventually be the holding place for several reports. Rather than creating a new webform for each report, I want to use the same report viewer for all of the reports. I have created an AccountSummary dataset (AccountSummaryDS.xsd) that has two tables, one for the header information and one for the details. I have two webforms in the app, a Default.aspx that captures the necessary employee information for the query and the ReportForm.aspx that has the reportviewer control.
I came up with the code below for a Windows form application but am having issues translating it to be used in a webform.
[Code]....
View 1 Replies
Mar 15, 2010
i have a mysql database and a sql server database.there is a link between these two tables via a foreign key.is it possible to connect two datasources together in my datamodel? if so please can someone tell me how i can do this? i have them both present in the data model, i just want to be able to link the two databases together.i am using asp.net mvc, c# and entity framework - all in visual studio 2008
View 4 Replies
May 3, 2010
I would like a site that offers the users the possibility to search over 2 datasources but as i tried to indicate in the subject title the searches are one after another where the result of search 1 is used as a parameter for searching the second datasource. The order of the search would depend for what you search (ideally). Some "fields" or "data" of course appear in both datasources.
To get more specific: datasource 1 contains chemical structures and the associated "id" for this structure + additonal properties. You can search for chemical structures here. (chemically intelligent system). datasource 2 contains documents which are indexed (full text) and have metadata fields one of them beeing above id. No chemical search possible.
The idea is now that i perform a search by chemical structure on datasource 1. As as a result I get a list of id's. These id's are then past into datasource 2 as parameter + also all additionaly parameters entered. There are API's available to perform above searches on the 2 datasources. Is this a reasonable approach? Would it be better to create somekind of a simple datawarehouse, eg a table with all numbers linked to all documents they appear in? (would't know how to achievie this actually since it's the 2 datasoruces are not the same rdbms).
View 2 Replies
Jan 7, 2010
Is it possible to bind two separated datasources to one dropdown list such that they are both alphabetically sorted and seprated by some sort of line. I know there is a way to insert elemets manually, but I'm not sure of the 2 separate datasources. I've serached this forum and while there were several posts none of them offered any workable solution.
View 5 Replies
Apr 29, 2010
how i handle this problem..Its in hidden filed.
Server Error in '/DentalClaimPrjt' Application.
Cannot have multiple items selected in a DropDownList.
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.Web.HttpException: Cannot have multiple items selected in a DropDownList.
Source Error: [Code]....
Line 85: function openPopup2(did)
Line 86: {
Line 87: var hdnClm1 = document.getElementById('<%=hdnCliamid.ClientID%>').value;
Line 88: window.location="Form.aspx?DeleteRSPid=" + did + "&Editid="+ hdnClm1;
Line 89: }
Source File: d:DentalClaimPrjtForm.aspx Line: 87 Stack Trace: [Code]....
[HttpException (0x80004005): Cannot have multiple items selected in a DropDownList.]
System.Web.UI.WebControls.DropDownList.VerifyMultiSelect() +106
System.Web.UI.WebControls.ListControl.RenderContents(HtmlTextWriter writer) +124
View 2 Replies
Aug 31, 2010
I have an AJAX UpdatePanel that contains multiple dropdownlists, a button, and an ASP Panel (which contains dropdownlists and textboxes). On button_click I want to enable the ASP panel, but it is not enabling. The ddls all work fine, I just can't enable/disable any controls within the update panel or the asp panel itself.I tried UpdateMode = Always I tried UpdateMode = Conditional where ddls and button were triggers I tried adding UpdatePanel.Update() to the button_click I tried using visible instead of enabled (ASP Panel) Nothing is working. Side Note: this is all within a step on the ASP Wizard
View 7 Replies
Oct 21, 2010
I want to create multiple dropdownlist for each item I get from Database- the dropdownlist is common for all the list...I have the follwoing code for checkbox
Dim guest As user = Session("user")
Dim items As ArrayList = items.getitems(guest)
If items Is Nothing Then
[code]...
Just like the repeatLyout.flow in the cblitem.. I need the same for the dropdownlist...(I need it to repeat for each item I get from database)
View 5 Replies
Sep 15, 2010
In databse i have a column called Region.I have multiple occurence of region say india.India is repeated 5 times in region column.But in dropdownlist i should display only once.Is it possible.How?
View 2 Replies
Jan 23, 2013
how to do multiple selection in dropdownlist in asp.net
View 1 Replies
Jun 3, 2010
I have two ListBox in my ascx file, I fill them with some data (no problem here), I make them multiple and increase the size, below is my code.
[Code]....
I use some jQuery code to exchange element between them (Here too, no problem). My problem begin when I post my form, I'm unable to get the data from the DropDownList with attribute multiple or size. I tried in my controler to add a FormCollection parameter, I can see every element in my form except those select tag with more options than id and name. I tested to put a manual select tag in my code with only an id and a name then add size and multiple attribute, when there is only id and name I can get the value but when there are more I can't get my select tag in the FormCollection
Also I need to get all the value in the ListBoxand not only the ones who were selected. I have been searching answer for 2 fays now... Without success, I only find resource on how to show ListBoxbut not how to get values from them in mvc web site and I don't find any resources who talk about multiple selection ListBox, I think I'm a bad searcher but....
View 3 Replies
Mar 29, 2010
Now my datasource has where clause depends on the selection of a dropdownlist that contains selection of one of the items plsu and option ALL.
This only caters for all or, one item
I need to make it
All, or, 2,3, or 4.. selection and the datasource is then refreshed. What control I should use and it seems the SQL need to modified into "IN" statement, am I wrong ?
View 9 Replies
Sep 6, 2010
How to select multiple fields from a dropdownlist..
View 6 Replies
Dec 15, 2011
I have a footer template in gridview with 4 dropdownlist in a row. Based on the selection of first dropdown i need to load data in the other dropdownlists and similarly for the rest.. How to write events for this?
View 1 Replies
May 7, 2015
System.Web.HttpException: Cannot have multiple items selected in a DropDownList.
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.Web.HttpException: Cannot have multiple items selected in a DropDownList.
I have a nested gridview and inisde a child grid there are several columns having dropdown and one add button. when add button is click a new row inside a child grid is created with an empty dataand previous row data have been saved in viewstate so that it can be bind wen add button is click to create new rows.My code is working fine when i dont select any dropdown list item and new row is also created but wen i select items from dropdown and click on add more button i get above error.
When add button is click
protected void ButtonAdd_Click(object sender, EventArgs e) {
Button gv = ((sender) as Button);
string[] ParentIdArray = gv.ClientID.ToString().Split('_');
int ParentId = int.Parse(ParentIdArray[1].ToString().Replace("ctl", "").Trim()) - 2;
int RecordCount = ((GridView)GVMain.Rows[ParentId].FindControl("grdAddHotel")).Rows.Count;
DataTable dtAddHotel = new DataTable();
dtAddHotel.Columns.Add("CostSheetId");
[Code] .....
View 1 Replies
Dec 7, 2010
i used the following technique to Select multiple items from DropDownList into TextBox with No duplicates, however i dont think it is the most proper way, any ideas. pressing again with same value selected choose another value from DDL and press button
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
If TextBox2.Text.Contains(DropDownList1.SelectedItem.Text) Then
Dim m As New Label
m.Text = "duplicate !"
Me.form1.Controls.Add(m)
Exit Sub
End If
If TextBox2.Text = "" Then
TextBox2.Text = DropDownList1.SelectedItem.Text
Else
TextBox2.Text = TextBox2.Text + " , " + DropDownList1.SelectedItem.Text
End If
End Sub
View 1 Replies
