+ -
当前位置:首页 → 问答吧 → “System.Web.UI.WebControls.DataGrid”并不包含对“SetDataBinding”的定义

“System.Web.UI.WebControls.DataGrid”并不包含对“SetDataBinding”的定义

时间:2007-08-02

来源:互联网

SqlConnection   con=DB.creatConnection();
      con.Open();

      System.Windows.Forms.OpenFileDialog   openFileDialog   =   new   System.Windows.Forms.OpenFileDialog();
      openFileDialog.Filter   =   "a(*.xls)|*.xls ";

      if(openFileDialog.ShowDialog()==DialogResult.OK)
      {
        FileInfo   fileInfo   =   new   FileInfo(openFileDialog.FileName);
        string   filePath   =   fileInfo.FullName;
        string   connExcel   =   "Provider=Microsoft.Jet.OLEDB.4.0;Data   Source= "   +   filePath   +   ";Extended   Properties=Excel   8.0 ";
       
        try
        {
          OleDbConnection   oleDbConnection   =   new   OleDbConnection(connExcel);
          oleDbConnection.Open();
               
          //获取excel表
          DataTable   dataTable   =   oleDbConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,   null);

          //获取sheet名,其中[0][1]...[N]:   按名称排列的表单元素
          string   tableName   =   dataTable.Rows[0][2].ToString().Trim();
          tableName   =   "[ "   +   tableName.Replace( " ' ", " ")   +   "] ";

          //利用SQL语句从Excel文件里获取数据
          //string   query   =   "SELECT   classDate,classPlace,classTeacher,classTitle,classID   FROM   "   +   tableName;
          string   query   =   "F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12   FROM   "   +   tableName;
          DataSet   dataSet   =   new   DataSet();

          //OleDbCommand   oleCommand   =   new   OleDbCommand(query,   oleDbConnection);
          //OleDbDataAdapter   oleAdapter   =   new   OleDbDataAdapter(oleCommand);
          OleDbDataAdapter   oleAdapter   =   new   OleDbDataAdapter(query,connExcel);
               
          oleAdapter.Fill(dataSet, "test ");

          //dataGrid1.DataSource   =   dataSet;
          //dataGrid1.DataMember   =   tableName;
          DataGrid2.SetDataBinding(dataSet, "test ");

          //从excel文件获得数据后,插入记录到SQL   Server的数据表
          DataTable   dataTable1   =   new   DataTable();
               
          SqlDataAdapter   sqlDA1   =   new   SqlDataAdapter(@ "A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12   FROM   test ",con);
               
          SqlCommandBuilder   sqlCB1   =   new   SqlCommandBuilder(sqlDA1);
               
          sqlDA1.Fill(dataTable1);

          foreach(DataRow   dataRow   in   dataSet.Tables[ "test "].Rows)
          {
            DataRow   dataRow1   =   dataTable1.NewRow();
                       
            dataRow1[ "A1 "]   =   dataRow[ "F1 "];
            /*dataRow1[ "classPlace "]   =   dataRow[ "开课城市 "];
            dataRow1[ "classTeacher "]   =   dataRow[ "讲师 "];
            dataRow1[ "classTitle "]   =   dataRow[ "课程名称 "];
            dataRow1[ "durativeDate "]   =   dataRow[ "持续时间 "];*/

            dataTable1.Rows.Add(dataRow1);
          }

          Console.WriteLine( "新插入   "   +   dataTable1.Rows.Count.ToString()   +   "   条记录 ");
          sqlDA1.Update(dataTable1);
               
          oleDbConnection.Close();
          con.Close();
        }
        catch(Exception   ex)
        {
          Console.WriteLine(ex.ToString());
        }
    执行错误,说是“System.Web.UI.WebControls.DataGrid”并不包含对“SetDataBinding”的定义,搞不懂是什么原因,请各位打虾帮帮忙。

作者: yjl163   发布时间: 2007-08-02

我也是这个问题啊

作者: zhangwuji156   发布时间: 2011-10-18