private void GetData()
{
dsLasAmericasTableAdapters.ClienteTableAdapter tableAdapter =
new dsLasAmericasTableAdapters.ClienteTableAdapter();
dsLasAmericas.ClienteDataTable dataTable = tableAdapter.GetData();
dgvClientes.DataSource = dataTable;
}
private void btnAgregar_Click(object sender, EventArgs e)
{
dsLasAmericasTableAdapters.ClienteTableAdapter tableAdapter =
new dsLasAmericasTableAdapters.ClienteTableAdapter();
tableAdapter.Add(txtNombre.Text.Trim(), txtDireccion.Text.Trim());
GetData();
ClearText();
}
private void btnModificar_Click(object sender, EventArgs e)
{
int?Id = GetId();
if (Id != null)
{
dsLasAmericasTableAdapters.ClienteTableAdapter tableAdapter =
new dsLasAmericasTableAdapters.ClienteTableAdapter();
tableAdapter.Edit(txtNombre.Text.Trim(), txtDireccion.Text.Trim(), (int)Id);
ClearText();
GetData();
}
}
private void btnEliminar_Click(object sender, EventArgs e)
{
int?Id = GetId();
if (Id != null)
{
dsLasAmericasTableAdapters.ClienteTableAdapter tableAdapter =
new dsLasAmericasTableAdapters.ClienteTableAdapter();
tableAdapter.Remove((int)Id);
ClearText();
GetData();
}
}
private void dgvClientes_CellClick(object sender, DataGridViewCellEventArgs e)
{
int?Id = GetId();
if (Id != null)
{
dsLasAmericasTableAdapters.ClienteTableAdapter tableAdapter =
new dsLasAmericasTableAdapters.ClienteTableAdapter();
dsLasAmericas.ClienteDataTable dt = tableAdapter.GetDataById((int)Id);
dsLasAmericas.ClienteRow row = (dsLasAmericas.ClienteRow)dt.Rows[0];
txtNombre.Text = row.nombre;
txtDireccion.Text = row.direccion;
}
}
