private void button1_Click(object sender, EventArgs e)
        {
            var tempCon = File.ReadAllText("DBConnection.json");
            var tempCon1 = Crypt.Decrypt(tempCon, "encryption");
            var sqlInfo = new JavaScriptSerializer().Deserialize<SQLInfo>(tempCon1);
            var password = Crypt.Decrypt(sqlInfo.Password, "encryption");
            var port = string.IsNullOrEmpty(sqlInfo.Port) ? "1433" : sqlInfo.Port;
            try
            {

                var con = new SqlConnection("Data Source='" + sqlInfo.Server + "'\'" + sqlInfo.Instance + "','" + port + "';Initial Catalog='" + sqlInfo.DB +
                                                                     "';User ID='" + sqlInfo.User + "';Password='" + password + "'");


                con.Open();
                var cmd = con.CreateCommand();
                int id = int.Parse(textBox1.Text);
                string sql = "SELECT * From Etiquetas Where referencia = @referencia";
                cmd.Parameters.AddWithValue("@referencia", SqlDbType.Text);
                DataSet ds = new DataSet();
                SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
                adapter.Fill(ds, "Etiquetas");
                CrystalReport1 cr = new CrystalReport1();
                cr.SetDataSource(ds.Tables["Etiquetas"]);
                crystalReportViewer1.ReportSource = cr;
                crystalReportViewer1.Refresh();
                //    using (var cmd = con.CreateCommand())
                //    {
                //        //int id = int.Parse(textBox1.Text);
                //        string sql = cmd.CommandText = "SELECT * From Artigos Where Cod_Grupo = 22  ";
                //        DataSet ds = new DataSet();
                //        SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
                //        adapter.Fill(ds, "Artigos");
                //        CrystalReport1 cr = new CrystalReport1();
                //        cr.SetDataSource(ds.Tables["Artigos"]);
                //        crystalReportViewer1.ReportSource = cr;
                //        crystalReportViewer1.Refresh();
                //        //cmd.Parameters.AddWithValue("@ID", id);
                //        //using (var dr = cmd.ExecuteReader())
                //        //{
                //        //    while (dr.Read())
                //        //    {
                //        //        DataSet ds = new DataSet();
                //        //        SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
                //        //        adapter.Fill(ds, "Artigos");
                //        //        CrystalReport1 cr = new CrystalReport1();
                //        //        cr.SetDataSource(ds.Tables["Artigos"]);
                //        //        crystalReportViewer1.ReportSource = cr;
                //        //        crystalReportViewer1.Refresh();

                //        //    }

                //        //}
                //    }

            }

            catch (Exception ex)
            {

            }
        }