public static void insertAccounts(Account account)
{
List<Account> accts = new List<Account>();
///set the connectionstring for the db
string dsn = ConfigurationManager.ConnectionStrings[connectionstring].ConnectionString;
///Layout the sql command you wish to execute
///
string sqlcommand = "insert into accounts (name,date) values(@name,@date)";
//setup the sql connecetion
using (SqlConnection conn = new SqlConnection(dsn))
using (SqlCommand command = new SqlCommand(sqlcommand, conn))
{
command.Parameters.AddWithValue("@name", account.name);
command.Parameters.AddWithValue("@date", account.date);
//open connection
conn.Open();
command.ExecuteNonQuery();
}
}
public static void updateAccounts(Account account)
{
///set the connectionstring for the db
string dsn = ConfigurationManager.ConnectionStrings[connectionstring].ConnectionString;
///Layout the sql command you wish to execute
///
string sqlcommand = "update accounts set name = @name , date = @date where id = @id";
//setup the sql connecetion
using(SqlConnection conn = new SqlConnection(dsn))
using (SqlCommand command = new SqlCommand(sqlcommand, conn))
{
command.Parameters.AddWithValue("@id",account.id);
command.Parameters.AddWithValue("@name", account.name);
command.Parameters.AddWithValue("@date", account.date);
//open connection
conn.Open();
command.ExecuteNonQuery();
}
}