private void btnChooseFile_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.InitialDirectory = "c:\\"; openFileDialog1.Filter = "Excel Files|*.xls;*.xlsx"; openFileDialog1.FilterIndex = 2; openFileDialog1.RestoreDirectory = true; if (openFileDialog1.ShowDialog() == DialogResult.OK) { try { var dtProductFile = Common.GetDataTableFromExcelUsingOLEDB(openFileDialog1.FileName, "YES"); if (dtProductFile.Rows.Count == 0) { lbCount.Text = "Count: 0"; MessageBox.Show("File không có dữ liệu!"); } else { int checkedSql = 0; int uncheckedSql = 0; for (int i = 0; i < dtProductFile.Rows.Count; i++) { var drProduct = dBProduct.Product.NewRow(); drProduct["Name"] = dtProductFile.Rows[i][0]; drProduct["DetailUrl"] = dtProductFile.Rows[i][1]; var productId = Common.GetIDProduct(dtProductFile.Rows[i][1].ToString()); var productTemp = new DBProduct.ProductDataTable(); productTableAdapter.FillBy_Id(productTemp, productId); if (productTemp.Rows.Count == 0) { uncheckedSql++; continue; } else { drProduct["ID"] = productId; checkedSql++; } dBProduct.Product.Rows.Add(drProduct); } lbCheckedSql.Text = checkedSql.ToString(); lbUnCheckedSql.Text = uncheckedSql.ToString(); productGridControl.RefreshDataSource(); } } catch (Exception ex) { MessageBox.Show("Lỗi: " + ex.Message); } } }
private string GetImagePath(long id, ProductTableAdapter productAdapter) { var imagePath = ""; var productTable = new DBProduct.ProductDataTable(); try { productAdapter.FillById(productTable, id); if (productTable.Rows.Count > 0) { imagePath = productTable.Rows[0]["ImagePath"].ToString(); } } catch (Exception exception) { Log.Error(id + exception.ToString()); } return(imagePath); }