Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to bind data table with listview?

Pravesh Singh 21347 17 Aug 2012

Hello Everyone,
I'm facing a problem since last night, actually I want to bind data table with asp listview control but I don't have an idea how to do it. Please resolve my problem as soon as possible. Please paste code if possible.
Thanks in advance!!

Ask by Pravesh Singh

Updated 18 Aug 2012

1 Answers

AVADHESH PATEL 18 Aug 2012

Hello Pravesh
like gridview binding we can't bind listview so for binding listview take help of below code.


private void btnDisplay_Click(object sender, EventArgs e)
        {
            // Create Data Table for MS-Office 2007 or 2003
            System.Data.DataTable dtExcel = new System.Data.DataTable();
            //DataTable Name
            dtExcel.TableName = "MyExcelData";
            //Path of excel file in local drive
            string SourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='F:\avi\information.xlsx';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'";
            //connectin
            OleDbConnection con = new OleDbConnection(SourceConstr);
            //Query string
            string query = "Select * from [Sheet1$]";
            //DataAdapter object
            OleDbDataAdapter data = new OleDbDataAdapter(query, con);
            //fill record into DataTable
            data.Fill(dtExcel);
            // Attach Subitems to the ListView
            listView1.Columns.Add("Name", 100, HorizontalAlignment.Left);
            listView1.Columns.Add("Address", 100, HorizontalAlignment.Left);
            listView1.Columns.Add("Contact", 100, HorizontalAlignment.Left);
            listView1.Columns.Add("Email Id", 100, HorizontalAlignment.Left);
            // Clear the ListView control
            listView1.Items.Clear();
            // Display items in the ListView control
            for (int i = 0; i < dtExcel.Rows.Count; i++)
            {
                DataRow drow = dtExcel.Rows[i];
                // Only row that have not been deleted
                if (drow.RowState != DataRowState.Deleted)
                {
                    // Define the list items
                    ListViewItem lvi = new ListViewItem(drow["Name"].ToString());
                    lvi.SubItems.Add(drow["Address"].ToString());
                    lvi.SubItems.Add(drow["Contact"].ToString());
                    lvi.SubItems.Add(drow["Email Id"].ToString());
                    // Add the list items to the ListView
                    listView1.Items.Add(lvi);
                }
            }   
        }

I hope it might be resolve your problem.

advertising

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.