如何将Excel作为UltraWebGrid 数据源绑定到UltraWebGrid中?

本文介绍了一种将Excel数据导入UltraWebGrid的方法。通过使用ASP.NET编程，借助OLEDB连接Excel文件，并读取Sheet1中的所有数据。然后，通过绑定数据集到UltraWebGrid进行展示。

解决办法如下：在页面中点击“浏览”选择要导入的Excel表后，点击“装载”按钮将Excel中的数据绑定到UltraWebGrid中显示。下面是“装载”按钮中click事件的代码。

protected void btn_zhuangzai_Click(object sender, EventArgs e) { try { String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source='" + File1.Value + "';" + "Extended Properties=Excel 5.0;"; OleDbConnection objConn = new OleDbConnection(sConnectionString); objConn.Open(); OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn); OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(); objAdapter1.SelectCommand = objCmdSelect; DataSet objDataset1 = new DataSet(); objAdapter1.Fill(objDataset1, "XLData"); string[] sql_column = ViewState["sql_column"].ToString().Split(",".ToCharArray()); for (int i = 0; i < sql_column.Length; i++) { objDataset1.Tables[0].Columns[i].ColumnName = sql_column[i].ToString(); } DataTable table = objDataset1.Tables[0]; this.Grid1.DataSource = table.DefaultView; this.Grid1.DataBind(); objConn.Close(); } catch (Exception) { } }