CODEWITHSUNDEEP
c#asp.net.netlistview
JJ.
JJ.

Reputation: 9950

How do I fill a list view using a data table?

I already have the datatable. I just need to fill it in the list view. The problem is that I'm running into this error:

'System.Web.UI.WebControls.ListView' does not contain a definition for 'DisplayMember' and no extension method 'DisplayMember' accepting a first argument of type 'System.Web.UI.WebControls.ListView' could be found (are you missing a using directive or an assembly reference?)

I thought the list view had a "DisplayMember" property? This is ASP .NET 4.0, by the way.

namespace Eagle_Replication_Manager
{
    public partial class wfrmMain : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            //on page load, I want to get a database table and populate this list view: 
            lvItems.DataSource = GetSourceDBs();

            //This does not work, error here:
            lvItems.DisplayMember = "Description";
        }

        private DataTable GetSourceDBs()
        {
            using (SqlConnection conn = new SqlConnection(AppVars.connectionString))
            {
                using (SqlCommand cmd = new SqlCommand("SELECT [Description] FROM [Warehouse].[dbo].[Items]", conn))
                {
                    conn.Open();

                    cmd.ExecuteNonQuery();

                    using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                    {
                        using (DataTable dt = new DataTable())
                        {
                            da.Fill(dt);
                            return dt;
                        }
                    }
                }
            }
        }
    }
}

Upvotes: 1

Views: 9153

Answers (2)

Chaitali
Chaitali

Reputation: 53

Public void getdataToList(object sender, System.EventArgs e) { SqlConnection conn = new SqlConnection(" << put your connection string >>");

 try {
   lvItems.Columns.Clear() ;
   lvItems.Items.Clear();

   conn.Open();
   txtSql.Text ="select * from Employee";

   SqlCommand cmd = conn.CreateCommand();
   cmd.CommandText = txtSql.Text;

   SqlDataReader dr = cmd.ExecuteReader();

   for (int i = 0; i< dr.FieldCount; i++) {
     ColumnHeader ch = new ColumnHeader();
     ch.Text=dr.GetName(i);
     lvItems.Columns.Add(ch);
   }

   ListViewItem itmX; 

   while (dr.Read()) {
     itmX=new ListViewItem(); 
     itmX.Text= dr.GetValue(0).ToString();

     for (int i=1 ; i< dr.FieldCount; i++) {
        itmX.SubItems.Add(dr.GetValue(i).ToString());
     }
     lvwResult.Items.Add(itmX);
   }
   dr.Close();
} catch ( System.Data.SqlClient.SqlException  ex) {
   Console.WriteLine("There was an error in executing the SQL." +
           "\nError Message:" + ex.Message, "SQL");
} finally {
   conn.Close();
}

Upvotes: 0

g45rg34d
g45rg34d

Reputation: 9660

This should work:

    protected void Page_Load(object sender, EventArgs e)
    {
        lvItems.DataSource = GetSourceDBs();
        lvItems.DataBind();
    }

Upvotes: 1

Related Questions