C#

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

public bool IsVistaOrHigher
{
  get { return OSVersion.Version.Major >= 6);
}

public bool IsVistaOrHigher
{
  get
  {
    return IsVistaOrHigherHelper();
  }
}

private bool IsVistaOrHigherHelper()
{
  IntPtr hModule = LoadLibrary("Kernel32.dll");
  if (hModule != null)
  {
    IntPtr proc = GetProcAddress(hModule, "MoveFileTransactedA");
    return proc.ToInt32() != 0;
  }
  return false;
}

Luc Pattyn wrote:

make things needlessly hard

Shy Agam wrote:

That would create a potential problem if the Image is used elsewhere around the application.

Shy Agam wrote:

Should my UserControl dispose of it when it gets disposed?

Pete O'Hanlon wrote:

going way beyond the original problem

Luc Pattyn wrote:

another Manager

Luc Pattyn wrote:

curiosity. the ambition to learn. generalization. advancement. you name it.

Pete O'Hanlon wrote:

I'm almost tempted to write a blog post demonstrating this.