Click here to Skip to main content
       

C#

 
AnswerRe: SqlConnection vs IDbConnection PinmemberSimon_Whale14-Jan-13 0:01 
QuestionLINQ with List PinmemberMember 873185913-Jan-13 9:48 
AnswerRe: LINQ with List PinmemberJ4amieC13-Jan-13 21:47 
AnswerRe: LINQ with List PinmemberSimon_Whale14-Jan-13 1:17 
GeneralRe: LINQ with List PinmemberMember 875312115-Jan-13 6:35 
AnswerRe: LINQ with List PinmemberMember 873185921-Jan-13 6:36 
Questionhow i get data from datatable Pinmembera1_shay13-Jan-13 6:58 
AnswerRe: how i get data from datatable [modified] PinmemberPIEBALDconsult13-Jan-13 13:38 
I can't quite tell what you are trying to do there, but (dt is a DataTable, right?) you could try:
 
dt.DefaultView.RowFilter = "area=" + areaname ;
DropDownList2.DataSource = dt.DefaultView ;
 
Edit: Here's a full working example.
 
            System.Data.DataRow dr ;
 
// Define a State table
            System.Data.DataTable state = new System.Data.DataTable("State");
            state.Columns.Add(new System.Data.DataColumn("ID",typeof(int)));
            state.Columns.Add(new System.Data.DataColumn("Name",typeof(string)));
 
// Add some rows
            dr = state.NewRow() ;
            dr [ "ID" ] = 1 ;
            dr [ "Name" ] = "Arizona" ;
            state.Rows.Add ( dr ) ;
 
            dr = state.NewRow() ;
            dr [ "ID" ] = 2 ;
            dr [ "Name" ] = "California" ;
            state.Rows.Add ( dr ) ;
 
// Set the first ComboBox to display the table
            this.comboBox1.DataSource = state.DefaultView ;
            this.comboBox1.DisplayMember = "Name" ;
 
// Define a City table
            System.Data.DataTable city = new System.Data.DataTable("State");
            city.Columns.Add(new System.Data.DataColumn("ID",typeof(int)));
            city.Columns.Add(new System.Data.DataColumn("State",typeof(int)));
            city.Columns.Add(new System.Data.DataColumn("Name",typeof(string)));
 
// Add some rows
            dr = city.NewRow() ;
            dr [ "ID" ] = 1 ;
            dr [ "State" ] = 1 ;
            dr [ "Name" ] = "Phoenix" ;
            city.Rows.Add ( dr ) ;
 
            dr = city.NewRow() ;
            dr [ "ID" ] = 2 ;
            dr [ "State" ] = 1 ;
            dr [ "Name" ] = "Tucson" ;
            city.Rows.Add ( dr ) ;
 
            dr = city.NewRow() ;
            dr [ "ID" ] = 3 ;
            dr [ "State" ] = 2 ;
            dr [ "Name" ] = "San Diego" ;
            city.Rows.Add ( dr ) ;
 
            dr = city.NewRow() ;
            dr [ "ID" ] = 4 ;
            dr [ "State" ] = 2 ;
            dr [ "Name" ] = "Los Angeles" ;
            city.Rows.Add ( dr ) ;
 
// Set the second ComboBox to display the table
            this.comboBox2.DataSource = city.DefaultView ;
            this.comboBox2.DisplayMember = "Name" ;
 
// Add a SelectedIndexChanged handler
            this.comboBox1.SelectedIndexChanged += delegate ( object sender , System.EventArgs e )
            {
                System.Data.DataRowView item = this.comboBox1.SelectedItem as System.Data.DataRowView ;
 
                city.DefaultView.RowFilter = "State=" + item [ "ID" ] ;
 
                return ;
            } ;
 
// Select the first State
            this.comboBox1.SelectedIndex = 0 ;


modified 14-Jan-13 9:49am.

GeneralRe: how i get data from datatable Pinmembera1_shay13-Jan-13 20:29 
GeneralRe: how i get data from datatable PinmemberMycroft Holmes13-Jan-13 21:06 
GeneralRe: how i get data from datatable Pinmembera1_shay13-Jan-13 21:08 
GeneralRe: how i get data from datatable PinmemberMycroft Holmes13-Jan-13 23:58 
GeneralRe: how i get data from datatable Pinmembera1_shay14-Jan-13 0:53 
GeneralRe: how i get data from datatable [modified] PinmemberPIEBALDconsult14-Jan-13 3:05 
GeneralRe: how i get data from datatable Pinmembera1_shay14-Jan-13 3:08 
GeneralRe: how i get data from datatable PinmemberPIEBALDconsult14-Jan-13 3:36 
GeneralRe: how i get data from datatable Pinmembera1_shay14-Jan-13 12:34 
Questionis it possible to work with Word files using Binary Reader and writer? Pinmemberasem052513-Jan-13 5:41 
AnswerRe: is it possible to work with Word files using Binary Reader and writer? PinmemberGarth J Lancaster13-Jan-13 10:19 
QuestionDeleting registry values PinmemberErol230913-Jan-13 4:51 
AnswerRe: Deleting registry values [modified] Pinmember ProgramFOX13-Jan-13 6:06 
GeneralRe: Deleting registry values PinmemberErol230913-Jan-13 8:44 
GeneralRe: Deleting registry values Pinmember ProgramFOX14-Jan-13 5:57 
AnswerRe: Deleting registry values PinprotectorPete O'Hanlon13-Jan-13 8:56 
GeneralRe: Deleting registry values PinmemberErol230913-Jan-13 22:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.140415.2 | Last Updated 18 Apr 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid