|
<< Click to Display Table of Contents >> Generics |
  
|
|
<< Click to Display Table of Contents >> Generics |
|
Exemplo 1 - simples
// generics
List<string> lista = new List<string> { "Junior", "Maria", "Anotonio" };
lista.Add("Marta");
lista.InsertRange(0, new string[] {"Romer", "Bicha"});
foreach (string s in lista)
{
Console.WriteLine(s);
}
Console.WriteLine(lista[0]);
Exemplo completo usando banco de dados mySQL e ASP.NET
Crie novo projeto web, sem templades. crie Default.aspx vazio e uma classe Usuario:
Default.aspx
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="grvUsuarios" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>
Default.aspx.cs
using System;
using System.Collections.Generic;
using System.Configuration;
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
grvUsuarios.DataSource = getUsuarios();
grvUsuarios.DataBind();
}
private List<Usuario> getUsuarios()
{
using (MySqlConnection conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString))
{
using (MySqlCommand comand = new MySqlCommand("select chave, nome, email from usuario", conn))
{
conn.Open();
List<Usuario> listUsuario = new List<Usuario>();
using (MySqlDataReader dr = comand.ExecuteReader())
{
while (dr.Read())
{
Usuario usuario = new Usuario();
usuario.Chave = (int)dr["chave"];
usuario.Nome = dr["nome"].ToString();
usuario.Email = dr["email"].ToString();
listUsuario.Add(usuario);
}
}
return listUsuario;
}
}
}
}
Usuario.cs
public class Usuario
{
public int Chave { get; set; }
public string Nome { get; set; }
public string Email { get; set; }
public Usuario()
{
}
}
Web.config
<configuration>
<connectionStrings>
<add name="conn" connectionString="server=localhost;Uid=root;Pwd=123456;Database=teste"/>
</connectionStrings>
</configuration>
Banco de dados
mySql
tabela: Usuario
chave int
nome varchar(20)
email varchar(20)
Resultado
