ASP.NET通过UDL访问数据库
在盘下建立一个UDL连接文件test.udl
访问代码
string strDBPath = @"C:\test.udl";
string strSQL = "select * from Employees";
string strConnection = "File Name = " + strDBPath;
![](/Images/OutliningIndicators/None.gif)
OleDbConnection conn = new OleDbConnection( strConnection );
OleDbDataAdapter da = new OleDbDataAdapter( strSQL, conn );
![](/Images/OutliningIndicators/None.gif)
DataTable dtEmployees = new DataTable();
da.Fill( dtEmployees );
![](/Images/OutliningIndicators/None.gif)
DataGrid1.DataSource = dtEmployees;
DataGrid1.DataBind();
访问代码
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)