public EmployeeManage(){InitializeComponent(); this.connectionStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +Application.StartupPath + "\\ManPowerManage.mdb"; this.selectStr="select * from Employee";this.Connection1=new OleDbConnection(this.connectionStr);this.Command1=new OleDbCommand();this.dataAdapter1=new OleDbDataAdapter(this.selectStr,this.Connection1);this.selectStr="select * from Dimmision";this.dataAdapter2=new OleDbDataAdapter(this.selectStr,this.Connection1);this.Command1.Connection=this.Connection1;this.Command1.CommandText=this.commandStr;}
1 回答
莫回?zé)o
TA貢獻(xiàn)1865條經(jīng)驗(yàn) 獲得超7個(gè)贊
一段用ole方式連接excel數(shù)據(jù)庫文件的代碼,數(shù)據(jù)庫在應(yīng)用程序的當(dāng)前目錄下。
從數(shù)據(jù)庫的表Employee讀出員工信息，并且能用“Command1”操作數(shù)據(jù)庫
添加回答
舉報(bào)
0/150
提交
取消