C#

public void filtrar_Click(object sender, EventArgs e)
        {
            DataView dv = new DataView(ds);
           
          
            //define a ordenação e o filtro
            dv.AllowNew = false;
            dv.AllowDelete = true;            
            dv.RowFilter = "NIF Like '" + textBoxNIF.Text + "*'";
            //exibe o resultado
            grid_lic.DataSource = dv;
        }

        public void Consulta()
        {
            //MessageBox.Show(grid_lic.CurrentRow.Cells[3].Value.ToString());
            con = new OdbcConnection("driver= {MySQL ODBC 5.1 Driver};server=192.168.19.78; database=licenciamento; uid=estagio; password=1234; option = 3 ");
            con.Open();

            OdbcCommand Command = con.CreateCommand();
            Command.CommandText = "select lojas.Id, lojas.NIF, lojas.Loja, lojas.Bloquear, lojas.DataFim, lojas.lastupdate, lojas.Nome, " +
            " licenciamentoloja.EArtigo, licenciamentoloja.EFamilia, licenciamentoloja.EClientes, licenciamentoloja.EFornecedores, licenciamentoloja.Evendas," +
            "licenciamentoloja.ECompras, licenciamentoloja.EStocks, licenciamentoloja.ELiquidacao, licenciamentoloja.ECaixas, licenciamentoloja.EInfoStock," +
            "licenciamentoloja.ZSArtigos, licenciamentoloja.ZSClientes, licenciamentoloja.ZSStocks, licenciamentoloja.id from lojas inner join licenciamentoloja on lojas.NIF = licenciamentoloja.NIF and lojas.Loja = licenciamentoloja.loja";

            Command.CommandType = CommandType.Text;
            Command.Connection = con;

            OdbcDataAdapter adapter = new OdbcDataAdapter();
            adapter.SelectCommand = Command;

            DataSet ds = new DataSet();
            adapter.Fill(ds);
            grid_lic.DataSource = ds;
            grid_lic.DataMember = ds.Tables[0].TableName;

public MainPage()
            {
                this.InitializeComponent();
                LoadData();
                //Setting the HTML content in the WebView control.
                MapWebView.NavigateToString(GeneratedHTML);
            }
private async void LoadData()
        {
            try
            {
                await loadJsonLocalnew("default.html", "");
            }
            catch (Exception ex)
            {

                throw;
            }
        }
public async static Task loadJsonLocalnew(string url, object ClassName)
        {
            try
            {
                //*******************************************************
                //To pick up file from local folder in window store app
                //*******************************************************
                var folder = await StorageFolder.GetFolderFromPathAsync(Windows.ApplicationModel.Package.Current.InstalledLocation.Path + @"\");
                StorageFile file = await folder.GetFileAsync(url);
                Stream stream = await file.OpenStreamForReadAsync();
                StreamReader reader = new StreamReader(stream);
                String html = reader.ReadToEnd();
                GeneratedHTML = html.ToString();//the vraible html has an error so it pass to the catch bloc

            }
            catch (Exception ex)
            {
            }}

<Grid Background="{ThemeResource ApplicationPageBackgroundThemeBrush}">
        <WebView x:Name="MapWebView" Width="Auto" Height="700"/>
    </Grid>

Some files or contents of this website require a program that is not installed on your computer.