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