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 Repliesi 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].....
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.
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)
how to do multiple selection in dropdownlist in asp.net
View 1 RepliesNow 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 ?
How to select multiple fields from a dropdownlist..
View 6 RepliesI 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 RepliesSystem.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] .....
I am trying to display a gridview with element names bound to a datatable (transformed from OracleReader) and also display two contact dropdowns inside the gridview. For each record in the datagrid i want to display these dropdown lists that will also be bound to two different datasources. How would I accomplish this?
View 9 RepliesBelow is my code. I am getting error "Cannot have multiple items selected in a DropDownList"
if i run this code.lstType.Items.Clear()
strSql = ""
lstType.DataSource = handler.fnDataSet(strSql)
lstType.DataBind() [code]....
I have just started with this . I am a new user and i want to know that why we cannot have multiple items selected in a DropDownList?
View 4 RepliesI have a drop down with several option. I would like that if a certain item is select then a certain query will run. I read a post that
azamsharp on 12/23/03 .In that post he suggested to do:
string myProcedure = DropDownList.SelectedItem.value.ToString();
SqlCommand myCommand = new SqlCommand("myProcedure",myConnection);
while reading through the post it seems that this wasn't a great idea.
I have 3 dropdownlist controls for use with capturing birth dates. One captures the month, the next the day and the next the year. Rather than having to use 3 different xml files to populate the controls I want to be able to use just 1 xml file, but I haven't been able to work things out. I thought this would work:
<dates>
<date month="1"/>
<date month="2"/>[code]....
I thought I'd be able to assign the datatextfield of month, day or year to a given control, but this isn't working. They show up in the datatextfield dropdown in properties, but when I try to view the page in a browser I get an error that tells me the field (i.e., day) does not exist. Is there a way I can accomplish this? I am developing an ASP.NET 2.0 site in VS 2005.
How to display checkboxes in dropdownlist ?
Actually I want to select any checkbox(For selecting months) which is listed in dropdownlist?
Multiple Select (MultiSelect) DropDownList with CheckBoxes in ASP.Net using jQuery. But i want save to database several selected value dropdownlist.
View 1 Repliesi 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.
i have a datbase:a
table :a
values :
--------------------------------
a
--------------------------------
cake
breaad
lassi
mechroni
chocolate
---------------------------------
what i have is a dropdownlist1,chekbox1 and objectdatasource1 for getting the select query
what i need is checkbox values should fetch the values of table a and displayed inside in
dropdownlist1 and values are checked dynamically and the checked values should be shown in
gridview1
if any body knows the full code reply the code or mail me ponmanivannangj@mobiusservices.in
Newbie here, I'm trying to setup a webpage using the following tutorial posted on this website:http://www.asp.net/(S(pdfrohu0ajmwt445fanvj2r3))/learn/data-access/tutorial-07-cs.aspxThe problem is when i try to add the fields on 2 columns on my table and then populate a dropdown list with the concatenated columnie. my table has the columns ID and Name. I want to display it as:"ID - Name" in my dropdownlist in stead of just Name. eg: "AB - Treatment Centre"I've been googling and so far the only solution i've come across is to generate a TableAdapter with the following query:
View 3 RepliesI Pieces
NA 400
How to multiple fields in DropDownList DataTextField and DataValueField
[Code]....
[Code]....
I am trying to hide 2 buttons depending on the value in the dropdownlist. It works when the page is initially loaded but chokes when returning to the page sometimes. I have some pretty simple code in the Page_Load event within an If Not Page.IsPostBack statement
[Code]....
[Code]....
I have a GridView with a DropDownList in it bound to the [Applicants] table in SQL Server 2005.
The DropDownList Items Text and Value come from SqlDataSource3, "SELECT VoucherType, VoucherNumber FROM [Vouchers]"
I need to send the DDLs selected Text to [Applicants].[VoucherTypeIssued] and the Value to [Applicants]. VoucherNumber]
I already have a "dlVoucherTypeIssued_SelectedIndexChanged" event in the code behind to put "Voucher Issued" into [dbo].[Vouchers].[VoucherStatus]. I'm having trouble getting all three values written to the database at the same time.
I have a multiView control within which I have 3 views as part of building a customer order.
Step 1: Customer is selected from gridView and Customer Name is saved in MultiView Session.
Step 2: Products are chosen from gridView. The grid is re-bound depending on which product category is selected in a dropDownList. The product details are also stored.
Step 3: All of the details required to build the INSERT query are passed to labels on a form to be reviewed before committing to db. The next stage, now that I have managed to select multiple rows, will be to display this data in another gridView.
Everything works fine, except for the paging and dropDownList which is causing the checkbox state to be lost after postBack.
I've read a few articles on this, but I think I have made the task more complicated due to the dropDownList in addition to paging. Essentially the customer will be able to select various product lines, across various bindings of the gridView so I need to persist the checkbox state and retain the data for the INSERT query.
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