how to select list box value using stored procedure in win form

See more:

WinForms

C#3.5

hi

I am trying to retrieve value in listbox using stored procedure. i m wform's listbox but it is not working. what i am doing wrong. can u please give the solution

private void listWBox_SelectedIndexChanged(object sender, EventArgs e)
        {
             string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
             using (SqlConnection con = new SqlConnection(CS))
           

                try
                {
                    SqlDataAdapter da = new SqlDataAdapter();
                     DataTable dt = new DataTable();

                    con.Open();
                    SqlCommand sqlcmd = new SqlCommand("readListWBox", con);
                    sqlcmd.CommandType = CommandType.StoredProcedure;
                    da.SelectCommand = sqlcmd;
                    da.Fill(dt);
                    listJobBox.DataSource = dt;              
                    
                    
                }
                catch (Exception ex)                
                {

                    MessageBox.Show("exception raised");
                
                }

                finally
                {

                    con.Dispose();
                    con.Close();
                
                }

        }