Upload an excel sheet data

Question

Guys i need a big quick help..

I am developing a windows application.

I want to upload a excel sheet and send them in to the database and show them in a data grid view.

i read some articles but unable to find a way.

Please help me ..

Thanks you..

This is the excel sheet format.

ID Name

1 Tharake

2 Nadun

3 Kamal

Satyapriya Nayak · Answer

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Retrieving_excel_data_to_combobox { public partial class Form1 : Form { public OleDbConnection con; public void pintu(string s) { con = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " + "data source='" + s + " '; " + "Extended Properties=Excel 8.0;"); } public OleDbCommand com; public DataSet ds; public OleDbDataAdapter oledbda; public DataTable dt; public string str; public Form1() { InitializeComponent(); } private void btnbrowse_Click(object sender, EventArgs e) { OpenFileDialog openfiledialog1 = new OpenFileDialog(); openfiledialog1.ShowDialog(); openfiledialog1.Filter = "allfiles|*.xls"; TextBox1.Text = openfiledialog1.FileName; } private void btndisplay_Click(object sender, EventArgs e) { pintu(TextBox1.Text); try { con.Open(); str = "select * from [sheet1$]"; com = new OleDbCommand(str, con); ds = new DataSet(); oledbda = new OleDbDataAdapter(com); oledbda.Fill(ds, "[sheet1$]"); con.Close(); DataGridView1.DataSource = ds; DataGridView1.DataMember = "[sheet1$]"; } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }

Tharake Gunatilake · Answer

I got the answer guys.. private void button1_Click(object sender, EventArgs e) { OpenFileDialog ofImport = new OpenFileDialog(); ofImport.Title = "Select file"; ofImport.InitialDirectory = @"c:\"; ofImport.FileName = openFileDialog1.FileName; ofImport.Filter = "Excel Sheet(*.xlsx)|*.xlsx|All Files(*.*)|*.*"; ofImport.FilterIndex = 1; ofImport.RestoreDirectory = true; if (ofImport.ShowDialog() == DialogResult.OK) { string path = System.IO.Path.GetFullPath(ofImport.FileName); string query = "SELECT * FROM [Sheet1$]"; OleDbConnection conn = new OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ofImport.FileName + ";Extended Properties=" + "\"Excel 12.0 Xml;HDR=YES;IMEX=1\""; OleDbDataAdapter adapter = new OleDbDataAdapter(query, conn); DataSet dataSet = new DataSet(); adapter.Fill(dataSet); dataGridView1.DataSource = dataSet.Tables[0]; } else { ofImport.Dispose(); } }

Upload an excel sheet data

rizwan hudda

Scott Lysle