C# - Can Set Dropdownlist Default Values Based On Variables
Mar 9, 2011
I have several pages linked together that I want to maintain drop down selections for. I've seen a number of ways to do this with session values, etc, but I want to set the default value while still having the option of selecting other values.
Effectively, users will make selections on page 1 and then on page 2 they will use those same selections, but also potentially want to change their selections. My thought was that I could load the selections into a table in SQL in page 1 and then in page 2 call that table and set the values as variables. My question, then, is how I would set the default dropdown value to be a variable as opposed to a set value.
I am using VisualStudio2010 with ASP Webforms using C#.
View 5 Replies
Similar Messages:
May 10, 2010
I have a dropdownlist on my view that is being populated from values in a database table and I've added a "--Select One--" header. Selecting a value from this list is optional (it maps to a nullable field in my table). Currently, if a user doesn't select a value from the ddl then it inserts an empty string into the field, wherease I'd prefer to keep it NULL.
View 5 Replies
Aug 20, 2010
I have one drodownlist which show data based om textbox values...
Let us consider i have Select Name from table1 where Type IN(@typ) here @typ is textbox values here for example textbox will have some thing like this L1,L2,L3.. How to filter Name based and shown in drodownlist based on this L1,L2,L3(on textbox)..
View 9 Replies
Jan 21, 2011
I have a dynamically created dropdownbox and image.. I want the result such
View 7 Replies
Apr 27, 2016
How can change the color of dropdownlist with based on their Text
If dropdownlist have listitem Santosh and Arati if santosh color is red if Arati color is blue when page is loading
View 1 Replies
Mar 20, 2014
May i know how to create the control function in asp.net to control the values ?
Based on the DB table, it active is Y then enable values in dropdownlist , if N then disable the values.
View 1 Replies
May 28, 2010
I'm new to web dev and c# so please bare with me. I am trying to create a dynamic gridview in a web form for users to to answer questions with (code below).
The dificulty im having is that i am nesting a dropdwonlist in the gridview and want to be able to dynamically set the list values based on parameters (of the row they are on). These values are in the main dataset for the gridview as each row represents a questionid and question text and then a ddl for the criteria...
I just don't know how to set the values for the dropdown all the code so far is below... just need to be able to populate the dropdowns with the relevant values.
I have created a stored proc to return the different criteria based on the questionid and questionGroupid which is the dataset that populates the other fields in the gridview: dbo.usp_QuestionCriteria @QuestionGroupId, @QuestionId
I have added this as a tableadapter called criteriaTableAdapter in a xsd file as well using the wizard... not sure if this is the right option though or just use the same method as i have for the other stored procedure as in the code below:
[CODE
]using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Sql"].ConnectionString);
con.Open();
SqlCommand com = new SqlCommand("usp_QuestionGroupDS", con);
com.CommandType = CommandType.StoredProcedure;
SqlDataAdapter ada = new SqlDataAdapter(com);
DataSet ds = new DataSet();
ada.Fill(ds);
for (int i = 0; i < ds.Tables.Count; i++)
{
if (ds.Tables[i].Rows.Count > 0)
{
GridView gvDynamicQuestion = new GridView();
gvDynamicQuestion.Width = Unit.Pixel(700);
gvDynamicQuestion.BorderWidth = Unit.Pixel(0);
gvDynamicQuestion.Caption = "<div id="nifty" class="QuestionGroup"> <b class="rtop"><b class="r1"></b><b class="r2"></b><b class="r3"></b><b class="r4"></b></b>" + ds.Tables[i].Rows[0]["Category"].ToString() + " Questions<b class="rbottom"><b
class="r4"></b><b class="r3"></b><b class="r2"></b><b class="r1"></b></b></div>";
gvDynamicQuestion.AutoGenerateColumns = false;
gvDynamicQuestion.ShowFooter = true;
TemplateField tf = null;
tf = new TemplateField();
tf.HeaderTemplate = new DynamicGridViewTextTemplate("QuestionId", DataControlRowType.Header);
tf.ItemTemplate = new DynamicGridViewTextTemplate("QuestionId", DataControlRowType.DataRow);
tf.FooterTemplate = new DynamicGridViewTextTemplate(DataControlRowType.Footer, ds.Tables[i].Rows.Count);
gvDynamicQuestion.Columns.Add(tf);
tf = new TemplateField();
tf.HeaderTemplate = new DynamicGridViewTextTemplate("Question", DataControlRowType.Header);
tf.ItemTemplate = new DynamicGridViewTextTemplate("Question", DataControlRowType.DataRow);
gvDynamicQuestion.Columns.Add(tf);
tf = new TemplateField();
tf.HeaderText = "Criteria";
tf.HeaderTemplate = new DynamicGridViewTextTemplate("Criteria", DataControlRowType.Header);
tf.ItemTemplate = new DynamicGridViewDDLTemplate();
gvDynamicQuestion.Columns.Add(tf);
////tf = new TemplateField();
////tf.HeaderText = "Criteria";
////tf.ItemTemplate = new DynamicGridViewDDLTemplate();
////gvDynamicQuestion.Columns.Add(tf);
gvDynamicQuestion.DataSource = ds.Tables[i];
gvDynamicQuestion.DataBind();
phDynamicGridHolder.Controls.Add(gvDynamicQuestion);
}
}
}
protected void DynamicGrid_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
//
}
}
}
public class DynamicGridViewTextTemplate : ITemplate
{
string _ColName;
DataControlRowType _rowType;
int _Count;
public DynamicGridViewTextTemplate(string ColName, DataControlRowType RowType)
{
_ColName = ColName;
_rowType = RowType;
}
public DynamicGridViewTextTemplate(DataControlRowType RowType, int QuestionCount)
{
_rowType = RowType;
_Count = QuestionCount;
}
public void InstantiateIn(System.Web.UI.Control container)
{
switch (_rowType)
{
case DataControlRowType.Header:
Literal lc = new Literal();
lc.Text = "<b>" + _ColName + "</b>";
container.Controls.Add(lc);
break;
case DataControlRowType.DataRow:
Label lbl = new Label();
lbl.DataBinding += new EventHandler(this.lbl_DataBind);
container.Controls.Add(lbl);
break;
case DataControlRowType.Footer:
Literal flc = new Literal();
flc.Text = "<b>Total No of Questions:" + _Count + "</b>";
container.Controls.Add(flc);
break;
default:
break;
}
}
private void lbl_DataBind(Object sender, EventArgs e)
{
Label lbl = (Label)sender;
GridViewRow row = (GridViewRow)lbl.NamingContainer;
lbl.Text =DataBinder.Eval(row.DataItem, _ColName).ToString();
}
}
public class DynamicGridViewDDLTemplate : ITemplate
{
// Implementation of ITemplate
public void InstantiateIn(System.Web.UI.Control container)
{
// Create a DDL
DropDownList ddl = new DropDownList();
//Attach method to delegate
ddl.DataBinding += new System.EventHandler(this.ddl_DataBind);
container.Controls.Add(ddl);
}
//Method that responds to the DataBinding event
private void ddl_DataBind(object sender, System.EventArgs e)
{
//DropDownList ddl = (DropDownList)sender;
//DataGridItem container = (DataGridItem)ddl.NamingContainer;
//ddl.Data.Checked = [Data binding expression];
}
}
[/CODE]
View 7 Replies
Oct 5, 2012
there is a radio button, a dropdownlist. radiobuttons are OY, OTY,VDA ( in my database there are fields named OY.OTY,VDA) if i select OY in my radio button the data should be displayed from field OY in dropdownlist and if i select OTY in my radio button the data should be displayed from OTY field in dropdownlist is it possible. there is a sqldatasource for dropdownlist .
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MS16ConnectionString %>"
SelectCommand="SELECT DISTINCT OY FROM COURSE_INTAKE">
</asp:SqlDataSource>
THE SELECTED DROPDOWNLIST DATA IS REQUIRDE TO BE DISPLYED IN A GRIDVIEW.
View 1 Replies
Jan 16, 2010
if there is a way to determine if the default document has been served using .net? I thought perhaps something would be available in the server variables, but I can't seem to find anything that distinguishes between [URL] and [URL]
View 3 Replies
Dec 3, 2010
i am looking for a easy & elegant way to change my appsettings in web.config based on the different environment and i have (dev/qa/test/stage/prod) and i am manually changing the appsettings and its very tedious and time consuming and i have about dozens of settings.... what is the best approach for this kinda situation? i know one solution using Environment variables but wants to hear the best practice?
View 8 Replies
Apr 19, 2010
I am using form based authentication in one of my website. I issue AuthenticationTicket on successful login and use this ticket to validate request. but now I need to store other variables immidiately after authenticating request (just like adding session for username, email etc. variable after successful login).
My question is if I make use of session to store variables, do I need to concern about it as form based authemtication is cookie based and it is not related with session timeout.
View 3 Replies
Sep 2, 2012
i have 2 DDL in my page that when users select item from ddldistric1 item in ddlcity1 will change these are my code
protected void DDLcity1_SelectedIndexChanged(object sender, EventArgs e)
{
BindDistrictC();
}
private void BindDistrictC()
[code]...
View 1 Replies
Apr 15, 2010
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>
View 2 Replies
Jan 11, 2011
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].....
View 2 Replies
Sep 18, 2010
I am making an application that deals with vehicles. I need two DropDownLists:
Makes: All Vehicle Makes
Models: Models that belong to the selected value of the Make DropDownList
How is this done in MVC2? My Idea: Do I use an ajax call when my first list is selected and then pull back the Models to bind to the Model DDL? How would model binding come into play that way? UPDATE I posted what I ended up doing as an answer. It is super simple and works great. You can use a get too if you feel so inclined, but you have to specify that you want to like so... return Json(citiesList, JsonRequestBehavior.AllowGet);
View 4 Replies
Jun 14, 2010
I've got some ASP pages where the session variable values get blown away BEFORE the session times out. I can't understand it. For example: if a user logs into my ASP app using his password which is stored in a session variable, it will be fully accessible for a few minutes and then all of a sudden.....Wham session variable with password value is gone. And the session timeout is far from expired. The session variable is not being touched in any way after it gets initialized with a value.
View 3 Replies
Dec 2, 2010
I have a Sql string something like this.string sqlstring = "Select field1, field2 from table1 where field1 = 1 and field2 = 'xxx' group by field1, field2 order by field1 asc" Question: During runtime, based on the user selection, I have to replace 1 and xxx in the sql string.What is the best way to do this?
View 3 Replies
Sep 23, 2010
From this webpage: http://abg.asso.fr/Page/Offer/SearchOffer.aspx , I want to have a link which shows me directly 50 job openings in a specific (Engineering) domain (the default is 5 jobs in all categories).I know that in ASP, I can transmit a variable value by
[Code]....
But it is not working.
View 4 Replies
Jul 1, 2010
I am looking to cache a dataset and then filter the results as they will be used repeatedly. However, I don't know how to assign values in the filtered dataset to variables in C#. I have looked on the internet for the past few hours but all I can get in binding the dataset to a control.
View 4 Replies
May 11, 2010
I have a detailsview with template fields. when i go into edit mode i am trying to set the selectedvalue of a dropdownlist to be the value of the corresponding label from the item template in code behind as once i go into edit mode i loose the initial value from the detailsview and the dropdownlist defaults to the first listitem. what i am doing is onDataBinding of the detailsview i access the cell value of the label , i then assign that to a public variable but once i've exited the routine the public variable looses the value of the detailsview cell i've just assigned to it. this is the value i'm hoping to assign to the selectedvalue of the dropdownlist when i go into editmode. The reason i'm doing it this way is although i can use bind in the html to mantain the dropdownlist selected value between detailsview states once i come to update the detailview i get the following error
Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.to work arround this i've had to assign the values to update paramteres also in code behind. here's my code behind page i've bolded the routines in question. drpDataStoreDDL is the variable in question.
[Code]....
View 1 Replies
Oct 18, 2010
We are working in a web application using Session variables to store the clients ID to operate with them in all app (making orders, reports, etc....) but randomly users get the client ID of another user in any moment using the application.
I have tried to solve it in a first step adding to system.web section in the web.config file this:
[Code]....
ASP.NET State Service is running in server normally, It began run just before this last change, but we have not solved the problem either with this solution.
The server is Windows Server 2003 Standard Edition SP2 32bits running IIS 6.0, and the application is made with Framework 2.0
View 12 Replies
Mar 6, 2010
I need to declare a variable xyz, then, using a select statement, pass a variable into it so I can then insert it into a table.
Dim @xyz As
Integer
set @xyz = (select xyz
from systable)
1. I get a squiggly line below the @.
2. I get informed that set and let are no longer supported.
3. When I remove the @ I get the squiggly below select.
View 7 Replies
Mar 16, 2011
How to get a dropdown list to use my own query, because i couldnt figure out how to use my variables in asp.net's configuration.
how i can get the dropdown list to read the data returned from my query?
protected void
Page_Load(object sender,
EventArgs e)
{
[Code]....
View 5 Replies
Jan 6, 2010
I have two user controls both have a repeater and a button. They are both on a .aspx page. I need to capture the values from those two buttons on the user controls in variables on the .aspx page. Right now, I have two labels on the page that I am outputting the values of the buttons to, but they don't have a value right now, which is my problem.
View 5 Replies
Feb 9, 2011
I have an intranet ASP.NET web application in which I need to get the IP of the client's machine. I do this vis the following code:
HttpContext.Current.Request.ServerVariables.Item("REMOTE_HOST")
It used to work when my ASP.NET site was only hosted on a single server. However once we got the load balancer installed and migrated our apps to a web farm, the code above returns the IP of the Load Balancer device and not of the client anymore.
I am working with the networking folks to determine what can be configured differently with the load balancer, but in the meantime I was wondering if there was another way I could get the client's IP other than using that IIS Server Variable?
View 1 Replies
