Click here to Skip to main content
12,751,832 members (30,640 online)
   

C#

 
AnswerRe: SqlConnection vs IDbConnection Pin
Simon_Whale14-Jan-13 1:01
memberSimon_Whale14-Jan-13 1:01 
QuestionLINQ with List Pin
Member 873185913-Jan-13 10:48
memberMember 873185913-Jan-13 10:48 
AnswerRe: LINQ with List Pin
J4amieC13-Jan-13 22:47
memberJ4amieC13-Jan-13 22:47 
AnswerRe: LINQ with List Pin
Simon_Whale14-Jan-13 2:17
memberSimon_Whale14-Jan-13 2:17 
GeneralRe: LINQ with List Pin
Member 875312115-Jan-13 7:35
memberMember 875312115-Jan-13 7:35 
AnswerRe: LINQ with List Pin
Member 873185921-Jan-13 7:36
memberMember 873185921-Jan-13 7:36 
Questionhow i get data from datatable Pin
a1_shay13-Jan-13 7:58
membera1_shay13-Jan-13 7:58 
AnswerRe: how i get data from datatable Pin
PIEBALDconsult13-Jan-13 14:38
memberPIEBALDconsult13-Jan-13 14: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 Pin
a1_shay13-Jan-13 21:29
membera1_shay13-Jan-13 21:29 
GeneralRe: how i get data from datatable Pin
Mycroft Holmes13-Jan-13 22:06
memberMycroft Holmes13-Jan-13 22:06 
GeneralRe: how i get data from datatable Pin
a1_shay13-Jan-13 22:08
membera1_shay13-Jan-13 22:08 
GeneralRe: how i get data from datatable Pin
Mycroft Holmes14-Jan-13 0:58
memberMycroft Holmes14-Jan-13 0:58 
GeneralRe: how i get data from datatable Pin
a1_shay14-Jan-13 1:53
membera1_shay14-Jan-13 1:53 
GeneralRe: how i get data from datatable Pin
PIEBALDconsult14-Jan-13 4:05
memberPIEBALDconsult14-Jan-13 4:05 
GeneralRe: how i get data from datatable Pin
a1_shay14-Jan-13 4:08
membera1_shay14-Jan-13 4:08 
GeneralRe: how i get data from datatable Pin
PIEBALDconsult14-Jan-13 4:36
memberPIEBALDconsult14-Jan-13 4:36 
GeneralRe: how i get data from datatable Pin
a1_shay14-Jan-13 13:34
membera1_shay14-Jan-13 13:34 
Questionis it possible to work with Word files using Binary Reader and writer? Pin
asem052513-Jan-13 6:41
memberasem052513-Jan-13 6:41 
AnswerRe: is it possible to work with Word files using Binary Reader and writer? Pin
Garth J Lancaster13-Jan-13 11:19
memberGarth J Lancaster13-Jan-13 11:19 
QuestionDeleting registry values Pin
Erol230913-Jan-13 5:51
memberErol230913-Jan-13 5:51 
AnswerRe: Deleting registry values Pin
ProgramFOX13-Jan-13 7:06
member ProgramFOX13-Jan-13 7:06 
GeneralRe: Deleting registry values Pin
Erol230913-Jan-13 9:44
memberErol230913-Jan-13 9:44 
GeneralRe: Deleting registry values Pin
ProgramFOX14-Jan-13 6:57
member ProgramFOX14-Jan-13 6:57 
AnswerRe: Deleting registry values Pin
Pete O'Hanlon13-Jan-13 9:56
protectorPete O'Hanlon13-Jan-13 9:56 
GeneralRe: Deleting registry values Pin
Erol230913-Jan-13 23:17
memberErol230913-Jan-13 23:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web02 | 2.8.170217.1 | Last Updated 21 Feb 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid