babujibabuji

1) Check your Excel dll references. 2) when you deal with excel object , your machine should have Ms office pakage and have permission to access that.

try some thing like this. 1) collect all company names from xmlfile and load in to combobox or some control 2) load company details in listview based on seletion. <?xml version="1.0" encoding="utf-8" ?> <companies> <company> <name>ABC</name> <Address>india road</Address> <point></point> </company> </companies> Private Sub Form2_Load(sender As System.Object, e As System.EventArgs) Handles …

Public Class Form2 Dim frm As New Form1 Dim myScore As Integer = 0 Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click Dim lbllist = (From lbl In frm.Controls Where TypeOf (lbl) Is Label Select DirectCast(lbl, Label).Text).ToList() For Each lbltext As String In lbllist If Not String.IsNullOrEmpty(TextBox1.Text) Then …

if you are trying to pull the data from excel sheet in to database. Try DTS pakages.uploading speed will be better than this method. your application will hang when you upload huge data.