I have a bunch of dropdowns in a gridview and I populate them through a datasource.On the databound event i need to change the selected item to the actual selected value from db.
[Code]....
[Code]....
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.
I used this get data and change it’s useful. But now I want retrive all data from ParsonTable. I can retrieve this data like this
txtName =Asrori Yatim, txtBirthday = 06.02.1978.
Else I have DropDownlistDistrict from this only Id saved in ParsonTable.
Id FirstName and Name Birthday DistrictId
1 Sayfurov Karomatullo 07.05.1980 4
2 Asrori Yatim 06.02.1978 2
3 Yakubi Hasanzod 15.05.1991 3
How I can show DistrictName in DropDownlistDistrict because I saved Id in PersonTable? For example DropDownlistDistrict= Sino.
I have a below control in my asp.net page (3.5 framework).
<asp:ListBox ID="OptionSelector" runat="server" SelectionMode="Multiple"
SkinID="CPList" Rows="6"></asp:ListBox>
There are 25 items in the list. I have selected one item at the time of project creation. But If I edit the project then the list box is showing more selected items instead of one item in the details page.
how to stop showing drop item of dropdownlist.
I need next item of dropdownlist after pressing down arrow without showing all drop items.
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
how to stop showing drop item of dropdownlist or listbox
I need next item of dropdownlist or listbox after pressing down arrow without showing all drop items.
and It must be typable within dropdownbox or listbox
I have items in a sql table that i populate a dropdown list with. so on page load the items are sent to dropdown list. I have a button on the page with the dropdown list that onclick it launches another page that allows more items to be added to the database table.
What I want to do is to refresh/update the list of items in the dropdown list when the second page is closed. In addition the last item added to the table will be the selected item in the drop down list.
I am inserting a new states in the table from dropdown list , the dropdown list has new in the list, clicking on new gets me a pop up which takes the new state and inserts in a table. My requirement is I want to get the last inserted state in the dropdownlist and its id to be selected as soon as insertion is done.
The second function is to insert the contact details where i have countryid,stateid,cityid
protected void stateSave(object sender, EventArgs e) {
using (SqlConnection conn = new SqlConnection(cs)) {
SqlCommand cmd = new SqlCommand("newStates", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter outparm = new SqlParameter("@stateID", SqlDbType.Int);
[Code] ....
I would like to be able to pass a new value into a dropdownlist control from another webpage and cause an autopostback to occur. How can this be done?
View 27 Repliesbased on the below image, May i know how if tick the checkbox, then will hide the selected data value only.
Example, hide "a", then will hide "a" data value only.
I have 2 dropdown list in my page
1- ddlzone1
2- ddldistrict1 and one button (search)
At first I select item from ddlzone1 click on search button according to below SP it search on database and show result...
ALTER procedure [dbo].[GetCustomersPageWise]
@PageIndex INT = 1
,@PageSize INT = 5
,@RecordCount INT OUTPUT
,@Region nvarchar(10)
,@District nvarchar(20)
[Code] ...
Now I want when users select item from ddlzone1 after that if they select item from ddldistict1 according to their selected item from ddlzone1 and ddldistrict1 it search in table and show result
Now how I can change my SP
I changed below code in SP but it didn't work
WHERE ([HOuse_info].Region = @Region or @Region='0') or ([House_Info] .District=@District or @District='0')
SELECT @RecordCount = COUNT(*)
I have dropdownlist in my page
In Page_load page I wrote below code
if (!IsPostBack) {
DDL1.Items.Insert(0, new ListItem("select city", "0"));
DDL2.Items.Insert(0, new ListItem("select region", "0"));
DdlDistrict.Items.Insert(0, new ListItem("select district", "0"));
}
And in this page I have btnInsert that when users click on it, it insert data in database
I want when users click on button all textboxs text be clear and all DDL selected Item clear so I set below code in btnInsert event
protected void imginsert_Click(object sender, ImageClickEventArgs e) {
SqlCommand _cmd = new SqlCommand("insertFreg", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
_cmd.Parameters.AddWithValue("@address", txtsdd.Text);
_cmd.Parameters.AddWithValue("@Aname", txtAname.Text);
[Code] .....
But here when I click on button it clear textboxs text but it didn't do any thing on Dropdownlist i.e
If I select 'Paris' from DDL1 when I click on button I want It show in ddl1 'Select city'
But it show 'Paris' again
What should I do?
I have one dropdownList=DDLtradeO and one button=btnsubmit In Admin.aspx page
and I have House_info table that one of column's is T_name
here I want if users select State from DDLtradeO , in House_info table in T_name column insert "STATE"
and if users select other Item from DDLtradeO in T_name column insert "STORE"
so in behind code I wrote below code
protected void btnsubmit(object sender, ImageClickEventArgs e)
{
string T_name = DDLtradeO.Text == "State"?"State":"Store"
SqlCommand _cmd = new SqlCommand("registerspecial", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
_cmd.Parameters.AddWithValue("@T_name", T_name);
_cn.close();
}
but here when I click on State Item or Other Item from DDLtradeO in both case it insert "STORE" in table
i have dropdown list in my page that bind it from database
BindDropDownList(DDL3, "Guidcenter", "Centername", "ID");
DDL3.Items.Insert(0, new ListItem(" select all", "0"));
here when users don't select any thing from dropdown list in data base insert 'select all' text but i want if users don't select any thing from DDL in database insert NULL.
i have 2 page
1-index.aspx
2-state .aspx
when users click on menubar in index.aspx they go to state.aspx in State.aspx is gridview with 6 Dropdownlist that occording to their selected item from DDL they can see result in gridview
now my problem is :
when i click item from menubar in index.aspx when it go to state.aspx it doesn't show any thing in gridview.
i want at first when users go to state.aspx page they can see all data in gridview after that they select item from DDL and see result according to their selected item
SP
ALTER procedure [dbo].[ViewEstate1]
@Type nvarchar(20)
,@Transfer nvarchar(20)
,@measure varchar(20)
,@Zone nvarchar(50)
,@City nvarchar(20)
,@District nvarchar(30)
[CODE]...
I use DropDownList in my page.I want when I select Item from DDL it changed selected Item's color that show in DDL..How I can do it?
View 1 RepliesHow to display the selected value of a dropdownlist in header taemplate of a gridview? As i change the dropdownlist's value, it should also change in the gridview. i have taken a label in the gridview's header template named "lbl_mnth" my dropdownlist's id is "ddl_mnth".
View 1 RepliesOn an action I have the following:
[Code]....
The days list shows fine but the selected value is not 2 but "---". Why?
I have set the Dropdownstyle to DropDown but its still not highlighting the item in the list
<ajaxToolkit:ComboBox ID="cmbstudentid" runat="server"
AppendDataBoundItems="True" AutoPostBack="True"
Font-Names="Tahoma" Font-Size="Small" [code]....
I have one label and one dropdownlist which contain "red" and "blue". When I select "red" from dropdownlist, the label will display "You select RED" and if I select "blue", it will display "You select BLUE". The text is display immediatelly after selected without using BUTTON.
I have try to put the codes in Page_Load but not functioning, below is my code:
[Code]....
Can anyone guide me how to do this and I'm using C#?
i have a dropdown list control which gets data from a database. how do i assign a value to each of the item.
View 3 RepliesBased on the image, how to select the value from dropdownlist, then tick the checkbox and update the value ?
View 1 RepliesURL...I mean when page is loading it show default Item in DDL in red color and show other Item in black color but when I selected another Item from DDL it changed all Items color to red.I want when I changed DDL's Item like before it show selected Item in red color and other items in black color.
View 1 Replies