C#

using (SqlCommand cmd = myConnection.CreateCommand())
{
  cmd.CommandText = @"insert into katalog
([Program Name], Publisher, Category, [Disk Number], [Date Added])
values (@name, @pub, @cat, @num, @date)";
 
  cmd.Parameters.Add("@name", SqlDbType.NVarChar, 40).Value = txtName.Text;
  cmd.Parameters.Add("@pub", SqlDbType.NVarChar, 40).Value = txtPub.Text;
  cmd.Parameters.Add("@cat", SqlDbType.NVarChar, 40).Value = txtCat.Text;
 
  try
  {
    cmd.Parameters.Add("@num", SqlDbType.Int).Value = int.Parse(txtNum.Text);
  }
  catch (FormatException)
  {
    MessageBox.Show("Please enter a valid serial number.");
  }
 
  try
  {
    cmd.Parameters.Add("@date", SqlDbType.DateTime).Value = DateTime.Parse(txtDate.Text);
  }
  catch (FormatException)
  {
    MessageBox.Show("Please enter a valid date.");
  }
 
  try
  {
    myConnection.Open();
    cmd.ExecuteNonQuery();
  }
  catch (Exception ex)
  {
    MessageBox.Show("Error: could not update the database.\n" + ex.Message);
  }
  finally
  {
    myConnection.Close();
  }
}

<configuration>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <qualifyAssembly partialName="Vigila.Objects"
        fullName="Vigila.Objects, Version=0.0.1.0, Culture=neutral, PublicKeyToken=caa4a15766f8ec1a" />
    </assemblyBinding>
  </runtime>
</configuration>

AssemblyName asmName = this.GetType().Assembly.GetName();