C#

George_George wrote:

You mean what is not going to happen?

George_George wrote:

do you have any related materials to recommend?

George_George wrote:

But what I am asking is the best practices for data access patterns

George_George wrote:

- I want to let client side library to start multiple threads to work efficiently to request for multiple content at the same time other than a single thread pattern;
- But I do not want to hit the server too hard and I also do not want to the library to consume too much resources (memory/threads) on client side to block other work of the client. The library is delivered as a DLL, so loaded into client side process, and will compete for resources of the same process.

Are there any good design patterns for such issues?

private DataTable GenDT(string strSelect)
{
    DataTable _dt = new DataTable();
    new OracleDataAdapter(strSelect, oraCONNECTION).Fill(_dt);
    return _dt;
}

private void Populate_treeView1()
{
    DataTable dt1, dt2, dt3;
    int ID;
    string sep, seperator;
    sep = ":";

    #region Table1
    dt1 = GenDT("SELECT * FROM Table1");
    for (int x = 0; x < dt1.Rows.Count; x++)
    {
        ID = int.Parse(dt1.Rows[x]["ID"].ToString());
        Name = dt1.Rows[x]["NAME"].ToString();

        treeView1.Nodes.Add(Name + sep + ID.ToString(), Name);

        #region Table2
        dt2 = GenDT("SELECT * FROM Table2 WHERE T2_Table1_ID = " + ID);
        for (int y = 0; y < dt2.Rows.Count; y++)
        {
            ID = int.Parse(dt2.Rows[y]["ID"].ToString());
            Name = dt2.Rows[y]["NAME"].ToString();

            treeView1.Nodes[x].Nodes.Add(Name + sep + ID.ToString(), Name);

            #region Table3
            dt3 = GenDT("SELECT * FROM Table3 WHERE T3_Table2_ID = " + ID);
            for (int z = 0; z < dt3.Rows.Count; z++)
            {
                ID = int.Parse(dt3.Rows[z]["ID"].ToString());
                Name = dt3.Rows[z]["NAME"].ToString();

                treeView1.Nodes[x].Nodes[y].Nodes.Add(Name + sep + ID.ToString(), Name);
            }
            #endregion
        }
        #endregion
    }
    #endregion

    treeView1.ExpandAll();
}

Decad wrote:

Am having a problem with TBBUTTON struct in Vista X64

typedef struct _TBBUTTON {
    int iBitmap;
    int idCommand;
    BYTE fsState;
    BYTE fsStyle;
#ifdef _WIN64
    BYTE bReserved[6];          // padding for alignment
#elif defined(_WIN32)
    BYTE bReserved[2];          // padding for alignment
#endif
    DWORD_PTR dwData;
    INT_PTR iString;
} TBBUTTON, NEAR* PTBBUTTON, *LPTBBUTTON;
typedef const TBBUTTON *LPCTBBUTTON;

[StructLayout(LayoutKind.Sequential)]
internal struct TBBUTTON
{
    public Int32 iBitmap;
    public Int32 idCommand;
    public byte fsState;
    public byte fsStyle;
    public byte bReserved1;
    public byte bReserved2;
    <code>public byte bReserved3;
    public byte bReserved4;
    public byte bReserved5;
    public byte bReserved6;</code>
    public <code>IntPtr</code> dwData;
    public IntPtr iString;
};

Mark Salsbery
Microsoft MVP - Visual C++