Question

I need help with Binding my listbox to my entity in c#.

w/ code if possible

I have

using(var db = new database_name)

{

var r = sql statement;

I need help with whats next. My entity has diff rows and i need to display them in my listbox.Thank you

Answer 1

you will use Listbox.Items.Add property to display items in the list box.

Please see the example below. In case of any query, do comment.

Designer Code:

namespace ListBoxInCSharp

{

    partial class Form1

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

        protected override void Dispose(bool disposing)

        {

            if (disposing && (components != null))

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows Form Designer generated code

        /// <summary>

        /// Required method for Designer support - do not modify

        /// the contents of this method with the code editor.

        /// </summary>

        private void InitializeComponent()

        {

            this.lstBoxDisplay = new System.Windows.Forms.ListBox();

            this.btnFill = new System.Windows.Forms.Button();

            this.SuspendLayout();

            //

            // lstBoxDisplay

            //

            this.lstBoxDisplay.FormattingEnabled = true;

            this.lstBoxDisplay.ItemHeight = 20;

            this.lstBoxDisplay.Location = new System.Drawing.Point(172, 58);

            this.lstBoxDisplay.Name = "lstBoxDisplay";

            this.lstBoxDisplay.Size = new System.Drawing.Size(324, 164);

            this.lstBoxDisplay.TabIndex = 0;

            //

            // btnFill

            //

            this.btnFill.Location = new System.Drawing.Point(275, 299);

            this.btnFill.Name = "btnFill";

            this.btnFill.Size = new System.Drawing.Size(116, 42);

            this.btnFill.TabIndex = 1;

            this.btnFill.Text = "FillListBox";

            this.btnFill.UseVisualStyleBackColor = true;

            this.btnFill.Click += new System.EventHandler(this.btnFill_Click);

            //

            // Form1

            //

            this.AutoScaleDimensions = new System.Drawing.SizeF(9F, 20F);

            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

            this.ClientSize = new System.Drawing.Size(800, 450);

            this.Controls.Add(this.btnFill);

            this.Controls.Add(this.lstBoxDisplay);

            this.Name = "Form1";

            this.Text = "ListBox Example";

            this.ResumeLayout(false);

        }

       #endregion

        private System.Windows.Forms.ListBox lstBoxDisplay;

        private System.Windows.Forms.Button btnFill;

    }

}

Code behind:

using System;

using System.Collections.Generic;

using System.Windows.Forms;

namespace ListBoxInCSharp

{

    public partial class Form1 : Form

    {

        //below list is declared for example purpose

        List<string> rows ;

        public Form1()

        {

            InitializeComponent();

        }

        private void btnFill_Click(object sender, EventArgs e)

        {

            //first clear the list before filling it

            lstBoxDisplay.Items.Clear();

            //rows is a list of string, prepared as below to just show the usage of list box, you will use your list of rows returned from Database

            rows = new List<string>(){ "Test", "Chegg" ,"ListBox", "Example"};

            //now iterate through your rows received from Database

            foreach (var row in rows)

            {

                //add it to List box Items collection, which shows the details on UI

                lstBoxDisplay.Items.Add(row);

                //if you want any specific properties of your row, you use as below, and replace the column name of you need to display

                //lstBoxDisplay.Items.Add(row.<column>);

            }

        }

    }

}

==============================code screen shot======================

Output:

Please rate your answer. Thanks