Annonceindlæg fra Conscia
21. november 2006 - 23:08
#1
using System; using System.Data; using MySql.Data; using MySql.Data.MySqlClient; /// <summary> /// Summary description for PersonerDb /// </summary> /// namespace NihData.PersonerDb { public class PersonerDb { private const string PersTable = "Personer"; private const string usersInRolesTable = "UsersInRoles"; private string connectionString; private MySqlConnection conn; public PersonerDb() { connectionString = "Database=brydning;Data Source=localhost;User Id=root;Password=XXXX"; conn = new MySqlConnection(connectionString); } public void CreatePerson(string navn, string adresse, string postNr, string persBy, string oprettetAf, int erMand, string tlf, string tlf1, string email) { MySqlCommand cmd = new MySqlCommand("INSERT INTO `" + PersTable + "`" + " (PersNavn, PersAdresse, PersPostnr, PersBy, OprettetAF, ErMand, tlf, tlf1, Email) " + " Values(?PersNavn, ?PersAdresse, ?PersPostnr, ?PersBy, ?OprettetAF, ?ErMand, ?tlf, ?tlf1, ?Email)", conn); cmd.Parameters.Add("?PersNavn", MySqlDbType.VarChar, 50).Value = navn; cmd.Parameters.Add("?PersAdresse", MySqlDbType.VarChar, 50).Value = adresse; cmd.Parameters.Add("?PersPostnr", MySqlDbType.VarChar, 4).Value = postNr; cmd.Parameters.Add("?PersBy", MySqlDbType.VarChar, 50).Value = persBy; // / cmd.Parameters.Add("?PersFodseldag" , MySqlDbType.Datetime).Value = fodselsdag; cmd.Parameters.Add("?OprettetAF", MySqlDbType.VarChar, 50).Value = oprettetAf; cmd.Parameters.Add("?ErMand", MySqlDbType.Bit).Value = erMand; cmd.Parameters.Add("?tlf", MySqlDbType.VarChar, 8).Value = tlf; cmd.Parameters.Add("?tlf1", MySqlDbType.VarChar, 8).Value = tlf1; cmd.Parameters.Add("?Email", MySqlDbType.VarChar, 50).Value = email; conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } public DataSet allePersoner() { DataSet ds = new DataSet(); conn.Open(); MySqlDataAdapter MySqlDa = new MySqlDataAdapter(); MySqlCommand cmd = new MySqlCommand("select * from personer",conn); MySqlDa.SelectCommand = cmd; MySqlDa.Fill(ds); conn.Close(); return ds; } } }