Bind DropDownList With Hierarchy From SQL Server Table?

Apr 27, 2010

I have the following sql table which contains menu (website menu) data.

Table Name: MenuItems Columns: Id, MenuId, ParentMenuItemId, Text.

My goal is to bind a DDL according to the following hierarchy (example):

Id: 1, MenuId: 1, ParentMenuItemId: -1, Text: 'One'
Id: 2, MenuId: 1, ParentMenuItemId: 1, Text: 'Two'
Id: 3, MenuId: 1, ParentMenuItemId: 1, Text: 'Three'
Id: 4, MenuId: 1, ParentMenuItemId: 2, Text: 'Four'
Id: 5, MenuId: 1, ParentMenuItemId: 4, Text: 'Five'

Requested result in DDL:

One
-- Two
---- Four
------ Five
-- Three

I think it should contain 'WITH' SQL command.

Note: I'm using C#.

View 1 Replies


Similar Messages:

Forms Data Controls :: How To Bind Hierarchy Grids From Ojects Or Lists

Aug 14, 2010

i have Successfully binded the Schedular from Objects and its looking Good and the Following code has done that.i am using the Telerik Grid , but the implementation to the grid is the same as the Gridview. What i need is a guidance on how to bind hierachy grids from ojects or lists

[Code]....

Now with the same results i want to bind a Hierachy Grid as it Shows in my attached image. I am using EAE that means the is no Fixed Column name, so the Binding of the Grid Should be Dynamically.

View 2 Replies

How To Bind Data From Database Table To A Dropdownlist Nested In A Gridview

Feb 15, 2011

how to bind data from database table to a dropdownlist nested in a gridview

View 1 Replies

How To Populate Folder Hierarchy Into DropDownList

Jan 19, 2010

write a Subroutine that takes a parameter value of a Folder name on the server, then looks for all subdirectories beneath it and puts this hierarchy into a DropDownList?

So far I can't get the sub to work as it stuggles with the path structure and the obvious requirement to call itself.

View 3 Replies

Forms Data Controls :: How To Add Lookup Table Values To A DropDownList And Bind To A FKValue In The Grid

Jan 26, 2011

I have a GridView control that has a SQLDataSource.

The GridView provides me with a list of musical artists (from the tblArtists)

In the Grid, I have a field, FKGenreID, that is a Foreign Key value for music Genres.

(An example of the data in that field would be "7", which upon lookup would mean Classical in the
tblGenreList table.)

What I'd like to do is add a DropDownList control that looks up the tblGenreList table and populates the DropDownList with the ID and Description from the tblGenreList Lookup table.

Now the tricky part is that if the GridView field (FKGenreID) has a value, then I'd like the corresponding Genre Description to be displayed in the DropDownList

Alternately, if there is no value for FKGenreID in the GridView, then I'd like the DropDownList to show that nothing was selected, but have the list of Genres available.

Most importantly here, when the user makes a selection, I'd like the GenreID (from the DropDownList) to be entered into the FKGenreID field in the GridView field.

My thought is that a gridview record may or may not have a value in the FKGenreID field. Either way, the DropDownList is bound to that field. The DropDownList would display a list ofGenre Descriptions for the user to select from. Upon selection, the GenreID column of the DropDownList becomes the value in for the FKGenreID field in the GridView.

Is this possible?

In case it matters, I'm using ASP.NET 4, Visual Studio 2010, and coding in VB

View 1 Replies

Data Controls :: Bind Cascading Dropdownlist To Show State And City Which Is Stored In Table

Apr 27, 2016

Into my application there is EditAds.aspx page where the user get a link on his email after he add an Ad into my application. My inquiry is can i bind the cascading ddl to show the value of State column into Ad/product row as well if the user want to update the rest of state will be also reachable. It maybe hard to get what i am looking for exactly so i make a short screen record ...

Rebinding values of Ad/product depending on AdsID which is  a query string in the page called: QADNUM

[URL] ....

