public DataTable CEP_RetornaDataTablePorPartedoNome(string logradouro)
{
viewBuscaCEPTableAdapter viewcep = new viewBuscaCEPTableAdapter();
DataTable tabela = new DataTable();
tabela = viewcep.RetornaDataTablePorPartedoNome("%" + logradouro + "%");
return tabela;
}
public DataTable CEP_RetornaLogradouroBairroPorCEP(int cep)
{
viewBuscaCEPTableAdapter viewcep = new viewBuscaCEPTableAdapter();
DataTable tabela = new DataTable();
tabela = viewcep.RetornaDataTablePorCEP(cep);
return tabela;
}
private void txLogradouro_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode == Keys.Enter)
{
viewBuscaCEPTableAdapter busca = new viewBuscaCEPTableAdapter();
dtgDados.DataSource = busca.RetornaDataTablePorPartedoNome("%" + txLogradouro.Text + "%");
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
public CEP()
{
ListaCEPCadastrados = new List<CEP>();
BDCep = new viewBuscaCEPTableAdapter();
}
private void frmMicroareas_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'dataSetACS.ViewAcs' table. You can move, or remove it, as needed.
this.viewAcsTableAdapter.Fill(this.dataSetACS.ViewAcs);
// TODO: This line of code loads data into the 'dataSetACS.ViewEnfermeiros' table. You can move, or remove it, as needed.
this.viewEnfermeirosTableAdapter.Fill(this.dataSetACS.ViewEnfermeiros);
// TODO: This line of code loads data into the 'dataSetACS.TB_AREA' table. You can move, or remove it, as needed.
this.tB_AREATableAdapter.Fill(this.dataSetACS.TB_AREA);
viewBuscaCEPTableAdapter cep = new viewBuscaCEPTableAdapter();
TabelaCEP = cep.GetData();
txLogradouro.AutoCompleteCustomSource.Clear();
foreach (DataRow linha in TabelaCEP.Rows)
{
txLogradouro.AutoCompleteCustomSource.Add(linha["ENDERECO"].ToString());
}
//this.viewAcsTableAdapter.Fill(this.dataSetACS.ViewAcs);
//this.viewEnfermeirosTableAdapter.Fill(this.dataSetACS.ViewEnfermeiros);
//this.tB_AREATableAdapter.Fill(this.dataSetACS.TB_AREA);
tbArea.SelectedIndex = 0;
tbEnfemreiro.SelectedValue = tbArea.SelectedValue;
cbAcs.SelectedIndex = 0;
cbAcs.SelectedText = null;
this.WindowState = FormWindowState.Maximized;
}
