C#

private void myUserControl_MouseEnter(object sender, EventArgs e)
{
   myUserControl.Focus(); //allows the mouse wheel to work after the panel has had the mouse move over it
}

double i = 11157.0;
Console.WriteLine(i.ToString("#.#"));

using (Graphics g = Graphics.FromImage(myBlankCertificate))
   {
   g.DrawString(myCertificateOwnersNameString,
                fontIWantTheNamePrintedIn, 
                brushColourAndSoForth, 
                rectanglefIFoundEarlier);
   }

Dotnetkanna wrote:

INSERT tDateOrder (d) VALUES ('2/28/04')

<br />
INSERT tDateOrder (d) VALUES ('28/2/04')<br />

cmd.Parameters.Add("@MyDate", SqlDbType.DateTime);
cmd.Parameters["@MyDate"].Value = yourDateTimeVariable;

private void MakeMyTable()
{
  string connectionString = "...";
  using (SqlConnection connection = new SqlConnection(connectionString))
  {
    Server server =
      new Server(new ServerConnection(connection));

    // Create table in my personal database
    Database db = server.Databases["MyDatabase"];

    // Create new table, called TestTable
    Table newTable = new Table(db, "MyTestTable");

    // Create the primary key
    Column pk = GetColumn(newTable, "id", DataType.Int, false);
    pk.Identity = true;
    pk.IdentitySeed = 1;
    pk.IdentityIncrement = 1;

    newTable.Add(pk);

    DataType varchar = new DataType(SqlDataType.NVarChar, 50);
    newTable.Add(GetColumn(newTable, "Name", varchar, false));
    newTable.Add(GetColumn(newTable, "Nickname", varchar, true));
    newTable.Add(GetColumn(newTable, "Title", varchar, false));

    // Create a PK Index for the table
    Index index = new Index(newTable, "PK_MyTestTable");
    index.IndexKeyType = IndexKeyType.DriPrimaryKey;

    // The PK index will consist of 1 column, "ID"
    index.IndexedColumns.Add(new IndexedColumn(index,"id"));

    // Add the new index to the table.
    newTable.Indexes.Add(index);

    // Physically create the table in the database
    newTable.Create();
  }
}

private Column GetGolumn(Table tb, string columnName, DataType type, bool isNullable)
{
  Column column = new Column(tb, columnName);
  column.DataType = type;
  column.Nullable = nullable;
}