How do I read thru a SQL database table using a loop and insert those records into a datagridview

// Define the Variables for Connection to the SQL Server

            String ConnectionString2 = @"Data Source = hemsql02;Initial Catalog=OTITest;User ID=wgtest;Password=Testit$1";
            SqlConnection conn = new SqlConnection(ConnectionString2);
            con.Open();   // Open up the path to the Database.....

            // Setup Sql Statement for Selection of Records......
            String SqlSelectRecords = ("select g.[Year] ,g.[EffectiveDate],g.[Volume] ,g.[Currency] ,g.[RateType] ,g.[MinimumRate] ,i.[State], i.[Location], i.[IndexEffective], i.[Page], i.[PageDescription] FROM[MultiYearWageGuide]as g join[MultiYearWageIndex] as i ON g.Volume= i.Volume AND g.Page = i.Page AND g.LocCode = i.Location WHERE store= " + int.Parse(textBox2.Text));
                        
            // Assign the variable cmd the value of the selection with the connection.......
            SqlCommand cmd = new SqlCommand(SqlSelectRecords, con);

            // Assign the DataReader to a variable......
            SqlDataReader sqldr = cmd.ExecuteReader();


            // Keep reading thru the file for values from the selection and move them to the appropriate area of the Form .....                          
              if (sqldr.Read())       
              {
                
                    // Load the DataGrid Table1 with Values from DataBase Table ......

                    dataGridView1.Rows.Add(YearVal, EffDateVal, VolumeVal, CurrVal, RateTypeVal, MinRateVal);

                    // Load the DataGrid Table2 with Values from Database Table.....

                    //dataGridView2.Rows.Add(YearVal, EffDateVal, VolumeVal, CurrVal, RateTypeVal, MinRateVal);