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; } }