Web Forms :: How To Select Multivalue From DropDownList
Jan 26, 2010
i have DropDownList with sql select commend
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource_department" DataTextField="Department"
DataValueField="Department_No" AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource_department" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [Department_No], [Department], [Code] FROM [Departments]">
</asp:SqlDataSource>
in the behind code, i can get the value using "DropDownList1.SelectedItem.Value" for Department_No and "DropDownList1.SelectedItem.Text" for Department
but i want also get the selected value "Code"
View 6 Replies
Similar Messages:
Mar 25, 2011
I had use a combox to let user select staff name and then it will automatically retrive the responsible recommending officer and approving officer to display in other 2 dropdownlist.
my code works fine but when user select staff name each time, the page will reload once to refresh the dropdownlist.
user complaint and don't want the page reload every time, how can i disable the postback? I need to use ajax?
[Code]....
[Code]....
View 5 Replies
Feb 4, 2011
im working on Visual Studio 2010, and im making a .net web page. The final idea is to use filters by using dropdownlist. By now i have 3 dropdownlist in cascade. The first filters the second and so on. Then by a grid view i display the selected items, right now i need to add an item that allows me to select all the items in the dropdownlist so in the next filters i like i have selected all. My code filters everything but i cant add this item. I only work in asp .net, not in the code behind wich i think is #C if im not wrong... i have to add a button in each dropdown.
I have read others post and the say that i have to add this in the dropdown>> "appenddatabounditems="True" and this sql sentence
WHERE ([PROJID] = CASE WHEN @PROJID= -1 THEN [PROJID] ELSE @PROJID END)
but it doesnt work.
heres the code.
<form id="form1" runat="server">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TestingConnectionString %>"
SelectCommand="SELECT [PROJID] FROM [sxb_Proyectos] ORDER BY [PROJID]">
</asp:SqlDataSource>
<br />
<asp:Label ID="Label1" runat="server" Text="Proyecto"></asp:Label>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1" AppendDataBoundItems="true"
DataTextField="PROJID" DataValueField="PROJID">
<asp:ListItem Value="0"><Select an option></asp:ListItem>
<asp:ListItem Value="-1"><Select All></asp:ListItem>
</asp:DropDownList>
<br />
<br />
<br />
<br />
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:TestingConnectionString %>"
SelectCommand="SELECT DISTINCT Ax50_Empleados.emplid, Ax50_HorasRegistradas.EMPLID
FROM Ax50_Empleados
INNER JOIN Ax50_HorasRegistradas
ON Ax50_Empleados.emplid = Ax50_HorasRegistradas.EMPLID
where PROJID = @PROJID
ORDER BY Ax50_Empleados.emplid">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="PROJID" PropertyName="SelectedValue"/>
</SelectParameters>
</asp:SqlDataSource>
<asp:Label ID="Label2" runat="server" Text="Rut"></asp:Label>
<asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2"
DataTextField="emplid" DataValueField="emplid">
</asp:DropDownList>
<br />
<br />
<br />
<br />
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:TestingConnectionString %>"
SelectCommand="SELECT DISTINCT sxb_Producto.Producto, Ax50_HorasRegistradas.LINEPROPERTYID
FROM sxb_Producto
INNER JOIN Ax50_HorasRegistradas
ON sxb_Producto.Producto = Ax50_HorasRegistradas.LINEPROPERTYID
where emplid = @emplid and PROJID = @PROJID
ORDER BY sxb_Producto.Producto">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList2" Name="emplid" PropertyName="SelectedValue"/>
<asp:ControlParameter ControlID="DropDownList1" Name="PROJID" PropertyName="SelectedValue"/>
</SelectParameters>
</asp:SqlDataSource>
<asp:Label ID="Label3" runat="server" Text="Producto"></asp:Label>
<asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource3"
DataTextField="Producto" DataValueField="Producto">
</asp:DropDownList>
<br />
<br />
<br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource4"
EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="PROJID" HeaderText="PROJID"
SortExpression="PROJID" />
<asp:BoundField DataField="EMPLID" HeaderText="EMPLID"
SortExpression="EMPLID" />
<asp:BoundField DataField="LINEPROPERTYID" HeaderText="LINEPROPERTYID"
SortExpression="LINEPROPERTYID" />
<asp:BoundField DataField="QTY" HeaderText="QTY" SortExpression="QTY" />
<asp:BoundField DataField="TXT" HeaderText="TXT" SortExpression="TXT" />
<asp:BoundField DataField="TRANSDATE" HeaderText="TRANSDATE"
SortExpression="TRANSDATE" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource4" runat="server"
ConnectionString="<%$ ConnectionStrings:TestingConnectionString %>"
ProviderName="<%$ ConnectionStrings:TestingConnectionString.ProviderName %>"
SelectCommand="SELECT [PROJID], [EMPLID], [LINEPROPERTYID], [QTY], [TXT], [TRANSDATE], [TRANSSTATUS], [DIMENSION], [DIMENSION3_] FROM [Ax50_HorasRegistradas] where PROJID = @PROJID and emplid = @emplid">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList3" Name="Producto" PropertyName="SelectedValue"/>
<asp:ControlParameter ControlID="DropDownList1" Name="PROJID" PropertyName="SelectedValue"/>
<asp:ControlParameter ControlID="DropDownList2" Name="emplid" PropertyName="SelectedValue"/>
</SelectParameters>
</asp:SqlDataSource>
</form>
View 1 Replies
Oct 11, 2010
Im pretty new and Im not sure what Im doing wrong here. Could anyone please take a look at my code an let me know what my problem is.
[Code]....
View 1 Replies
Apr 4, 2011
I want to Add product with Solr.net Schema file. my database Table is
Category table - catid, catname
Brand table - brandid, brandname
Item table - productid, productname, productdesc
Filter table- key, value
Note:- if i add all with a Table then data Repeatation occur. so if u have better solution then please suggest me with an examle.
View 1 Replies
Jan 25, 2010
I want to use a dropdownlist control so that a user can select a value. My problem is, the text value can be very large. Is there any way to make the text to appear on more than one line? Or is there any AJAX or jquery solutions? I can use a gridview with a checkbox but my client really wants a dropdownlist.
View 3 Replies
Sep 6, 2010
How to select multiple fields from a dropdownlist..
View 6 Replies
Dec 23, 2010
I am binding a dropdownlist through stored procedure on page load.
There are tho fields in my databse table City and Class.
in dropdown property i put DataTextField="City" DataValueField="Class"
suppose there are 6 cities in dropdown 3 cities for class A and 3 for class B, see if i select any one city of class A, after select droodown automatically select the first city of class A, and same if i select a city of class B, it auto selects first city of
class B.
and here i am binding my code..
[Code]....
View 32 Replies
Apr 10, 2014
Iam using dropdownlist with required filed validator and Iam getting the text from db and binding to dropdownlist so its comng well but it is showning two times in dropdown I mean in actal place and the select place so whenever I click on button it firing...
Code:
<asp:DropDownList ID="ddlMemberType" runat="server" CssClass="product-textbox" Width="420" onchange="changeMember();">
<asp:ListItem Value="Select" Text="Select MemberType" />
<asp:ListItem Value="Family" Text="Family Man" />
<asp:ListItem Value="Employee" Text="Employee" />
[Code] ....
View 1 Replies
Mar 8, 2010
Im facing problem in one of the reports while passing multivalue parameter from ssrs to SP.
please note that in cases suppose there are single word in multivalue paramtere then its works corretly,in that scenario i have made one function see below:-
[Code]....
and did changes in sp as follow :-
[Code]....
im using ssrs2005.
View 2 Replies
Dec 10, 2010
How to write a MDX expression to pass the value of a multiselected filter while working with ReportAction in Cubes.
I know how to pass the currently selected value, but want to pass the more than one value selected in the filter.
View 1 Replies
Nov 10, 2010
I have a GridView with a templatefield that contains a dropdownlist. I want to insert the selectedvalue as a datetime field into a table.
This is my code:
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs) Handles GridView1.RowDataBound
If e.Row.RowType = DataControlRowType.DataRow Then
Dim shippingdate As DateTime
[Code]...
View 2 Replies
Nov 22, 2015
Multiple Select (MultiSelect) DropDownList with CheckBoxes in ASP.Net using jQuery. But i want save to database several selected value dropdownlist.
View 1 Replies
Mar 2, 2014
I have 2 Dropdown(say "DD1", "DD2") and 1 Listbox(say "LB") in my web form,value of the 3 controls depend on each other.
"LB1" is dependent on "DD2" value, "DD2" is dependent on "DD1" value.
I want that if user selects "LB1" without selecting "DD2", it should give a message that "please select DD2 first"similarly if user Selects "DD2" without selecting "DD1", it should give a msg that "Please select DD1 first" ,using ASP.NET C.
View 1 Replies
Jan 4, 2010
I have created an ASP.NET page and included a ReportViewer on the page.
I have created a report with a parameter for an item ID for a row from the database.
After generating a multivalue parameter, I send it to the report, but only the first item in the list is displaying.
In my included code, I am using a FOR loop to generate a list of ID's I want to print a detail for (one detail per page), but eventually I am going to allow a user to select the ID's from a GridView, generate the reports and then print.
Here is the parameter definition from the report:
<ReportParameters>
<ReportParameter Name="ParmWorkOrderID">
<DataType>Integer</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Report_Parameter_0</Prompt>
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
---------
Here is the code that build the multivalue parameter:
List<ReportParameter> paramList = new List<ReportParameter>();
ReportParameter param = new ReportParameter("ParmWorkOrderID");
// Create the ArrayList of values to pass
ArrayList values = new ArrayList();
for (int i = 19; i < 50; i++)
{
param.Values.Add(i.ToString());
}
// Add the parameter to the list of ReportParameters
paramList.Add(param);
// Set the reports parameters
this.ReportViewer1.LocalReport.SetParameters(new ReportParameter[] {param});
-------------------------------------------
Finally, here is the filter I have on the report:
<Filters>
<Filter>
<FilterExpression>=Fields!WorkOrderID.Value.ToString</FilterExpression>
<Operator>In</Operator>
<FilterValues>
<FilterValue>Parameters!ParmWorkOrderID.Value</FilterValue>
</FilterValues>
</Filter>
</Filters>
So, why won't the reporting engine pump out one page or row (if I use a table on the report) for each of the ID's sent over as parameters?
View 1 Replies
Jan 19, 2011
my qyery is Select * from UserTable .
i set my parameter as @UserId,checked multivalue check box.
in Available values-from query-i set my value and label field.
default value is null.
when i click the preview tab,multiple UserId with check box appear in drop down list...
when i select any one userid ..i get the result for all the userid list instead i want only the selected userid's information...
View 3 Replies
Dec 9, 2010
I once asked for a way to let a linkbutton pass more than one value in the commandArgument and then I reached the approach where I pass a string of multiple values separated by any character and split it into it's original parts...that didn't work out I don't know what was wrong with the splitting!
Now I tried the only solution I got, which is created a user control of the LinkButton and add properties to accept any values nedeed!...could you please tell me what's wrong with my 2 approaches and which is better ?
The first question can be found here : link text
and this is the code for the user control approach >>
MultivaluedLinkButton.ascx :
<asp:LinkButton ID="LnkBtnSort" runat="server" Text="Sort" OnClick="LnkBtnSort_Clicked"/>
MultivaluedLinkButton.ascx.cs :
public partial class MultivaluedLinkButton : System.Web.UI.UserControl
{
public event EventHandler Click;
private int _sortingType;
private string _sortingFactor;
private string _text;
public int SortingType
{
set { _sortingType = value; }
get { return _sortingType; }
}
public string SortingFactor
{
set { _sortingFactor = value; }
get { return _sortingFactor.ToString(); }
}
//public string Text
//{
// set { _text = value; }
// get { return _text.ToString(); }
//}
protected void LnkBtnSort_Clicked(object sender, EventArgs e)
{
if( Click != null )
{
this.Click(this, EventArgs.Empty);
}
}
}
Finally, Here's the implementation of my control inside an aspx page:
protected void MultivaluedLinkButton1_Clicked(object sender, EventArgs e)
{
MultivaluedLinkButton ctrl = (MultivaluedLinkButton)sender;
using (SqlConnection cn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString))
{
using (SqlCommand cm1 = new SqlCommand(commandString2, cn1))
{
cm1.Parameters.Add("@arrange_by_id", System.Data.SqlDbType.Int);
cm1.Parameters["@arrange_by_id"].Value = ctrl.SortingType;
cn1.Open();
using (SqlDataReader dr1 = cm1.ExecuteReader())
{
SortBy_rpt.DataSource = dr1;
SortBy_rpt.DataBind();
}
}
}
}
The item template of the repeater in the implementation page :
<ItemTemplate>
<uc1:MultivaluedLinkButton ID="MultivaluedLinkButton1" runat="server" OnClick="MultivaluedLinkButton1_Clicked" SortingType='<%#Eval("arrange_by_id")%>' />
</ItemTemplate>
View 1 Replies
May 7, 2010
Here's what I want to accomplish: I have two .aspx pages, the first page with a ddl to select a vendor (SelectVendor.aspx), and one to add a vendor (NewVendor.aspx), if it's not in the first one. If a user adds a new vendor on the NewVendor.aspx page I want the page to automatically redirect back to SelectVendor.aspx and have the ddl automatically select the new vendor that was just added. Here's where I'm at so far: If a vendor is not listed in the ddl on SelectVendor.aspx, a user can click a button to navigate to a page to add a new vendor (NewVendor.aspx). On NewVendor.aspx the user types the name of the new vendor in a textbox and clicks an insert button to add the new vendor, then the page is automatically redirected back to SelectVendor.aspx with the new vendor name added to the QueryString. For example, let's say a user adds a vendor name "Best Vendor": The page is redirected back to SelectVendor.aspx as "SelectVendor.aspx ?vendor=Best Vendor"Now all I need from here is to have the ddl programmatically select the new vendor by the text value in the QueryString.
Here is the code that I'm having trouble with from my Page_Load routine for SelectVendor.aspx:
[Code]....
View 7 Replies
Jan 11, 2011
i need to select multiple items in a dropdownlist. This is my code,
<asp:DropDownList ID="ddllocation" runat="server" Width="80px">
<asp:ListItem>Chennai</asp:ListItem>
<asp:ListItem>Madurai</asp:ListItem>
<asp:ListItem>Coimbatore</asp:ListItem>
<asp:ListItem>Nilgiris</asp:ListItem>
<asp:ListItem>Palaghat</asp:ListItem>
</asp:DropDownList>
How can i add tat option.
View 7 Replies
Jan 20, 2010
I am trying to populate a gridview when you select the dropdownlist.selected value. I don't want to use the sqldatasource or any other datasource. I am trying my best to achieve this, but didn't succeed till now. One of my friend said that i need to get the selected value from dropdownlist and search for the data in the database using the selectedvalue and populate the dataset and bind to the gridview.
View 2 Replies
Mar 24, 2010
I have 2 dropdownlist controls (ddl1 and ddl2). When I pick an item from ddl1, it will update ddl2. The problem is when I pick an item in ddl2, it always selects the first item in the list. Is it that the ddl2 autopostback causes the first ddl1 to reload and results the ddl2 to be refreshed also? Or I didn't set something correctly?
[Code]...
View 12 Replies
Nov 20, 2010
When I try to use this code in a Form View, I get an error message:
Compiler Error Message: CS0103: The name avgift_namnTextBox is not in the current context
ROW: 35
Rad 33: if (dropDownlist.SelectedValue == "Other")
Rad 34: {
Rad 35: avgift_namnTextBox.Enabled = true;
Rad 36: avgift_namnTextBox.Text = string.Empty;
Rad 37: avgift_prisTextBox.Enabled = true;
Here is my code:
<%@ Page Title="Lista medlem" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="medlem.aspx.cs" Inherits="medlem" %>
<asp:FormView ID="FormView3" runat="server" DataKeyNames="faktura_id"
DataSourceID="SkapaFaktura" DefaultMode="Insert" Width="687px">
<InsertItemTemplate>
[Code]....
View 3 Replies
Jul 20, 2012
I have drop down list in my page that contain cities name i bind it from city table
city id
Paris 1
Germany 2
Italy 3
USA 4
View 1 Replies
May 7, 2015
i have complete date in a textbox i want to make the selected value in drop down list_days equal the day part of textbox,the selected value in drop down list_months equal the month part of textbox & the selected value in drop down list_years equal the year part of textbox to make the user update it if he want i tried to find the answer but i coudn't.
View 1 Replies
Jul 28, 2010
I want to know, how do i send a multivalue parameter from C# to Stored Procedure which is used in WHERE CLAUSE in IN statement?
for eg:
CREATE PROCEDURE [dbo].[sp_GetPolicyDivOff1]
@Insid varchar(5000)=null
AS
SET NOCOUNT ON
SELECT MST_GroupCompany.GC_Name,MST_DivisionalOffice.DIV_Name FROM MST_DivisionalOffice INNER JOIN MST_GroupCompany ON
MST_DivisionalOffice.DIV_FK_GC_ID=MST_GroupCompany.GC_ID where GC_Name IN(@Insid)
View 10 Replies