C#

protected void btnSubmit_Click(object sender, EventArgs e)
    {
        try
        {

            ErrorMessage.Text = "";
            cnx.Open();
            SqlCommand insertCmd = new SqlCommand("INSERT INTO TransactionType(Transaction,Description,Category,Active) 
VALUES(@Transaction,@Description,@Category,@Active)", cnx);
            insertCmd.Parameters.Add("@Transaction", SqlDbType.NVarChar, 50);
            insertCmd.Parameters["@Transaction"].Value = txtProgram.Text;

            insertCmd.Parameters.Add("@Description", SqlDbType.Text );
            insertCmd.Parameters["@Description"].Value = txtdescrip.Text;

            insertCmd.Parameters.Add("@Category", SqlDbType.NVarChar ,50);
            insertCmd.Parameters["@Category"].Value = DdlCategory.Text;

            insertCmd.Parameters.Add("@Active", SqlDbType.NChar ,10);
            insertCmd.Parameters["@Active"].Value = DdlActive.Text;

            insertCmd.ExecuteNonQuery();
            ErrorMessage.Text = "Successful";
            cnx.Close();
        }
        catch (Exception ex)
        { 
            ErrorMessage.Text = ex.Message;
        }
    }

int[,] Grid = new int[20,20];

[StructLayout(LayoutKind.Sequential, Pack = 1)]
public class MISSING_TRANS
{
    public UInt32 FirstTrans;
    public UInt32 LastTrans;

    public void byteSwap()
    {
        ISPData.swap4Bytes(ref FirstTrans);
        ISPData.swap4Bytes(ref LastTrans);
    } // end byteSwap()
} // end class MISSING_TRANS


[StructLayout(LayoutKind.Sequential, Pack = 1)]
public class REGISTER_TOTALS
{
    public RECORD_ID recID;  // 8
    public UInt16 RecordVersion;
    public UInt16 LocationNum;
    [MarshalAs(UnmanagedType.ByValArray, SizeConst = 52)]
    public byte[] Filler1;
    public UInt32 RegRdsTotal;           // 08.08
    public UInt32 CalcRdsTotal;          // 08.08
    public UInt16 RegRdsCount;           // 08.08
    public UInt16 CalcRdsCount;          // 08.08

    ...
    [MarshalAs(UnmanagedType.ByValArray, ArraySubType = UnmanagedType.Struct,
               SizeConst = 6)]
    public MISSING_TRANS[] missingTrans;
    public UInt16 RegisterForceClosed;
    public UInt16 RegisterModel;

    ...
} //end class REGISTER_TOTALS