I want to use selectedvalue from listbox to filter datagridview

See more:

C#

.NET

Azure

ListBox

DataGrid

Hi,

I'm trying to pass the SelectedValue from my listBox to be used as a filter for my DataGridView. Both objects use my Azure SQL database to get their data.

namespace myNameSpace
{
    public partial class CompanyForm : Form
    {
        public CompanyForm()
        {
            InitializeComponent();
            Load += new EventHandler(dataEmployees_Load);
            Load += new EventHandler(companyList_Load);
        }
        //Connection String
        string cs = ConfigurationManager.ConnectionStrings["MyCS"].ConnectionString;
        
        // Load all companies
        private void companyList_Load(object sender, EventArgs e)
        {
            SqlConnection con;
            SqlCommand cmd;
            SqlDataAdapter adapter = new SqlDataAdapter();
            DataSet ds = new DataSet();
            string sql = "Select companyName from dbo.Company";
            con = new SqlConnection(cs);
            try
            {
                con.Open();
                cmd = new SqlCommand(sql, con);
                adapter.SelectCommand = cmd;
                adapter.Fill(ds);
                adapter.Dispose();
                cmd.Dispose();
                con.Close();
                companyList.DataSource = ds.Tables[0];
                companyList.ValueMember = "companyName";

            }
            catch (Exception ex)
            {
                MessageBox.Show("There are no companies to display");
            }
        }

The code above is the code to generate the listbox from my SQL Database

// Load all employees
private void dataEmployees_Load(object sender, EventArgs e)
{
    using (SqlConnection con = new SqlConnection(cs))
    {
        con.Open();
        SqlCommand cmd = new SqlCommand
        (
            "Select fname,ename
             FROM dbo.Users u
             inner join dbo.Company c on c.companyName = u.company", con
        ); //I would like to add to the select clause the variable "selectedValue" that can work in my conditional logic to filter the data in the datagrid
        SqlDataReader dr = cmd.ExecuteReader();
        DataTable dt = new DataTable();
        dt.Load(dr);
        dataEmployees.DataSource = dt;
    }
}

So a user creates a company with employees, then wants to select a company and only get the ones employed in that particular company in the DataGridView

What I have tried:

I have tried some different approaches, with trying to put it into a variable but then the data does not get loaded into the listbox or the DataGridView.