已经读到dataset中的代码是这样的:
protected DataSet DSBind(string filePath)
{
String ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + "Extended Properties=Excel 8.0;";
//Create connection object by using the preceding connection string.
OleDbConnection objConn = new OleDbConnection(ConnectionString);
objConn.Open();
OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
DataSet objds = new DataSet();
objAdapter1.Fill(objds, "ExcelDataSet");
return objds;
objConn.Close();
}
protected void btnInputData_Click(object sender, EventArgs e)
{
gvData.DataSource = DSBind(fuFile.PostedFile.FileName);
gvData.DataBind();
请问怎么导入到数据库?(还有如果excel有几个sheet,请问怎么解决)