Listato 4. Esempio di implementazione del metodo insertAuthors()

public void insertAuthors(string au_id, string au_fname, string au_lname, string phone, string address, string city, string state, string zip, Boolean contract)
{
  string PubsConnStr = ConfigurationManager.ConnectionStrings["PUBSConnectionString"].ConnectionString;
  SqlConnection conn = new SqlConnection(PubsConnStr);
  string SelectSQL = "SELECT * FROM authors";
  SqlDataAdapter adapter = new SqlDataAdapter(SelectSQL, conn);
  DataSet ds = new DataSet();

  adapter.Fill(ds, "authors");
  DataRow nuovaRiga = ds.Tables["authors"].NewRow();

  nuovaRiga["au_id"] = au_id;
  nuovaRiga["au_fname"] = au_fname;
  nuovaRiga["au_lname"] = au_lname;
  nuovaRiga["phone"] = phone;
  nuovaRiga["address"] = address;
  nuovaRiga["city"] = city;
  nuovaRiga["state"] = state;
  nuovaRiga["zip"] = zip;
  nuovaRiga["contract"] = contract;
  ds.Tables["authors"].Rows.Add(nuovaRiga);

  SqlCommandBuilder cb = new SqlCommandBuilder(adapter);
  adapter.Update(ds, "authors");
}

Listato 5. Esempio di implementazione del metodo deleteAuthors()

public void deleteAuthors(string au_id)
{
  string PubsConnStr = ConfigurationManager.ConnectionStrings["PUBSConnectionString"].ConnectionString;
  SqlConnection conn = new SqlConnection(PubsConnStr);
  string SelectSQL = "SELECT * FROM authors WHERE au_id=@au_id";
  SqlDataAdapter adapter = new SqlDataAdapter(SelectSQL, conn);
  DataSet ds = new DataSet();
  
  adapter.SelectCommand.Parameters.Add("@au_id", SqlDbType.NVarChar, 11).Value = au_id;
  adapter.Fill(ds, "authors");
  
  ds.Tables[0].Rows[0].Delete();
  SqlCommandBuilder cb = new SqlCommandBuilder(adapter);
  adapter.Update(ds, "authors");
}