/*Muestra los registros de la tabla en un gridview*/
public void DisplayUserList(DataGridView grid)
{
myDataTable = new DataTable();
myCommand = new SqlCommand("SP_ListUsers", MyConnection.GetConnection());
mySqlAdapter = new SqlDataAdapter(myCommand);
mySqlAdapter.Fill(myDataTable);
if (myCommand.Connection.State == ConnectionState.Open)
{
myCommand.Connection.Close();
}
for (int i = 0; i < myDataTable.Rows.Count; i++)
{
myDataTable.Rows[i]["Nombre"] = UpperFirstLetter(myDataTable.Rows[i]["Nombre"].ToString());
myDataTable.Rows[i]["Apellido"] = UpperFirstLetter(myDataTable.Rows[i]["Apellido"].ToString());
}
grid.DataSource = myDataTable;
}
/*Eliminar usuario*/
public void DeleteUser(int id)
{
try
{
myCommand = new SqlCommand("SP_DeleteUser", MyConnection.GetConnection());
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@id", SqlDbType.Int).Value = id;
myCommand.ExecuteNonQuery();
if (myCommand.Connection.State == ConnectionState.Open)
{
myCommand.Connection.Close();
}
MessageBox.Show("El usuario ha sido eliminado satisfactoriamente", "Eliminado", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
