C#

        //path of data base
        string conString = @"URI=file:" + Application.StartupPath + "\\DataBase.db"; //database created in debug folder
SQLiteConnection con = new SQLiteConnection(conString);
            SQLiteCommand cmd = new SQLiteCommand(con);

            con.Open();
            try
            {
                cmd.CommandText = "INSERT INTO FileInfo(EqpCode, EqpName, FileName) VALUES(@EqpCode, @EqpName, @FileName)";

                for (int i = 0; i < myTable02.Rows.Count; i++)
                {
                    string EqpCode = myTable02.Rows[i][0].ToString();
                    string EqpName = myTable02.Rows[i][1].ToString();
                    string FileName = myTable02.Rows[i][2].ToString();

                    cmd.Parameters.AddWithValue(@EqpCode, EqpCode);
                    cmd.Parameters.AddWithValue(@EqpName, EqpName);
                    cmd.Parameters.AddWithValue(@FileName, FileName);

                    cmd.ExecuteNonQuery();
                }
                con.Close();
            }
            catch (Exception)
            {

                throw;
            }

string[]my_array = Directory.GetFiles(@"Resources\PDFs", "*.pdf");

<StackLayout x:Name="MyStack">
                        <Frame BackgroundColor="GreenYellow" CornerRadius="5" Padding="5">
                            <Label Text="Just For Test" FontAttributes="Bold" FontSize="Medium" />
                        </Frame>
                    </StackLayout>

<TabbedPage xmlns="http://xamarin.com/schemas/2014/forms"
             xmlns:x="http://schemas.microsoft.com/winfx/2009/xaml"
             x:Class="MReport.TabbedMainPage">
    
    <!--Pages can be added as references or inline-->
    <ContentPage Title="New Report" IconImageSource="NewReport.png" BackgroundImageSource="blue_windows.jpg">
        <StackLayout Margin="5">
            <Grid>
                <Grid.RowDefinitions>
                    <RowDefinition Height="10*"/>
                    <RowDefinition Height="*"/>
                </Grid.RowDefinitions>
                <ScrollView>
                    <StackLayout x:Name="MyStack">


                        <!--Labels and Frames should be added here programmatically every time the button clicked-->
                    </StackLayout>
                </ScrollView>
                <Button Grid.Row="1" Text="Add New Item" Clicked="Button_Clicked" />
            </Grid>
            <Button Grid.Row="1" Text="Send" />
        </StackLayout>
    </ContentPage>
    <ContentPage Title="Report History" IconImageSource="History.png" BackgroundImageSource="blue_windows.jpg" />
    <ContentPage Title="Messages" IconImageSource="Message.png" BackgroundImageSource="blue_windows.jpg"/>

</TabbedPage>

private async void Button_Clicked(object sender, EventArgs e)
       {
           MyStack.Children.Add(new Frame { CornerRadius = 5, BackgroundColor = Color.Azure});
           MyStack.Children.Add(new Label { Text = time_text[0].ToString() });
           MyStack.Children.Add(new Label { Text = time_text[1].ToString(), FontAttributes = FontAttributes.Bold, FontSize = Device.GetNamedSize(NamedSize.Medium, typeof(Label)) });
       }

dataGridView2.Rows [dvd] .Cells [0] .Value //of the first collone

void gab2relik()
        {
            cnx = new SqlConnection(db.RXcon);
            try
            {
                cnx.Open();
            }
            catch
            {
                MessageBox.Show("Erreure lors de la Connexion");
            }
            if (dataGridView2.Rows.Count>0)
            {
                for (int dvd = 0; dvd < dataGridView2.Rows.Count; dvd++)
                {
                    
                    string ct = "select grade from fction inner join person on person.id= fction.id where  id ='" + dataGridView2.Rows[dvd].Cells[0].Value + "'";
                    commd222 = new SqlCommand(ct);
                    commd222.Connection = cnx;
                    try
                    {
                        SqlDataReader d = commd222.ExecuteReader();
                        d.Read();
                        DataGridViewRow Row = (DataGridViewRow)dataGridView2.Rows[0].Clone();
                        Row.Cells[2].Value = d["grade"].ToString();
                        d.Close();
                        dataGridView2.Rows.Add(Row);
                    }
                    catch (Exception tt)
                    {
                        MessageBox.Show(tt.Message.ToString());
                    }
                    finally
                    {

                    }
                }
            
           
            }

int count = 0;
            foreach (Control c in this.Controls)
            {
                if (c.GetType() == typeof(Label))
                    if (((Label)c).BackColor == Color.Red)
                        count++;
            }

public TabbedMainPage(string parameter)
{
    InitializeComponent();
    On<Android>().SetToolbarPlacement(ToolbarPlacement.Bottom);
    On<Android>().SetIsSmoothScrollEnabled(false);
    lbl01.Text = parameter;
}

public App()
{
    InitializeComponent();

    MainPage = new TabbedMainPage();
}

TabbedMainPage