drcsharp

  博客园 :: 首页 :: 新随笔 :: 联系 :: 订阅 :: 管理 ::
        private void Form1_Load(object sender, System.EventArgs e) {
            propertyGrid1.SelectedObject 
= lookUpEdit1.Properties;
            pnlHint.Caption 
=  "This demo demonstrates how to use a DataView as a data source for a Lookup editor.";
            DevExpress.Utils.LookAndFeelMenu menu 
= new DevExpress.Utils.LookAndFeelMenu(this, defaultLookAndFeel1, "XtraEditors: LookUp Edit (Data Binding) by Developer Express inc.");
            InitData();
            InitLookUp();
        }


        DataView dvMain, dvProducts;
        
private void InitData() {
            
string DBFileName = DevExpress.Utils.FilesHelper.FindingFileName(Application.StartupPath, "Data\\nwind.mdb");
            
if(DBFileName != ""{
                DataSet ds 
= new DataSet();
                
string con = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + DBFileName;
                    
                System.Data.OleDb.OleDbDataAdapter dbAdapter 
= new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [Order Details]", con);
                dbAdapter.Fill(ds, 
"Order Details");
                dbAdapter 
= new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM Products", con);
                dbAdapter.Fill(ds, 
"Products");
                DataViewManager dvm 
= new DataViewManager(ds);
            
                dvMain 
= dvm.CreateDataView(ds.Tables["Order Details"]);
                dvProducts 
= dvm.CreateDataView(ds.Tables["Products"]);
            }

        }


        
private void InitLookUp() {
            lookUpEdit1.DataBindings.Add(
"EditValue", dvMain, "ProductID");
            lookUpEdit1.Properties.DataSource 
= dvProducts;
            dataNavigator1.DataSource 
= dvMain;
        }

    }
posted on 2005-01-05 22:23  Drcsharp  阅读(1628)  评论(1)    收藏  举报