Ejemplo n.º 1
0
        private void btn_pesquisar_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrWhiteSpace(txt_pesquisar.Text))
            {
                MessageBox.Show("Preenha o Nome!", "Atenção!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return;
            }
            SqlConnection sqlcon = new SqlConnection("Data Source=LUIS-NOTE\\SQL2014;Initial Catalog=DB_ESCOLA;Integrated Security=true");
            //SqlConnection sqlcon = new SqlConnection("Data Source=PCARY4\\ARYGOMES;Initial Catalog=DB_ESCOLA;Integrated Security=true");
            {
                SqlCommand cmd = new SqlCommand("PR_SEL_AD", sqlcon);
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@NM_ALUNO", txt_pesquisar.Text);
                    txt_pesquisar.Clear();
                    SqlDataAdapter da = new SqlDataAdapter(cmd);
                    {
                        DataTable dt = new DataTable();
                        da.Fill(dt);
                        dtg_select.DataSource = dt;

                        if (dt.Rows.Count == 0)
                        {
                            MessageBox.Show("Nenhum Registro Encontrado", "Ops...", MessageBoxButtons.OK, MessageBoxIcon.Error);
                            this.Close();
                            SearchScreen form = new SearchScreen();
                            form.Show();
                            return;
                        }
                    }
                }
            }
        }
Ejemplo n.º 2
0
        private void menu_pesquisar_Click_1(object sender, EventArgs e)
        {
            SearchScreen form = new SearchScreen();

            form.Show();
        }