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


   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”的定义,搞不懂是什么原因,请各位打虾帮帮忙。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值