asp.net中数据excel导入,并马上显示出来。另外还可以导出,求完整代码谢谢
asp.net中数据excel导入,并马上gridview显示出来。另外还可以导出为excel,本人刚刚才学习asp.net。求完整代码谢谢。--------------------编程问答-------------------- 我有,不过贴代码挺麻烦的,我可以通过邮件传给你 --------------------编程问答-------------------- http://www.yesky.com/49/1890549.shtml --------------------编程问答-------------------- 能给我也发一份吗?我也正在找这个。谢谢啊!
邮箱:766191920@qq.com --------------------编程问答-------------------- 谢谢了。我的邮箱634585@qq.com --------------------编程问答-------------------- yefeng85862375@126.com --------------------编程问答-------------------- 插入语句:
protected void Button1_Click(object sender, EventArgs e)
{
string path = FileUpload1.PostedFile.FileName;
SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=G:\WebSite1\App_Data\Database.mdf;Integrated Security=True;User Instance=True");
//连接Excel 数据源
string excelConnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'";//这里是2003的,如果是2007及以上要相应的改动一下
OleDbConnection excelConn = new OleDbConnection(excelConnString);
excelConn.Open();
string sql = "select * from [sheet1$]";//注意的你Excel项目的名字,一般在左下角
OleDbDataAdapter mycomm = new OleDbDataAdapter(sql, excelConn);
DataSet myds = new DataSet();
mycomm.Fill(myds);
SqlCommand cm = new SqlCommand();
cm.Connection = conn;
conn.Open();
for (int i = 0; i < myds.Tables[0].Rows.Count; i++)
{
string str = "select id from testIsOk where id='" + myds.Tables[0].Rows[i]["id"].ToString() + "'";
SqlCommand cmd = new SqlCommand(str, conn);
//根据ID判断数据库里是否已存在,不存在则插入
if (cmd.ExecuteScalar() == null)
{
string Sql = "insert into testIsOk values('" + myds.Tables[0].Rows[i]["id"].ToString() + "','" + myds.Tables[0].Rows[i]["sname"] + "')";
cm.CommandText = Sql;
cm.ExecuteNonQuery();
}
//存在则更新
else
{
string Sql = "update testIsOk set sname='" + myds.Tables[0].Rows[i]["sname"].ToString() + "' where id='" + myds.Tables[0].Rows[i]["id"].ToString() + "'";
cm.CommandText = Sql;
cm.ExecuteNonQuery();
}
}
Response.Write("<script>alert('导入成功!')</script>");
cm.Dispose();
conn.Close();
}
插入数据库后用GridView显示应该不是难事,导出到Excel的网上有很多,楼主可以百度“Gridview导出到Excel”
补充:.NET技术 , ASP.NET