if (!IsPostBack)
{
if (cookie["Location"] == null)
{
DataTable rEfilterstathpBizDT = new DataTable();
using (SqlConnection REGGfilterstathpBizCon = new SqlConnection(sc))

[Code] ......

View 1 Replies

Retrieve Values Related To Hierarchy Of City,country And State From Dropdownlist?

Apr 21, 2010

retrieving values related to user select a country then its automatically shows the states name of that country in next dropdownlist and after that it will automatically display the city names respected to that country.

View 6 Replies

SQL Server :: Name From Table A ,minimum Rate1 And Rate2 Values For A Month In A Dropdownlist From Date Field From Table B?

Nov 19, 2010

I need to write a query to populate a gridview with minimum rates in ascending order for a month from three tables.For example i have three tables A,B,C as follows

TABLE A TABLE B
TABLE C
Id id id
Quote_no Quote_no Quote_ no
Name Rate1 Equip_name
Rate2 E_rate
Date R1_rate
R2_rate
Date

Now if the data is as follows

I need to get the Name from Table A ,minimum Rate1 and Rate2 values for a month in a dropdownlist from date field from Table B and the corresponding minimum rate(E_rate) for Equipment E1 and E2 only from Table C for the month in ascending order group by Name.

TABLE A

id
Quote_no
Name
1
101
XYZ

2
102
ABC
TABLE B
id
Quote_no
Rate1
Rate2
Date

1
101
105
200
12/11/2010

2
102
90
210
15/11/2010

TABLE C
id
Quote_no
Equip_name
E_rate
R1_rate
R2_Rate
Date

1
101
E1
60
0
0
12/11/2010

1
101
R1
0
110
0
12/11/2010

1
101
E2
80
0
0
12/11/2010

2
102
R2
0
0
300
15/11/2010

2
102
E2
100
0
0
15/11/2010

2
102
R1
0
60
0
15/11/2010

2
102
E1
230
0
0
15/11/2010

View 9 Replies

Web Forms :: Load XML From Remote Server And Bind It To DropDownList

Jun 14, 2012

I need to load xml from following [URL] .... and bind that xml contents to dropdownlist .... How can i do that ....

View 1 Replies

SQL Server :: Table Joins And Datasets To Bind The Gridview In Page

Mar 25, 2011

I have a web service with a dataset and I need to fill a gridview in my web page with data from multiple tables (like 4). How can I retrieve data from my 4 tables and construct a datatable with a table adapter in the dataset? I need to create this in the web service to bind the gridview in my page. In SQL I create a view with the joins of the 4 tables and added the view to the dataset. It works fine, but for other windows in my web page I need to use like 8 trough 10 tables (just to retrieve one field of each one) and I don't know if making that huge joins is the more efficient way to retrieve data from the server. There is another way to make joins? (Make separate queries for each table and create one table in memory) How?

View 2 Replies

Forms Data Controls :: How To Extract Value From A Dropdownlist After Bind 7 Column Name In A Dropdownlist

Mar 29, 2011

I have a table and 7 column name.

I bind the 7 column name in one dropdownlist.

Now the problem is,how do I extract the data value in a dropdownlist?

For example,

Dropdownlist contain 7 column name

-subject_name

-subject_code

-venue

-time

-seat_no

-admission_no

-subject_id

when I click the subject_name,I want it to appear in a gridview

Example

Math|9.00-10.00|Hall|18|09090J|...

Below is my current codes which I have a problem.

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source= EN\SQLEXPRESS;" + "Initial Catalog=ms;Integrated Security=SSPI");
SqlDataAdapter adapSel;
string mySQL = "SELECT '" + dd_list.SelectedValue+ "' FROM examtimetable ";
adapSel = new SqlDataAdapter(mySQL, conn);
conn.Open();
DataSet dsSel = new DataSet();
adapSel.Fill(dsSel);
GridView1.DataSource = dsSel;
GridView1.DataBind();
conn.Close();
}
Previously I have bind 7 column name in my dropdownlist
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
SqlConnection conn = new SqlConnection("Data Source= EN\SQLEXPRESS;" + "Initial Catalog=ms;Integrated Security=SSPI");
SqlCommand sqlCmd = new SqlCommand("select column_name from information_schema.columns where table_name='examtimetable' and COLUMN_NAME not like '%ID'", conn);
conn.Open();
SqlDataReader ds;
ds = sqlCmd.ExecuteReader();
dd_list.Items.Clear();
dd_list.DataSource = ds;
dd_list.DataTextField = "Column_Name";
dd_list.DataValueField = "Column_Name";
dd_list.DataBind();
dd_list.Items.Insert(0, "Select Option");
ds.Close();
conn.Close();
}
}

View 10 Replies

Web Forms :: Nested Dropdownlist Ondatabound => Bind Other Dropdownlist Fail

Dec 9, 2010

