i am trying to search from 2 dropdown lit from my databse (sqlserver)
1st drop down list contain(Dr, Hospital, Bloodbank) and 2nd dropdown contain areas(like in hyderabd areas are HITECK CITY, VIDYANAGAR, DILSUKHNAGAR and so any)
how to serach from dropdown list.
I have an .aspx file that has 3 drop down lists:
ddlMake
ddlModel
ddlColour
i have a Page_Load function but i cant acces them in the Page_Load function...
using System;
using System.Collections.Generic;
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;
namespace NorthwindCascading
{
public partial class _IndexBasic : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CarService service = new CarService();
List<string> Makes = service.GetCarMakes();
ddlMake.DataSource = Makes;
ddlMake.DataBind();
ddlMake.Items.Insert(0, " -- Select Make -- ");
}
}
}
}
I have added the code-behind file manually so i guess i am missing something... it just says that the ddlMake element is not defined in current context.
Basicly i have created a database in access with 2 tables the secind table has a drop down with the field infor from the first.
Now when i link the database to the VB and insert the combo box in form the selecetion is not there?
What do i have to further deffine to appear?
I have a formview on my aspx page containing various controls arranged using table. There is a DDL "cboClients" which i need to enable or disabled depending upon role within Edit mode.
The problem here is that i am not able to get that control using FindControl() method.
I have tried following code -
DropDownList ddl = null;
if (FormView1.Row != null)
{
ddl = (DropDownList)FormView1.Row.FindControl("cboClients");
ddl.Enabled=false;
}
Even I ave used the DataBound event of the same control -
protected void cboClients_DataBound(object sender, EventArgs e)
{
if (FormView1.CurrentMode == FormViewMode.Edit)
{
if ((Session["RoleName"].ToString().Equals("Clients")) || (Session["RoleName"].ToString().Equals("Suppliers")))
{
DropDownList ddl = (DropDownList)sender;
ddl.Enabled = false;
}
}
}
But this databound event occurs only once, but not when formview mode is changed.
I was wondering if there is any way that I could have a null value (or any other static value) appear at the top of a drop down list which is then populated from an AccessDataSource.I need it so that users can select a tag for their post (within a social networking system) if they wish to post to a group page or they can simply leave the list as null to post to their profile.
View 1 RepliesI'm struggling with a web form where I have created one date field and couple of drop down lists. These drop down lists populate themselves from a backend MS ACCESS database file. My problem is that I am not able to make the two drop down menus dependent in a manner that when the first drop down menu is selected the second should be populated accordingly?
This is the code for the website form:
[Code].....
How do i fill radio button list and drop downlist from database.
View 3 Replies I have a table Person (in my database) which has fields like PersonID, PersonName, PersonSurname, etc. What I'd like to do is to bind the PersonName + PersonSurname (e.g. Mark Black) as values for displaying the data in drop down list and PersonID as the data identifier.
As I'm still new with Entity Framework I'm not sure how to manage to do it.
how do i get the selected item in the drop down list and insert it into database (togethi populated the drop down with the values from the tables in database. It is dynamic, not static.i have a button in the gridview called 'add'. so when user clicks on it the row (whatever columns in the row) would be inserted into database. i am doing insertion/create for this.
View 14 Repliesi have a small app. the database has two tables. Category(CategoryId, Category), Quote(Id, CategoryId, Quote) these two tables are related via FK (CategoryId). In my page i have a simple drop down list, button and lable. user selects a value from drop down list like 'politics', 'comedy', 'famous' etc and then they hit the generate quote which should fetch a quote from the quotes table by passing a value like 'politics'.
however, i need to pass an int value (ID) from my drop down since that is the value which will fetch corresponding quote using my SP but (1) how do i pass a drop down value's ID and (2) is the SP below correctly done?
SP code:
ALTER PROCEDURE [dbo].[GetQuote] (@CategoryId VARCHAR(2))
I have a drop down list that has the initials of about 12 of our sales guys.How can I make it so that when they select their initials from the list, the next drop down list only shows their customers.In my database there is a column for customer name and salesman.
View 6 RepliesI'm building a small website using ASP.net/C# and I wanted to know how to implement a simple search feature using a text box and a dropdown.
The datasource is a products table and in the text box I enter the product's name and in the dropdown are the categories. (I have managed to populate the dropdown with the available categories already)
It must follow these conditions:
If both text box and dropdown are blank all products must be listed;
If a category is chosen all products from that category must be listed;
If only text is filled, all products that match are shown;
I wanna save the order of my list to the sql server database in jquery drag & drop using asp.net c#. How can I do this?
View 1 RepliesI have a query give me two column and several rows say 20.
The first column i want to bind with dropdown list and second to textbox.
i would like to dynamically create dropdown list as well as textbox as i do not know how many rows i will get it every time.
My select query is like this -
"select subcatid,categoryname from category where catid=10"
That give me say 12 rows with two columns,i want to select the subcatid and bind it with dropdown list and categoryname to textbox that can be edited by user.
my access database consists of 2 tables. i name it table A and table B.
my idea is, i would like to search the data inside these table A and table B by using a text box and a button.
and 2 radio button are used to control whether data inside table A or data inside table B to be search.
'm using SQLServer Freetext for my search page. My Search page consists of a textbox where the user can enter freetext and next to the textbox I've got a dropdown which enables the user to refine the search (Catagories). My problem with my search is ... if a user type for exam Dog in the search textbox and he doesn't use the dropdown to refine his search ... no data will be displayed although Dog exists in my database. But if the user type Dog in the textbox and this time he select animal (as a catagory) from the dropdown ... then results will be displayed. In a nutshell I would like to have the functionailty that allows a user to search only by keywords typed in the search textbox apart from using the dropdown (catagory) as well.
View 2 RepliesHow can I have 2 Cascading Drop Down Lists for the same Drop Down List?here is my problemi have 3 drop down lists read from database1- Schools List 2- Classes List3- Teachers ListEvery School will have more than 1 Class and more than 1 TeacherWhat I want is when user select a School from Schools Drop Down List then BOTH (Classes and Teachers) should be refreshed based on the School Drop Down List
View 1 RepliesI have drop down list box that I would like to show two columns, is this possible? Or can it be done with a list box?The query correctly retrieves all of the table data to be displayed, one colum is an abbreviation, the other a bit longer description.
View 2 RepliesI have the following Students class:
[Code]....
I need the 1 since it's a foreign key in another table. For the life of me, I can't get this to work like this.
I have a requirement in my application that, while saving the application, need to get all the value from drop down list and pass it to the view model. But application should not allow the user to select more than one item from drop down list manually, ie, only one value at a time. My view model is like ...
public class ListManagement
{
public IEnumerable<selectListItem> InactiveProduct { get; set; }
public string[] InactiveProductSelected { get; set; }
public IEnumerable<selectListItem> ActiveProduct { get; set; }
}
[code]...
I am getting this error yet I know it to be untrue.This is the code:
ddlPartnerOrganisation.DataSource = agency.AgencyGetListOfEYDN();
string temp = ddlPartnerOrganisation.SelectedValue.ToString();
ddlPartnerOrganisation.DataValueField = "AgencyID"
;
ddlPartnerOrganisation.DataTextField = "AgencyName"
;
ddlPartnerOrganisation.DataBind();
Embarrassed that I'm stuck on this I've downlaoded sqlserver express 2008 R2 and VS web developer 2010. Set up a databse wrote a mini test site and am now trying to connect to my database to fetch records back. However i'm getting the error message "Invalid object name 'customer'." (I have a feeling its running it on the master db and not my 'customerdb' but can't prove this as express doesn't have a profiler).
Here is my code;
[Code]....
I have two drop down list on a page. The first one list projects and the second list users. The userlist is populated with an object datasourse that pulls a list of users for the selected Project.Whenever the Project list selection changes the second ddl Userlist always reverts to the first person in the list instead the person that was selected before a new Project was chosen.
View 1 RepliesI am trying to create an MVC List View that can be filtered by the value selected from a drop down list.
Selecting a value should repost the page ... Since there is no concept of view state data I am having some issues with this ... I can get the repost to take place but my drop down resets and I am not able to get the value that was selected.
ASSET CONTROLLER:
[Code]....
[Code]....
I have tried many of the posts that refer to setting up drop down lists but can't set them up in the content because this is a List View.
how to create the forum database in sqlserver. what tables & columns are required in it .
View 3 Replies
