private void button1_Click(object sender, EventArgs e) { ExcelHelper eh = new ExcelHelper(this.txtFilePath.Text); String name = eh.GetSheetNames().ElementAt(0); DataSet ds = eh.ExcelToDataSet(name); System.Data.DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { ShopModel shop = new ShopModel(); shop.bigRegion = dr[2].ToString(); shop.smallRegion = dr[2].ToString(); shop.province = dr[3].ToString(); shop.city = dr[4].ToString(); shop.name = dr[5].ToString(); shop.id = dr[6].ToString(); shop.address = dr[7].ToString(); shop.brand = dr[8].ToString(); JsResultObject re = Toyz4net.Core.Util.NHibernateHelper.SaveOrUpdate(shop, ""); String msg = re.msg; } }
private void button1_Click(object sender, EventArgs e) { ExcelHelper eh = new ExcelHelper(this.txtFilePath.Text); String name = eh.GetSheetNames().ElementAt(0); DataSet ds = eh.ExcelToDataSet(name); System.Data.DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { ShopModel shop = new ShopModel(); shop.bigRegion = dr[2].ToString(); shop.smallRegion = dr[2].ToString(); shop.province= dr[3].ToString(); shop.city = dr[4].ToString(); shop.name = dr[5].ToString(); shop.id = dr[6].ToString(); shop.address = dr[7].ToString(); shop.brand = dr[8].ToString(); JsResultObject re = Toyz4net.Core.Util.NHibernateHelper.SaveOrUpdate(shop, ""); String msg = re.msg; } }