“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”的定义,搞不懂是什么原因,请各位打虾帮帮忙。
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
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28