asp.net 读取excel数据(方法一)

   string connstring = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '" + strPath + "';Extended Properties=Excel 8.0";
           
  
            OleDbConnection conn=new OleDbConnection(connstring);
   OleDbDataAdapter cmd=new OleDbDataAdapter("select * from [movie$]",conn);
   DataSet ds=new DataSet();
   cmd.Fill(ds);
   DataTable dt=ds.Tables[0];
   DataGrid1.DataSource=dt;
   DataGrid1.DataBind();
   string a="";
   for(int i=0;i<dt.Rows.Count;i++)
   {
    
   DataRow dr=dt.Rows[i];
    a=a+dr["name"].ToString();
    if(dr["name"].ToString()!="")
    {
     
     Response.Write("***"+dr["name"].ToString()+"***");
    }
   }
   Response.Write("<br>");
   a=a+"***";
   Response.Write(a);