C#

void fill_listbox2()
           {
           SqlConnection connection = new SqlConnection(@"Data Source=****");

           try
           {
               connection.Open();
               string Query = "SELECT * FROM myTable"
               SqlCommand command = new SqlCommand(Query, connection);
               SqlDataReader dr = command.ExecuteReader();
               while (dr.Read())
               {
                   string name = dr.GetString(1);
                   listview2.Items.Add(name);

               }
               connection.Close();
           }
           catch (Exception ex)
           {
               System.Windows.MessageBox.Show(ex.Message);
           }

       }

Bankaida wrote:

have programmed two years in VB.Net and I'm thinking of moving on to C#.