Import excel data into oracle table using windows C# forms

Arif Mohammed

Hi Experts,

I need to read data from excel file and import into one table of oracle for updating purpose, can anyone help me as i new to C#.I have recently started learning about c#.

Thanks.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Uehara Ayaka8y ago
see this article

http://www.c-sharpcorner.com/blogs/import-and-export-data-from-excel-to-database
Gautam Parmar8y ago
1. private void btnChooseFile_Click(object sender, EventArgs e) {
2. string filePath = string.Empty;
3. string fileExt = string.Empty;
4. OpenFileDialog file = new OpenFileDialog(); //open dialog to choose file
5. if (file.ShowDialog() == System.Windows.Forms.DialogResult.OK) //if there is a file choosen by the user
6. {
7. filePath = file.FileName; //get the path of the file
8. fileExt = Path.GetExtension(filePath); //get the file extension
9. if (fileExt.CompareTo(".xls") == 0 || fileExt.CompareTo(".xlsx") == 0) {
10. try {
11. DataTable dtExcel = new DataTable();
12. dtExcel = ReadExcel(filePath, fileExt); //read excel file
13. dataGridView1.Visible = true;
14. dataGridView1.DataSource = dtExcel;
15. } catch (Exception ex) {
16. MessageBox.Show(ex.Message.ToString());
17. }
18. } else {
19. MessageBox.Show("Please choose .xls or .xlsx file only.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error); //custom messageBox to show error
20. }
21. }
22. }