Help to populate combobox from excel

Hi Venu,

This is a another question.This thread is solved.Can you please post it as a new thread.



Thanks

This worked .. Thank you very much !!

can u help me on how to insert values from a combobox to another excel sheet in C # ??

Thanks in advance
Venu

Hi Venu,

Here is your solution.Run the attachments.


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 Form1_Load(object sender, EventArgs e)
        {
            comboBox1.Text = "Please select";
        }

        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);
            }


            try
            {
                con.Open();
                str = "select * from [sheet1$]";
                com = new OleDbCommand(str, con);
                oledbda = new OleDbDataAdapter(com);
                ds = new DataSet();
                oledbda.Fill(ds, "[sheet1$]");
                con.Close();
          
                dt = ds.Tables["[sheet1$]"];
                int i = 0;
                for (i = 0; i <= dt.Rows.Count -1; i++)
                {
                    comboBox1.Items.Add(dt.Rows[i].ItemArray[0]);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }
    }
}






Thanks
If this post helps you mark it as answer

Hi,
can you please help me to get the code in c# as my requirement is with C# .

Thanks
Venu

Oh, Satyapriya! Where were you last night (night in India, morning in America)?

Well, at least Venu has two suggestions to look at. I hope that Venu also uses many of the articles that are available in this web site.

The following piece of code works for me; it uses ADO, not ODBC. Note that there is at least one article in this web site that can help you with this; please read it.