Open folder to location of a file with C#

Sometimes the simplest things are the hardest for me to remember.

Earlier I had wrote the same code for VB6

string myPath = @"C:\Users\admin\Desktop\fotos";

System.Diagnostics.Process prc = new System.Diagnostics.Process();

prc.StartInfo.FileName = myPath;

prc.Start();

Use while loop through table

Needed a solution to loop through a sql resultset without a temp table / table variable / cursor.
Found this question: http://stackoverflow.com/q/1578198/44597

My answer: http://stackoverflow.com/questions/1578198/can-i-loop-through-a-table-variable-in-t-sql/7417780#7417780

declare @id int

        SELECT @id = min(fPat.PatientID)
        FROM tbPatients fPat
        WHERE (fPat.InsNotes is not null AND DataLength(fPat.InsNotes)>0)

while @id is not null
begin
    SELECT fPat.PatientID, fPat.InsNotes
    FROM tbPatients fPat
    WHERE (fPat.InsNotes is not null AND DataLength(fPat.InsNotes)>0) AND fPat.PatientID=@id
    
    SELECT @id = min(fPat.PatientID)
    FROM tbPatients fPat
    WHERE (fPat.InsNotes is not null AND DataLength(fPat.InsNotes)>0)AND fPat.PatientID>@id
        
end    

T-SQL Merge Example using a value pair

merge W_Entity_Pool
          using ( SELECT 58 AS entity_typ_cd) AS A
                  ON A.entity_typ_cd = W_Entity_Pool.entity_typ_cd

when matched then
update set pool_seq_num = 5

when not matched then
INSERT(entity_typ_cd,DATA_DOMAIN_ID, pool_seq_num)
values(58,1,5);

   C# code to add a column to an existing MS Access Table.

Revised  post to correct the horrible code formatting.  Sorry....

public static void AddDAOTableColumn(string MDBfile, string tableName, string ColumnName, TypeCode dataType, Int32? columnSize, bool AutoNumber)

{

try

{

EnterProc(System.Reflection.MethodBase.GetCurrentMethod());

dao.DBEngine DBE = new dao.DBEngine();

dao.Database DB = DBE.OpenDatabase(MDBfile, false, false, "");

LogValue(string.Format("Opened Database: {0}", DB.Name));

dao.TableDef table = DB.TableDefs[tableName];

LogValue(string.Format("Found Table: {0}", tableName));

bool bAddColumn = true;

if (table != null)

{

foreach (dao.Field fld in table.Fields)

{

if (fld.Name == ColumnName)

{

bAddColumn = false;

break;

}

}

}

else

bAddColumn = false;

LogValue(string.Format("Table.{0} exists?:{1}", ColumnName, !bAddColumn));

if (bAddColumn)

{

dao.DataTypeEnum columnType;

switch (dataType)

{

case TypeCode.Boolean:

columnType = dao.DataTypeEnum.dbBoolean;

break;

case TypeCode.DateTime:

columnType = dao.DataTypeEnum.dbDate;

break;

case TypeCode.Int16:

columnType = dao.DataTypeEnum.dbInteger;                            

break;

case TypeCode.Int32:

columnType = dao.DataTypeEnum.dbLong;                            

break;

case TypeCode.Object:

columnType = dao.DataTypeEnum.dbMemo;

columnSize = null;

break;

case TypeCode.String:

if (columnSize <= 255)

columnType = dao.DataTypeEnum.dbText;

else

{

columnType = dao.DataTypeEnum.dbMemo;

columnSize = null;

}

break;

default:

columnType = dao.DataTypeEnum.dbText;

if (columnSize == null)

columnSize = 50;

break;

}

dao.Field newfield = new dao.Field();

newfield.Name = ColumnName;

newfield.Type = (short)columnType;

if (newfield.Type == (short) dao.DataTypeEnum.dbText)

newfield.AllowZeroLength = true;

if (columnSize != null)

newfield.Size = Convert.ToInt32(columnSize);

if (AutoNumber)

newfield.Attributes = (int)dao.FieldAttributeEnum.dbAutoIncrField;

table.Fields.Append(newfield);

table.Fields.Refresh();

DB.TableDefs.Refresh();

LogValue(string.Format("Created Column: {0}", newfield.Name));

DB.Close();

table = null;

newfield = null;

DB = null;

DBE = null;

}

ExitProc(System.Reflection.MethodBase.GetCurrentMethod());

}

catch (Exception ex)

{

ErrorLog(ex);

}

}