static void Main(string[] args) { InsertUsuario(); var dt = new DataTable(); var cmd = "sp_ListaUsuario"; dt = (DataTable)GenericDatabase.ExecuteCommand(cmd, CommandType.StoredProcedure, null, GenericDatabase.TypeCommand.ExecuteDataTable); foreach (DataRow item in dt.Rows) { System.Console.WriteLine("O usuaário é o {0} que mora na rua {1}", item["Nome"], item["Endereco"]); } System.Console.ReadKey(); }
static void InsertUsuario() { var query = String.Format("insert into Usuario values ('{0}','{1}')", "Caio", "Rua Catandoca"); GenericDatabase.ExecuteCommand(query, CommandType.Text, null, GenericDatabase.TypeCommand.ExecuteNonQuery); }