CodeXchange Sunday, December 16, 2018
What's it?
My Snippets
Add Snippet
Contact Us

Website hosted by

Code Snippet Preview

Review the code snippet before inserting it on your project.

Snippet Metadata
Summary: Sharepoint 2007 Load DropDownList from list that depends on other
Language: C#
Author: Jaime López
Author snippets RSS:
Culture: es
Bytes: 2346
Visual Studio 2005 Snippet:

Snippet Stats
Downloads: 1
Overall rating : 0
Average rating : Snippet rating

Snippet Preview
      /// Generic method to load information in a DropDownList control.
      /// DropDownList control.
      /// List to get data.
      /// Column to get the text for the elements.
      /// Column to get the value for the elements.
      /// This DropDownList control is necessary for fill the DropDownList.
      /// Column to filter values from the DropDownList that depends on.
      private void LoadDropDownList( DropDownList ddl, SPList list, string titleField, string valueField, 
         DropDownList ddlDependsOn, string filterField )
         if ( ddlDependsOn.SelectedIndex < 1 )
            ddl.Enabled = false;
            ddl.Enabled = true;
            ArrayList elements = new ArrayList();
            ListItem li = new ListItem();
            li.Text = "No filtrar";
            li.Value = "0";
            ddl.Items.Add( li );
            for( int i = 0; i < list.ItemCount; i++ )
               li = new ListItem();
                  string filter = "";
                  if ( null == list.Items[i].ContentType.Fields.GetField(filterField) )
                     filter = list.Items[i][list.Items[i].Fields[filterField].InternalName].ToString();
                     filter = list.Items[i][list.Items[i].ContentType.Fields[filterField].InternalName].ToString();
                  if ( filter.Trim().CompareTo( ddlDependsOn.SelectedItem.Text.Trim() ) == 0 )
                     if ( null == list.Items[i].ContentType.Fields.GetField(titleField) )
                        li.Text = list.Items[i][list.Items[i].Fields[titleField].InternalName].ToString();
                        li.Text = list.Items[i][list.Items[i].ContentType.Fields[titleField].InternalName].ToString();
                     if ( null != list.Items[i].Fields.GetField( valueField ) )
                        li.Value = list.Items[i][list.Items[i].Fields[valueField].InternalName].ToString();
                        li.Value = list.Items[i][list.Items[i].ContentType.Fields[valueField].InternalName].ToString();
                     if ( !elements.Contains( li.Text ) )
                        elements.Add( li.Text );
                        ddl.Items.Add( li );
               catch ( Exception )
                  // This exception is for the elements that are in blank or doesn't exists.

Snippet Comments
No comments for this snippet

Other snippets that may interest you..
Related Snippets
TDT - GridPage - Page_Init (C#)
CustomValitaor (C#)
Get the file extension from a file path or file name (VB.NET)
grab record from db and subtracts it from variable (VB.NET)

Copyright ©2009-2018 CodeXchange. Server version 1.0.3720.32855 Client Version

With from Barcelona

Most Helpful members
These are the members who have received the most points for their helpful samples
Zepho Zep
Robert Wagner
Galen Taylor

All time 'Hall of fame'
Formating a file size and adding the B, KB, MB and GB extension appropriately with string.Format (C#)
INI File Access (VB.NET)
Read XML from string into DataSet (C#)
Create Manifest File for your Application (VB.NET)
Round function to avoid banker's rounding (VB.NET)
Get Short and Long Path Names (VB.NET)
Sending Mail through authenticated SMTP server (C#)
One Way Hash for strings (C#)
Formating a file size and adding the B, KB, MB and GB extension appropriately with string.Format (C#)
How do I load an image from a URI address? (VB.NET)
Use our easy to use Visual Studio.NET addin client and start sharing code snippets with the CodeXchange community!
Refreshed: Sunday, December 16, 2018