I have a gridview with 3 nested dropdownlists in one cell on edit like this:To get the exact fields when the user clicks on edit I used the following code(yes it's messy)

[Code]....

The BLLOnderhoud is a class and the getReserveInfo is used to get the Model - Brand(merk) Information.Since the dropdownlists are nested in the gridview I can't call them directly and they can't call any of my functions.And this is the problem, when I change the dropdownfield Model the Auto field wich is the last dropdown(in the picture is a typo) should be binded like in the following code:

[Code]....

But the dropdownlist onDataBound event can't call any of my functions that are in my class.So my question is how can the onDataBound event of the second dropbox trigger a function? The only thing that the function has to do is to bind the 3rd dropdownlist

View 4 Replies

Data Controls :: Using DropDownList In Gridview And Bind Values In DropDownList

Oct 9, 2012

Using  dropdown in gridview and bind the values in dropdown then based on dropdown display the value in another column.

View 1 Replies

Unable To Bind DropDownList Using ADO.NET

Aug 28, 2010

I m using the following code to bind dropdownlist using ADO.NET

Code:
Protected Sub HeadsData()
Dim conn As SqlConnection
Dim cmd As SqlCommand
Dim reader As SqlDataReader
Dim constr As String = ConfigurationManager.ConnectionStrings("ams").ConnectionString
conn = New SqlConnection(constr)
cmd = New SqlCommand("Select HeadId,HeadName from Heads Order By HeadName", conn)
conn.Open()
reader = cmd.ExecuteReader()
While reader.Read
cmbType.DataSource = reader
cmbType.DataTextField = "HeadName"
cmbType.DataValueField = "HeadId"
cmbType.DataBind()
End While
End Sub

I have 5 records in Heads table, but when i run the project it misses the first record and shows the remaining 4 in dropdownlist. Is there anything worng with this code ?

View 4 Replies

Way To Bind Values With Dropdownlist

Apr 28, 2010

binding values with dropdownlist.i have one dropdownlist name,dropdowndiagnosticcategory..i have made one function bind_category() for binding the category values.The code for binding the values with dropdownlist is as under,here

private void bind_category()
{
string s = "Data Source=LAB1-40;Initial Catalog=MNSDaignosticCenter;Integrated Security=True";
SqlConnection con = new SqlConnection(s);
con.Open();
SqlCommand cmd = new SqlCommand
[code]...

View 2 Replies

MVC :: How To Bind Dropdownlist Box Through List

Aug 14, 2010

How to bind Dropdownlist box in mvc through list

i m not able bind fdata in drop dow

View 3 Replies

MVC :: How To Bind Values To Dropdownlist

Aug 25, 2010

I'm using asp.net MVC 2.0, my controller coding is,

[code]...

i need to bind this value to the drpdown list in the aspx page.

[code]...

View 4 Replies

Bind XML From Webservice To A Dropdownlist?

Jul 19, 2010

how do i bind a xml (http://www.webservicex.net/country.asmx/GetCountries) to a dropdownlist? Currently I'm working with ASP.NET 2.0.

View 2 Replies

Bind DropDownList Within GridView?

May 5, 2010

I have a DropDownList in my Gridview. How do I populate this DropDownList which is the EditItem Template?

[Code].....

I'm not sure if I'm doing it right. I googled and couldnt find any article on binding DropDownList in Gridview without the SqlDataSource.

View 5 Replies

Using Eval To Bind A Dropdownlist?

May 19, 2010

I have a dropdownlist that gets data through entity objects, but with a navigation. But I get an error trying to do this.

<asp:DropDownList ID="ddlVacancy" DataValueField="ID" DataTextField='<%# Eval("Position.Name") %>'
runat="server" Width="200px"/>

View 1 Replies

C# - Bind A Dictionary<K,V> To A DropDownList

Sep 29, 2010

I was wondering why this doesn't work:

Is it possible to declaratively bind to an Object's property.

<asp:DropDownList id="ddl" runat="server"
DataValueField="Key"
DataTextField="Value.DisplayName" />


Code Behind

var d = new Dictionary<int, MailAddress>();
d.Add(0,new MailAddress("foo@bar.com", "Mr. Foo");
d.Add(1,new MailAddress("bar@foo.com", "Mr. Bar");

ddl.DataSource = d;
ddl.DataBind(); // Error. It doesn't like "DisplayName"

View 3 Replies

Bind Data To Dropdownlist From Datasource

Jun 11, 2010

how to bind data to dropdownlist in asp.net ....

View 10 Replies

C# - How To Bind Enum Types To The DropDownList

Jun 23, 2010

If have the following enum

public enum EmployeeType
{
Manager = 1,
TeamLeader,
Senior,
Junior
}

and i have DropDownList and i want to bind this enum to it .. is it any way to do that ?

View 1 Replies

Bind Generic List To DropDownList?

Feb 22, 2011

I am trying to bind generic list to DropDownList an i am not sure how to continue.

[Code]....

View 3 Replies

Can Bind The An Interval Of 100 Years With A Dropdownlist

May 27, 2010

How can i bind the an interval of 100 years with a dropdownlist.

To be more precise, I want to bind 1990 to 2010 to a dropdownlist .

View 5 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved