{
GetDataSet(sqlstr);
}
else
{
Label1.Visible = true;
Label1.Text = "<script language=javascript>alert('数据库中没有数据信息，请先导入再查询！');location='Default.aspx';</script>";
}
dr.Close();
conn.Close();
}
public DataSet GetDataSet(string sqlstr)
{
OleDbConnection conn = CreateCon();
OleDbDataAdapter myda = new OleDbDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
myda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
return ds;
}
public DataTable getExcelDate()
{
string strExcelFileName = Server.MapPath("学生成绩.xls");
string strcon = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strExcelFileName + ";" + "Extended Properties='Excel 8.0;HDR=YES;IMEX=1';";
string sql = "select * from [Sheet1$]";
OleDbDataAdapter da = new OleDbDataAdapter(sql, strcon);
DataSet ds = new DataSet();
da.Fill(ds);
return ds.Tables[0];
}
public void LoadData(string StyleSheet)
{
//定义数据库连接字符串 m
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + Server.MapPath("学生成绩.xls") + ";Extended Properties=Excel 8.0";
//创建数据库连接
OleDbConnection myConn = new OleDbConnection(strCon);
//打开数据链接，得到一个数据集
myConn.Open();
//创建DataSet对象
DataSet myDataSet = new DataSet();
//定义查询的SQL语句
