C#

Quote:

i think it's hard create instance to each new line in invoice lines

for ( i = 0; i < datavalu.GetLength(0); i++)
           {
               InvoiceLine invoiceline2 = new InvoiceLine();
               invoiceline2.description = datavalu[i, 0].ToString();
               invoiceline2.itemType = datavalu[i, 1].ToString();
               invoiceline2.itemCode = datavalu[i, 2].ToString();
               invoiceline2.internalCode = datavalu[i, 3].ToString();
               invoiceline2.unitType = datavalu[i, 4].ToString();
               invoiceline2.quantity = int.Parse(datavalu[i, 5].ToString());

               invoicelines.Add(invoiceline2);


           }

InvoiceLine invoiceline = new InvoiceLine();

Alex Dunlop wrote:

In the code above, dictionary puts information inside [ ] mark.

pair.ToString()

KeyValuePair<string, string> foo = new KeyValuePair<string, string>("foo", "bar");
Console.WriteLine(foo.ToString());

[foo, bar]

string[] my_arr = pair.ToString().Split(',');
my_table_code.Rows.Add(my_arr[0], my_arr[1], my_arr[2]);

// This assumes that Key is a single text, not a comma separated list of values like the Value part
string[] my_arr = pair.Value.Split(',');    // Only split the Value (already a string, not the whole KeyValuePair
my_table_code.Rows.Add(pair.Key, my_arr[0], my_arr[1]);   // Prepend the key as the first item listed

IntPtr m_pIDL = IntPtr.Zero;
hRes = ShellAPI.SHGetSpecialFolderLocation(IntPtr.Zero, CSIDL.CSIDL_DESKTOP, ref m_pIDL);

hRes = ShellAPI.SHGetFolderLocation(IntPtr.Zero, 0, IntPtr.Zero,0, out m_pIDL);

SHFILEINFO shInfo = new SHFILEINFO();
ShellAPI.SHGetFileInfo(m_pIDL, 0, out shInfo, (uint)Marshal.SizeOf(shInfo),
    SHGFI.DisplayName | //0x000000200
    SHGFI.PIDL | //0x000000008
    SHGFI.SmallIcon |//0x000000001
    SHGFI.SystemIconIndex //0x000004000
);

畂敲畡

EnumObjects

[StructLayout(LayoutKind.Sequential, CharSet = CharSet.Auto)]
   public struct SHFILEINFO
   {
       public IntPtr hIcon;

       public int iIcon;

       public uint dwAttributes;

       [MarshalAs(UnmanagedType.ByValTStr, SizeConst = 260)]
       public string szDisplayName;

       [MarshalAs(UnmanagedType.ByValTStr, SizeConst = 80)]
       public string szTypeName;
   }

[DllImport("shell32.dll")]
//public static extern Int32 SHGetFolderLocation(IntPtr hwnd, int csidl, HANDLE hToken, DWORD dwFlags, PIDLIST_ABSOLUTE* ppidl);
public static extern int SHGetFolderLocation(IntPtr hwndOwner, int csidl, IntPtr hToken, uint dwReserved, out IntPtr ppidl);


[DllImport("shell32.dll", CharSet = CharSet.Auto)]
public static extern IntPtr SHGetFileInfo(string path, uint attributes, out SHFILEINFO fileInfo, uint size, uint flags);

[DllImport("shell32.dll")]
public static extern IntPtr SHGetFileInfo(IntPtr pIDL, uint dwFileAttributes, out SHFILEINFO psfi, uint cbFileInfo, uint uFlags);
#endregion

var identity = System.Security.Principal.WindowsIdentity.GetCurrent();
string userName = identity.Name.ToString();
string userSID = identity.User.ToString();
List<string> MegaFolderPaths = new List<string>();

RegistryKey clsidKey = Registry.Users.OpenSubKey($"{userSID}\\Software\\Classes\\CLSID");

//Get all the sub keys it contains
foreach (string subKey in clsidKey.GetSubKeyNames())
{
    RegistryKey clsidSubKey = Registry.Users.OpenSubKey($"{userSID}\\Software\\Classes\\CLSID\\{subKey}\\Instance\\InitPropertyBag");

    if (clsidSubKey == null)
        continue;

    string defaultValue = (string)clsidSubKey.GetValue("TargetFolderPath");

    if (!string.IsNullOrEmpty(defaultValue))
        MegaFolderPaths.Add(defaultValue);
}

[DllImport("shell32.dll", CharSet = CharSet.Auto)]

public static extern Int32 SHGetFileInfo(IntPtr pIDL, uint dwFileAttributes,
                        out SHFILEINFO psfi, uint cbFileInfo, uint uFlags);

string maindata = "Operational Metrics~Domestic Subscribers Disney+~2015 FY~9999";
string data =     "Operational Metrics~Domestic Subscribers Disney+~2015 FY~9999";
string strformula = Regex.Replace(maindata, data , "W51",RegexOptions.None);

string maindata = @"Operational Metrics~Domestic Subscribers Disney+~2015 FY~9999";
string data = @"Operational Metrics~Domestic Subscribers Disney+~2015 FY~9999";
data = Regex.Escape(data);
string strformula = Regex.Replace("\"" + maindata + "\"", "\"" + data.Replace("(", "\\(").Replace(")", "\\)").Replace("$", "\\$") + "\"", "W51", RegexOptions.None);