private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
string _nombreCliente = listBox1.SelectedItem.ToString();
var _cliente = new Customers();
try
{
using (var ctx = new northwindEntities())
{
var _clientes = from c in ctx.Customers
where c.CompanyName == _nombreCliente
select c;
_cliente = _clientes.SingleOrDefault();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + "\n" + ex.InnerException);
}
textBox1.Text = _cliente.CompanyName;
textBox2.Text = _cliente.ContactName;
textBox3.Text = _cliente.Address;
textBox4.Text = _cliente.City;
textBox5.Text = _cliente.Region;
}
private void button1_Click(object sender, EventArgs e)
{
using (var ctx = new northwindEntities())
{
var clientes = from c in ctx.Customers
select c;
foreach (Customers c in clientes)
{
listBox1.Items.Add(c.CompanyName);
}
}
//try
//{
// using( var ctx = new northwindEntities())
// {
// var _repClientes = new Repositorio<Customers>(ctx);
// var clientes = _repClientes.GetTodos();
// foreach (Customers c in clientes)
// {
// listBox1.Items.Add(c.CompanyName);
// }
// }
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message + "\n" + ex.InnerException);
//}
}