用asp.net将Excel导入到数据库并显示

string connStr="Provider=Microsoft.Jet.Oledb.4.0;Data Source=" +source + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";   

   string sqlStr="select * from [Sheet1$]";
   myConn=new OleDbConnection(connStr);
   myConn.Open();
   myCmd=new OleDbCommand(sqlStr,myConn);
   myda=new OleDbDataAdapter(myCmd);
   myDs=new DataSet();
   myda.Fill(myDs,"userinfo");

   DataGrid1.DataSource=myDs;
   //DataGrid1.DataMember="[Sheet1$]";
   DataGrid1.DataBind();

   
   //开始导入
/*   string strConn=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
   SqlConnection mySqlConn=new SqlConnection(strConn);
   mySqlConn.Open();
   
   string strCmd="";
   
   
   int rows=myDs.Tables[0].Rows.Count;
   int cols=myDs.Tables[0].Columns.Count;

   for(int i=0;i<rows;i++)
   {
    strCmd="insert into userinfo(userID,userName) values('";
    for(int j=0;j<cols;j++)
    {
     if(j==0)
     {
      strCmd=strCmd+myDs.Tables[0].Rows[i].ItemArray[j].ToString();
     }
     else
     {
      strCmd+= "','"+myDs.Tables[0].Rows[i].ItemArray[j].ToString();
     }
    }
    strCmd+="')";
    SqlCommand mySqlCmd=new SqlCommand(strCmd,mySqlConn);
    Label1.Text=strCmd;
    mySqlCmd.ExecuteNonQuery();
   }

   mySqlConn.Close();
*/   
   myConn.Close();