Web Forms :: Save DropDownList Selected Value?
Oct 8, 2010How can I save dropdownlist selected value? (mabey into cookie?)I have a language selection dropdown, but on page reload it resets te value.
View 9 RepliesHow can I save dropdownlist selected value? (mabey into cookie?)I have a language selection dropdown, but on page reload it resets te value.
View 9 RepliesI am usin MVC 1.0 anc C#.
I want to use a dropdownlist to display some data, and select one of them, then press the button "Create" and the value goes to the DB.
i tried to do sth, but all what i did, is to display the data in the dropdownlist in the view, But for saving the selected value, i ally don't know how to proceed, am on this more than 6h today, i am totalled !
here is the code:
for the view :
[Code]....
and the COntroller :
[Code]....
Based on below SQL code i would like to control the data insert.
Example If select type is 'DM', then only insert into the WM table.
string InserttoWM = ConfigurationManager.ConnectionStrings["CIMProRPT01testserverConnectionString"].ConnectionString;
using (SqlConnection Insertcn = new SqlConnection(InserttoWM))
{
[Code].....
Came accros your article "How to populate DropDownList in GridView in ASP.Net"
[URL] How-to-populate-DropDownList-in-GridView-in-ASPNet.aspx. Was able to duplicate your code w/o any problem. Works. Noticed that the values selected from the DropDownList are not automatically saved in database.
Question: is it possible just by selecting an item from DropDownList and then moving to another row within GridView save a selected value? I mean without using edit/update/cancel buttons but just by selecting an item from the DropDownList.
i ask what code can generate on how to Populate and save ASP.Net Dropdownlist with Selected Value in Gridview Rowupdating ?
View 1 RepliesI 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]....
Two ListBox Items Compare and Distinct Values Insert Into Third ListBox
View 1 Repliesprotected void DDLzone1_SelectedIndexChanged(object sender, EventArgs e)
{
BindDistrict();
}
[Code]......
here when i click on ALL item from ddlzone1 it just "ALL" item in ddldistrict
i want when i select "ALL" item from ddlzone1 in ddldistrict14 show all data from database
I have two pages manager and user both have drop downs as
Week, Months and Years.
User have to enter some data week wise for each months and Manager have to approve that.
To Approve manager select months and week from dropdown on his own page and then navigate to User page.
How does I should bind the drop down so that if manager select 1st week from it's page and goes to view link of user then in drop down of user selected value shold be the same as selected by Manager on his own page.
I am having a problem with disabling DropDownList based on the chice of 1st DropDownList, there is no post back occuring, and it is a template based web app here is the current code:
<script type="text/javascript">
$(function() { var dropDownList1 = $('#<%= ddlUserType.ClientID %>');
var dropDownList2 = $('#<%= ddlMember.ClientID %>'); dropDownList1.change(function(e) {
if ( jQuery("#ddlUserType").val() != "ETOC") dropDownList2.removeAttr('disabled'); e.preventDefault();
else
dropDownList2.removeAttr('enabled'); e.preventDefault(); }
} );
</script>
what is happening now is page is blank and if I remove the above code everything shows, where I am going wrong. here is the plain and final javascript code which worked:
<script language="javascript">
function CheckDropDownState(lstbox)
{
if (lstbox.selectedIndex == 3) { document.forms[0].ddlMember.disabled = 1; }
else { document.forms[0].ddlMember.disabled = 0; }
}
</script>
and thew .aspx code: <asp:dropdownlist id="ddlUserType" runat="server" onclick="CheckDropDownState(this);"></asp:dropdownlist>
what i m trying is i hav two dropdownlists inside the gridview... namely say ddonsiteoffsite and ddhours... now what i want is if the selectedtext of ddonsiteoffsite is "onsite" the ddhours should b disabled... i tried the code snippet but ... its not disabling the ddhours... can someone help me please..
<asp:TemplateColumn HeaderText=" OnSite/OffSite" >
<ItemTemplate>
<asp:DropDownList ID="ddOnsiteOffside" runat="server" onchange="ToggleOnOff(this)">
[code].....
I have a DropDownList shows the company names and a ListBox shows the products of the company I selected in the DropDownList and I can select many products from ListBox:
in sql I have these tables:
1.company: comp_id,comp_name
2.product: prod_id,prod_name
3.Pro_Comp_details:Pro_Comp_ID,Pro_ID,Comp_ID (bridge table)
In .net I have a page with a button to add to bridge table to add a company and many products to it
this is my code but there is something missing
protected void btn_save_add_Click(object sender, EventArgs e) {
poc.Pro_Comp_ID = Convert.ToInt32(txt_prod_of_compID_add.Text);
int id1 = Convert.ToInt32(String.Format("select Comp_ID from Company where Comp_Name = '{0}'", ddl_choose_companyName.SelectedValue));
int[] id2 = new int[ListBox1.Items.Count];
[Code] ...
I am having a 2 dropdown list, in the first dropdown I have 3company names,for each company I am having separate tables,every table have a empcode, if the user select the company name in the 1st dropdownlist, as per company selected the 2nd dropdownlist it will fill the list of employee codes as per the selection..
View 1 RepliesI need to save the selected File in my this location.My Actual path is this \zdcprojectCCHIS_NCHS_NVSSDEVNDI.When I add actula path its not accepting. I am getting this message 'unrecognized escape sequence'.So I replaced with with '\' . When I am executing its returing this path 'Failed to map the path '/zdc/project/CCHIS_NCHS_NVSS/DEV/NDI/'.How can I save my actula path.
[Code]....
I am fairly new to ASP.NET C#, I have a vehicle table which stores basic info about the vehicle, then a vehicle options table that stores the options available on the table.
I have a checkboxlist control on my form and I am populating the list items from the database. I am trying to loop thru the items to determine which ones the user has selected. After determining which ones are selected I need to add rows for each item selected to the vehicle options table.
[Code]....
[Code]....
I am binding months to a list 0-13 items default selection is 0 months duration, and years 0-8 items and 0 years is the default selection.As I know there are always going to be 12 months in a year, I could use selectedvalue or selectedindex without any perceived problem. Is there a reason why I should not use either/or of the two properties to select a list item?
View 2 RepliesI have a gridview and users would select some records and would click on the submit button and i will be saving those records into database using a stored proc.... now .... just below the gridview and above the submit button there are few checkboxes by default they wud be checked. How would i save the selected values and the checked boxes in database i wrote the stored proc for the gridview but how would i save the checked checkboxes into the same table.
For i As Integer = 0 To gvSelectScreen.Rows.Count - 1
Dim chkTemp As CheckBox = TryCast(gvSelectScreen.Rows(i).FindControl("cbStatus"), CheckBox)
If chkTemp.Checked Then
ContractNumber = gvSelectScreen.Rows(i).Cells(0).Text
ClientProgramNumber = gvSelectScreen.Rows(i).Cells(1).Text
ClientProgramName = gvSelectScreen.Rows(i).Cells(2).Text
StartDate = CType(gvSelectScreen.Rows(i).FindControl("txtStartDate"), TextBox).Text
EndDate = gvSelectScreen.Rows(i).Cells(5).Text
Dim connStr As String = ConfigurationManager.ConnectionStrings("MainConnectionString").ConnectionString
Dim myCon As New SqlConnection(connStr)
Dim cmd As New SqlCommand("usp_ParametersFromGrid")
Dim dt As New DataTable
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@ContractNumber", SqlDbType.VarChar, 22).Value = ContractNumber.ToString()
cmd.Parameters.Add("@ClientProgramNumber", SqlDbType.VarChar, 22).Value = ClientProgramNumber.ToString()
cmd.Parameters.Add("@ClientProgramName", SqlDbType.VarChar, 100).Value = ClientProgramName.ToString()
cmd.Parameters.Add("@StartDate", SqlDbType.VarChar, 20).Value = StartDate.ToString()
cmd.Parameters.Add("@EndDate", SqlDbType.VarChar, 20).Value = EndDate.ToString()
cmd.Parameters.Add("@RequestID", SqlDbType.VarChar, 50).Value = RequestID.ToString()
cmd.Connection = myCon
myCon.Open()
cmd.ExecuteNonQuery()
myCon.Close()
End If
Now above the submit button as i said, there are few checkboxes and they are checked by default...how would i save the selected item (in the gridview and the checked checkbox values in the same row in the database(sql server)
i am making use of two listboxes. the data from one listbox is transfered to other listbox on button click, bt teh the data which is selected must be added to the table in the sql server. but it is not storing values it is throwing execption...
private void InsertRecords(StringCollection sc)
{
SqlConnection conn = new SqlConnection("Data Source=ABCD;Integrated Security=True");
StringBuilder sb = new StringBuilder(string.Empty);
[Code].....
My problem is I need to set selected value of a drop down list to a value I retreive from a database. The example only has a know value.
Below is the HTML and Code.
<asp:DropDownList
id="ddlCatogory1st1"
DataSourceID="srcCatogory1st1"
DataTextField="CategoryName"
DataValueField="CategoryID"
AutoPostBack="true"
Runat="server" />
<asp:sqldatasource id="srcCatogory1st1"
ConnectionString="server=(local);database=db;Trusted_Connection=true"
SelectCommand="SELECT CategoryID, CategoryName FROM Categories WHERE ParentCategoryID is null ORDER BY CategoryID"
Runat="server" ></asp:sqldatasource>
Sub Page_Load()
DISPLAY_CATEGORY()
End Sub
Sub DISPLAY_CATEGORY()
ddlCatogory1st1.DataBind()
ddlCatogory1st1.Items.FindByValue("A").Selected = True
End Sub
When I run this page I get
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Line 222:
Line 223: Sub DISPLAY_CATEGORY()
Line 224: ddlCatogory1st1.DataBind()
Line 225: ddlCatogory1st1.Items.FindByValue("A10").Selected = True
Line 226: End Sub
Even if I take out the databind I get the same error.
drpdwncity.SelectedItem.Text = READER("CITY").ToString.Trim
i am using the above code
when the dropdown is displayed it shld display the vlaue from the databse , but here it displays the first value instead
I'm having issues getting the selecteditems and value after Databinding a dropdown list. I have a button event with dropdownlist2.Selecteditem.text, but will always get the "-- Select --" as the SelectedItem.text ?
[Code]....
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 Replieslearning asp.net and prepare my final year project. i've problem in dropdownlist hope i found answer here. I've two dropdown list each consist four listitem as follows
dropdownlist1
uk,usa,india,singapore.
dropdownlist2
uk,usa,india,singapore.
if anyone of the country selected from dropdownlist1 then dropdownlist2 that particular country automatically get masked or readomly