使用Using System.Data.OleDb; 连接数据库，又一种动态绑定GridView显示数据。

1.在Web.Config内有

<appSettings >

    <add key="SQLConnectionString" value="Provider=sqloledb;data source=~/SQLEXPRESS;initial catalog=WebSiteTest;User ID=sa;Password= ***;persist security info=False;" />
  
 </appSettings> 

2.在.cs文件中

using System.Data;
using System.Data.OleDb;

.........

 string strSql = "select b.jdcode ,a.序号,a.flag, a.教材名称,b.bookname,a.作者,b.author,a.出版社,b.publish,a.版本,b.edition,a.ISBN ,b.ISBN as jdISBN,a.价格,b.price from  TempImportData1 as a left join JdData as b on 1=1 " + strSqlCheck + " where a.flag ='0' order by b.jdcode desc";
  
            string strconn2= System.Configuration.ConfigurationManager.AppSettings["SQLConnectionString"].ToString();
           
       

            OleDbConnection myConnection3 = new OleDbConnection(strconn2);

      
            //这段程序可以成功连接，不同于用微软的类库 Database db = DatabaseFactory.CreateDatabase();
            OleDbCommand commselect1 = new OleDbCommand(strSql, myConnection3);
            myConnection3.Open();
            OleDbDataReader dr1 = commselect1.ExecuteReader();
            GridView1.DataSource = dr1;
            GridView1.DataBind();
            dr1.Close();
            commselect1.Dispose();

.........