protected void uiLinkButtonAdd_Click(object sender, EventArgs e) { Mineral objData = new Mineral(); objData.AddNew(); objData.MinID = Convert.ToInt32(uiDropDownListMins.SelectedValue); objData.CellPrice = uiTextBoxCellPrice.Text; objData.BuyPrice = uiTextBoxBuyPrice.Text; objData.CreatedDate = DateTime.Now.AddHours(7); objData.Save(); BindData(); }
protected void uiLinkButtonUpload_Click(object sender, EventArgs e) { if (uiFileUploadMines.HasFile) { uiFileUploadMines.SaveAs(Server.MapPath("~/FileUploads/" + uiFileUploadMines.FileName)); string connectionString = string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=NO;""", Server.MapPath("~/FileUploads/" + uiFileUploadMines.FileName)); string strSQL = "SELECT * FROM [sheet1$]"; OleDbConnection excelConnection = new OleDbConnection(connectionString); excelConnection.Open(); OleDbCommand dbCommand = new OleDbCommand(strSQL, excelConnection); OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand); DataTable dTable = new DataTable(); dataAdapter.Fill(dTable); Mineral objData = new Mineral(); foreach (DataRow item in dTable.Rows) { objData.AddNew(); objData.MinID = Convert.ToInt32(item[0].ToString()); objData.CellPrice = item[1].ToString(); objData.BuyPrice = item[2].ToString(); objData.CreatedDate = DateTime.Now.AddHours(7); } objData.Save(); BindData(); } }