I have a MVC dropdown list (Html.DropDownList) with list of Movies populated. I want to retrieve both Title(value field), Description(Text field) when I perform the form Submit. I can access the Title(value field), but I can't access the description. My code sample is below.
[Code]....
public string CinemaName { get; set; }
so I have the following html.dropdownlist;
[Code]....
how do I get the value/item selected in my controller?
i have the following two questions:-
1. let say i have a table for ITEMS including (item id,item description id (FK to the ITEM Description tabe), item price,etc) and have ITEM Description look up table having (item descriptionid,item description),.
so what is better to use the ITEM DESCRIPTION look up table and store the item description id in the items table
or
to directly store the item description "Not the id" in the item table.
2. I am working on an MVC web application using LINQ, now if i want to modify the SQL server tables which i have created for example modify some of the foreign key properties will the effect be directly reflected on any new inserted or deleted records or i have to create a new LINQ to SQL class?
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 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 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 two dropdownlist , i want to add item in dropdownlist 2 from database if the city is changed in first dropdownlist..I am using access database
here is my code:
[code]....
but when i select any text , it will not show anything in dropdownlist2 ..
I have a DropDownList in a template column of a GridView control. The GridView is bound to a list of objects. Each object has a property of type int which corresponds to a value in one of the DropDownLists ListItems. I could set the selected item programatically by adding a DataBind event to the drop down, but I'm wondering if there's a way to set the selected item by using a code block in the aspx markup.
View 3 RepliesVWD 2008 Express. Visual Basic. SQL Server 2005.
I have a dropdownlist whose datasource is a SQLDataSource. The select command is:
SelectCommand="SELECT
[JailID], [strName] + ', ' + [strState] as JDName, [nJurID] FROM [JailArea]"
The DropDownList definition is:
[Code]....
[Code]....
i have created a DropDownList as
[Code]....
but the item is not select, instead of the first is select
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] ....
Given the following
public class MyControl : CompositeControl
{
private DropDownList myList;
protected override void CreateChildControls()
{
base.CreateChildControls();
myList = new DropDownList();
myList.AutoPostBack = true;
this.Controls.Add(myList);
if (!Page.IsPostBack)
{
myList.DataSource = MyBLL.SomeCollectionOfItems;
myList.DataBind();
}
}
}
I find that the items in the list persist properly, but when a different control is rendered and then this one is rendered again, the last selected item is not persisted. (The first item in the list is always selected instead)
Should the last selected item be persisted in ViewState automatically, or am I expecting too much?
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 RepliesI have a ASP DropDownList that gets populated on the Page_Load event, after i select an item and hit a button the selected item gets cleared and the first item in the DropDownList gets selected. (The DropDownList is only populated when the page is not postback)
if (!IsPostBack)
{
List<Country> lCountries = new List<Country>();
List<CompanySchedule> lCompanySchedules = new List<CompanySchedule>();
this.Load_Countries(lCountries);
[code]...
Maybe I'm losing my mind - I thought this was straight forward.
ListCode.DataTextField = "code_desc";
ListCode.DataValueField = "code_id";
ListCode.DataSource = Foo.GetCodes();
ListCode.DataBind();
The selection mode is set to multipls and all is good, about 50 items with appropriate values displays. Then I select 5 items and submit the form.
I have a number of dropdownlists embedded in a gridview. When I submit the page I loop through all the rows of the gridview and use the findcontrol method to get the dropdownlist e.g:
foreach (GridViewRow gvrItem in gvItems.Rows)
{
DropDownList ddlOption = gvrItem.Cells[2].FindControl("ddlOption") as DropDownList;
}
This works nicely, however when I try to get the selected item of the dropdownlist e.g:
ddlOption .SelectedItem.Text
It always returns the first item in the list rather than whats actually selecte din the page.
I have been trying to figure out what the proper method is to be able to have a dropdownlist on the same form that holds a number of textboxes for properties. I am using a strongly typed typed view which was generated by the Visual Studio IDE so it contains textboxes for all of the properties of my strongly typed class. The class has a few properties that can have a set of possilbe answers; I'd like to displat those possible answers in a dropdownlist and then when the user fills in the form and clicks the submit button the selected item would be transferred to the correct property. I have a solution but think there must be a better solution out there and was wondering if anyone might point me in the right direction.So say I have a model with 3 properties, FirstName, LastName. and MaritalStatus.If I generated a view for this then I'd get an aspx file with the following:
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
based 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 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 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]...
