I have 2 dropdownlist in my page
1-ddlzone1
2-ddlstore1
What I need is if I select default item i.e. 0 in Zone dropdown I need to show all items in store dropdown. Below is my stored procedure to get the stores
ALTER procedure [dbo].[selectcenter]
@RegionID varchar(5)
as
begin
select ID,Centername
from Shoppingcenter
where RegionID=@RegionID
group by ID,Centername
end
I bind dropdownlist in my page
protected void Page_Load(object sender, EventArgs e) {
BindDropDownList(DDL1, "city1", "name", "ID");
DDL1.Items.Insert(0, new ListItem("select city", "0"));
}
And SP
LTER procedure [dbo].[city1]
as
begin
select id,Name
from city
end
And design code
<asp:DropDownList ID="DDL2" runat="server" CssClass="daddsd">
</asp:DropDownList>
And here is imagebutton code that when click on it update data into table
protected void ImageButton_Click1(object sender, ImageClickEventArgs e) {
string data = Server.UrlDecode(Request.QueryString["BehCode2"]);
SqlCommand _cmd = new SqlCommand("insertinfo", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
[Code] ....
Here when i click on button it insert all data into table but it didn't insert my selected item from dropdownlist it insert select city that i define in page_load
DDL1.Items.Insert(0, new ListItem("select city", "0"));
And when i delete this code from page load it insert in table first row of my table it didn't insert my selected item from dropdown list.
My dropdownlist is bind from database table. Now I want to add default item. How can I do that...
View 1 RepliesI have a code to add item to dropdownlist but it shows the value only. I want an alternative text to appear for user. How to modify this code ?
DropDownList4.Items.Add(item:="%")
Now % is doing the job but I want the use to see the text "ALL" in the item of the dropdownlist.
I tried DropDownList4.Items.Add(item:="%,ALL") etc but failed.
I have dropdown list in my page
BindDropDownList(DdlDistrict, "District1", "District", "ID");
DdlDistrict.Items.Insert(0, new ListItem("select district", "0"));
And I use this code for binding from database
DdlDistrict.Items.FindByText(_dr["District"].ToString()).Selected = true;
Here if in database have value it show in ddldistrict
Now I want if there wasn't any thing in database in dropdown list show "select district" that i define here
DdlDistrict.Items.Insert(0, new ListItem("select district", "0"));
I used below code to set default value for DDL
state.Items[1].Selected = true;
now I use cascading for DDL how I can same thing for cascading?
<cc1:CascadingDropDown ID="CDLdistrict" TargetControlID="DDLDO" PromptText="All"
PromptValue="" ServicePath="../ServiceCS.asmx" ServiceMethod="GetDistrict" runat="server"
Category="District" ParentControlID="DDLzoneO" />
I need to add an item in a dropdownlist and also modify the value of that item, but im getting an error : "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"here's my Page load
Dim rt as new OleDbCommand("Select * from Question ", con)
dim rd as OleDbDataReader
rd = rt.ExecuteReader
Dim a as new OleDbCommand("Select Count (*) as C from Question" , con)
[code]...
I am using aspnet menu control and i want to hide the item initially on page load and show the item after an event is trigger say button lick event Can any one give me an example?
View 6 Repliesi have a web page, with some filters using dropdownlist, and when i select items from these dropdownlist, a gridview appear showing data from a sql server. The idea is that when i select an item, from the first or second drop down list, in a textbox appear for example the name of the item i choose from the dropdownlist.
I use only VB and not C#.
[Code]....
I have a project that queries a set of times from a database and uses these entries to populate a dropdownlist. Once the page is loaded, the user can select one of the items in the DropDownList. When the "Save" button is clicked, the Selected item value is returned to the [HttpPost] version of the controller action. This item is then stored into session. If the system returns to the page containing the dropdown, I want the saved Value to be selected in the DropDownList. What actually happens is that the DropDownList is always set to be the first item in the list.
Database Table: This data has been imported using Link to SQL
[code]....
i use a dropdownlist in a page, with its items taken from a mysql database
i also use autopostback property...my problem here is that, every time i selecct an item, the first item in the list gets seelected
I have a dropdownlist for categories.
DataTextField = "Name";
DataValueField = "ID";
drp.Items.Clear();
drp.Items.Add(new ListItem("--select category--", ""));
drp.AppendDataBoundItems = true;
ID is int and I've got this
drpsub.Items.Add(new ListItem("--select category--", ""));
I want to insert some information plus ID in databaseeverything is ok when user select category from dropdownlist (for example: India, Iran, China) but when the userchoose --select category-- she face an error because the value here is "" not an ID(int value)how can i don't let user choose --select subcategory-- ?
I have
1-datalist (that use pagination)
2-dropdownlist
3-button=Ibtnselect1 in my page
and these are my table in database
HOuse_info table
Id Behcode Region name
1 1115 1 Store1
2 1116 2 Store2
3 1117 2 Store3
4 1118 5 Store4
House_p table
Id Behcode Name Description Model
1 1115 Iron Test Q2
2 1115 Vacumcleaner Test2 Cv21
3 1117 Carpet Test3 Xs23
4 1116 Furniture Test4 Df23
Region table
Id region
1 1
2 2
3 3
4 4
5 5
Here users product's information are inserted in House_p table and users inforamtion inserted on House_info table
when page is load in my datalist show all product from House_p table
and i bind dropdownlist from region table
here i want when users select their region from dropdown list in datalist show product that are in selected region according to house_info table
now when i select region from dropdown list
EX: i select 1
in my datalist in first page show all product that are in region=1
problem is :when i click on other page of my datalist it showed all product that are in House_p table but i want it showed product that related to my selected item from dropdownlist i means first page is enough i don't want after showing product related
sp
ALTER PROCEDURE [dbo].[GetProducts] (
@Region tinyint = 0
)
AS
BEGIN
SET NOCOUNT ON;
SELECT distinct House_Info.BehCode,
[Code] .....
I have a dropdown list which has states retrieved from a table. I want to have an option to add new states.. I have added a list item NEW in the dropdown. When I click on NEW i should get a pop up to add a new state and goes in the table.
View 1 RepliesHow to open Popup Window from dropdown list ...... [URL] .... Like this link but open in dropdown selected item.
View 1 RepliesI have 2 cascading dropdown lists (ListA and ListB).
The selected value from List A is used to determine ListB.
I am wondering if there is a way to dynamically remove items from ListB after ListA value is selected. There are entries in ListB that should not be available unless the user has certain security permissions.
I fill a the drop down list with a SQL select query, but i want to add a first default item, something like "- Select an option -" or "All"
What im trying to do is make a dynamic SQL query, something like this:
SELECT * FROM table1 WHERE (value1 = ? AND value2 = ? AND value3 = ? )........ (or "like" instead of "=")
You are gonna have to select those arguments from 3 drop down lists, but i wanna have a default value on the top of the drop down list options and send a "*" as value if this option its selected, so the filter doesn't consider that value
I have two dropdown lists ddlstate and ddldistricts onchange of ddlstates I am displaying the districts. Here my requirement is to make the default seleted district as "Warangal" i.e I need to highlight this list item
View 1 RepliesThis is the Grid am using ....
[Code]....
Every thing is working fine ....
Wat i did is in the first header of gridview dropdownlist i have binded the PO Item , so that user can select item n make invoice...
Here the problem is user will click addnewrow button to create new row second row , again user is able to select the same item what he selected in first row of gridview. here how to avoid duplication in the second row .
Say i have four PO item
Item1,Item2,Item3,item4
user may select Item1 in first row , after clicking addnewrow button user will get second row
here again user is able to select Item1 from dropdownlist ... how to avoid duplicate selection
coz the dropdownlist is binded from database using sqldatasource n filter based on user selected PO no.
Duplicate Item selection should be removed until all the four item is selected ...
I have a list with 2 sorts of items. Items that have actual values (1,2,3,4 etc) and items that are like group headings so all their values are set to 0. If someone decides to select a group heading - which has a value of 0, is it possible to redirect them to my 'Select an item' item which has a value of ""?
If worse comes to worse, I can just reconstruct the entire list, although if possible I'd like to avoid it.
I use a ItemDataBound for a repeater.But i use 2 kinds of linq querys to bind it.Some of them has a MerkID, and some doesnt have this item.So its easy i need to do this:
if(e.Item.DataItem.Contains("MerkID"))
{
//Code for linq query 1
} [code]...
So of course the if selection doesnt work, but how can i do that? I already tryed this:
DataRowView drv = (DataRowView)e.Item.DataItem; if (drv.Row.Table.Columns.Contains("MerkID"))
But that doenst work because he cant convert it to a datarowview because its a linq class.So what to do? Right now i use a try and catch, but there are better solutions i guess...
How can I get current viewed itemindex of a repeater item template, have tried a few stuffs i got from google search, but it seems not to work.
I have items like:
1 text link1
2 text link2
3 text link3
4 text link4
where 1, 2, 3, 4 are the itemindex, i want to be able to get 1 if text link1 is clicked, or 2 if text link two is clicked etc.
Here is my repeater html
Error 1 'System.Data.OleDb.OleDbDataReader' does not contain a definition for 'Item' and no extension method 'Item' accepting a first argument of type 'System.Data.OleDb.OleDbDataReader' could be found (are you missing a using directive or an assembly reference?)
public partial class Default2 : System.Web.UI.Page {
System.Data.OleDb.OleDbConnection Con = new System.Data.OleDb.OleDbConnection(System.Web.Configuration.WebConfigurationManager.
ConnectionStrings("MyConnectionString").ConnectionString);
protected void Page_Load(object sender, EventArgs e)
[Code] .....
I have a repeater control:
<asp:Repeater ID="rep" DataSourceID="XMLDSCompare" runat="server">
<ItemTemplate>
<h4><%# XPath("title")%></h4>
</ItemTemplate>
</asp:Repeater>
Now if its the first item in the total resultset, I want to add <div> to ItemTemplate control, if its the 2nd item, I want to add </div>
So output would be (not including table tags generated by repeater control):
<div>
title 1
title 2
</div>
<div>
title 3
title 4
</div>
<div>
title 5
title 6
</div>
How would I do this in the ItemDataBound event of repeater control?
[Code]....
here the method OnItemDataBound , look at how it work
[Code]....
problem is the e.Item always get one and only one last item . turn out my listview display many rows but with a consistent content of the last user (in the database record) . How can i resolve this ?? any creative method are accepted , i'm just want to finish this project