Question

dataset写入数据表

dataset从EXCEL中读取，要写入到数据库中，如果数据库中没有对应的行则写入，否则更新。本人菜鸟，望高手指点，越详细越好

Answer 1

lick(object sender, EventArgs e)
{
try
{
string fileName = DateTime.Now.ToString("yyyyMMddhhmmss") + "." + MsgBox.getFileLastName(File1.Value);
File1.PostedFile.SaveAs(System.Web.HttpContext.Current.Server.MapPath("~/Excel/" + fileName));

string conn = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =" + Server.MapPath("雹芹~/Excel/" + fileName) + ";Extended Properties=Excel 8.0";

OleDbConnection thisconnection = new OleDbConnection(conn);
thisconnection.Open();
string Sql = "select DISTINCT(厂牌) from [Sheet1$]";
OleDbDataAdapter mycommand = new OleDbDataAdapter(Sql, thisconnection);
DataSet ds = new DataSet();
mycommand.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataTable dt2 = ConString.QuerySql("select * from protype where name='" + ds.Tables[0].Rows[i]["厂牌"].ToString().Replace("'", "") + "' and languageid='" + Session["language"] + "'").Tables[0];
if (dt2.Rows.Count <袭隐 1)
{
ConString.ExecuteSql("insert protype (name,languageid)values('" + ds.Tables[0].Rows[i]["厂牌"].ToString().Replace("'", "") + "','" + Session["language"拍肆厅] + "')");
}
}
try
{
DataTable dt = ConString.QuerySql("select * from protype").Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
string name = dt.Rows[i]["name"].ToString();
string id = dt.Rows[i]["id"].ToString();

string Sql2 = "select * from [Sheet1$] where 厂牌='" + name + "'";
OleDbDataAdapter mycommand2 = new OleDbDataAdapter(Sql2, thisconnection);
DataSet ds2 = new DataSet();
mycommand2.Fill(ds2);
for (int ii = 0; ii < ds2.Tables[0].Rows.Count; ii++)
{
DataTable dt3 = ConString.QuerySql("select * from product where name='" + ds2.Tables[0].Rows[ii]["型号"].ToString() + "'and languageid='" + Session["language"] + "'").Tables[0];
if (dt3.Rows.Count < 1)
{
//ConString.ExecuteSql("insert product (type_id,name,num,pice,file1,languageid)values('" + id + "','" + ds2.Tables[0].Rows[ii]["型号"].ToString().Replace("'", "") + "','" + ds2.Tables[0].Rows[ii]["数量"].ToString().Replace("'", "") + "','" + ds2.Tables[0].Rows[ii]["价格"].ToString().Replace("'", "") + "','" + ds2.Tables[0].Rows[ii]["设备描述"].ToString().Replace("'", "") + "','" + Session["language"] + "')");
ConString.ExecuteSql("insert product (type_id,name,num,pice,file1,languageid,shows,top_num,fact,img)values('" + id + "','" + ds2.Tables[0].Rows[ii]["型号"].ToString().Replace("'", "") + "','" + ds2.Tables[0].Rows[ii]["数量"].ToString().Replace("'", "") + "','" + ds2.Tables[0].Rows[ii]["价格"].ToString().Replace("'", "") + "','" + ds2.Tables[0].Rows[ii]["设备描述"].ToString().Replace("'", "") + "','" + Session["language"] + "','" + ds2.Tables[0].Rows[ii]["热门"].ToString().Replace("'", "") + "','" + ds2.Tables[0].Rows[ii]["排序"].ToString().Replace("'", "") + "','" + ds2.Tables[0].Rows[ii]["其他厂牌"].ToString().Replace("'", "") + "','" + ds2.Tables[0].Rows[ii]["图片"].ToString().Replace("'", "") + "')");
}
}
}
}
catch(Exception ex)
{
Response.Write(ex.Message);
Response.End();
}
thisconnection.Close();
File.Delete(Server.MapPath("~/Excel/" + fileName));
MsgBox.alert("导入产品成功~！");
}
catch(Exception ex)
{
MsgBox.alert(ex.Message);
}

}

完全自己编写，如有问题可以HI留言。。。