listbox data through excel sheet

String conStr1 = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath("/portal/files/allcity.xls") + ";" + "Extended Properties=Excel 8.0;";
                OleDbConnection con1 = new OleDbConnection(conStr1);
                con1.Open();
                string k1 = "select state from  [Sheet1$] group by state";
                cm = new OleDbCommand(k1, con1);
                dr = cm.ExecuteReader();
                ListBox3.DataSource = dr;
                ListBox3.DataTextField = "state";
                ListBox3.DataBind();
                ListBox3.Items.Insert(0, "Select");              
                dr.Close();

Popular Posts