a) As soon as page loading memory is assigned but it is not releasing memory after user log out. b) I am using rich component for that I am assigning value from Database (using BEAN). Slowly server memory filling to max. any suggestion.

Hi to all, I am using Rich face components like datatable, extend datatable, combo box, button, text etc... When ever this component is loading it is taking huge memory and later it is not release this memory (even I tried GC also) and reducing performance. How to improve performance and free memory as soon as page close or after component used. Thanks in advance.

Hi Nagy Vilmos, I m update gUserID from database. As soon as login to application. I m setting corresponding user id to that variable and I m utilizing that variable in complete project as global variable. here I m facing problem. As soon as 2nd person login The Value is reset (2nd user id is updating). I m trying your method now Thanks.

Hi to all,

public class xyz {

public static int gUserID = 1;

}

When 1st user Login gUserID value is = 5 and second user login gUserID value is = 7 Problem is 1st user refresh or re-direct to another page gUserID is changing to 7. How to set Global variable for session or any solution to above problem. Thanks.

hi Suresh, Thanks for reply but I am using visual Basic 6.0 Regards, Nanda

Hi to all, I am trying to replicate Menu in Toolbar I can add a first level Toolbar Menu Item. But I am not able to second level or higher. Is it possible to add multi level sub menu ? Regards, Nanda

Hi Developer, I am using one select All Button to select all row in Datgrid (CheckBox selection). So how to Check CheckBox in Datagrid. Regards Nanda.

Hi RAH, I am trying execute my query but it is taking much time(4 to 10 min) to avoid that problem and searching efficient query or solution. The your last post provide some ideas. it reduce execution time. Regards, Nanda

Hi Mika, I done similarly in View. Add a new column unique ID and I am adding rownum. In this case I am executing query without any delay. But one problem is there. In case if order by condition added the output of query is coming wrong(Bug) or a block of rows is order. Regards, Nanda

Thanks. Problem is the table is too big it contains 10 lak to 90 lak data. while access perticular data (ex: 1500000 to 1501000) then it is taking so much time. The Inner Query execute all records (90 lak) and the outer query filter 9991 to 10000. This is my problem. Regards, Nanda

Hi Thanks for Query. It is reduce execution time. but when I try to access above 500000 (Top 500000) records then its taking 2 to 3 min exeuting any other solution. For if 900000 it is taking 4 to 5 min. Regards, Nanda

Hey Thanks, Thanks for your valuable reply. I am using Oracle. The rownum is dynamical assign to each row. so SQL server method is not working. and I tried view it is working but when order by used the result is coming wrong. Thanks and regards, Nanda

Hi Guys! I am trying to retrieve middle records. The below query is working perfectly. The problem is my table is too huge (more then 10 lak reocrd) it is taking more time. Is there any other solution? [This is sample query]

select *
from (select t.*, rownum rn
from (SELECT *
FROM (select * from Productlist)) t
Where rownum <= 10000)
Where rn > 9990

Regards, Nanda

Hi Experts, I am trying to display webcam video/Preview Image in Web browser. But I am not successes I tried following Methods. 1. Search webcam component 2. Used API calls and some related DLL file also. Thanks in Advance.

Hi to all. I am new to WPF. Now I m building a small project. That contain Timer and Label and Datagrid. In Datagrid 7 columns are there. If i add a row in Button_Click Event it is working. But same code not working in Timer In Timer I return below code.

   On Error Resume Next
        Row\_Nos\_Text.Dispatcher.Invoke(New delSetText(AddressOf doSetText), Row\_Nos\_Text, DataGrid1.Items.Count)
        DataGrid1.Items.Add(0)

The Above code display Number of row in textbox but in datagrid row was not added Plz tell how to solved Problem. Thanks in advance. Nanda

I am doing a program that completely depend on serial port. While data receiving event I m getting following error. The calling thread cannot access this object because a different thread owns it. for that I used delegate method. Problem solved.

CP_Text.Dispatcher.Invoke(New DelegateUiText(AddressOf UpdateUiCP))

    Delegate Sub DelegateUiText()
    Private Sub UpdateUiCP()
        CP\_Text.Content = Format(Convert.ToInt32(RxStr.Substring(1, 2), 16) / 100, "0.00") 
    End Sub

But I am using 25 labels and 2 datagrids and 12 textboxs. so i need write above 5 line for all controls so. Is any method, i can handle above error in single method or event? thanks in advance Nanda.

hello to all. I am trying add component Toolkit(Chart). But I am getting Following error. I was tried FrameWork 3.5 and 4.0 both tool but same error is coming There was an error loading types from assembly 'Path\WPF Toolkit.dll"\r\n'Could not load type 'System.Windows.Controls.Primitives.MultiSelectior' from assembly 'PresentationFramework, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.\r\n\r\n Regards, Nanda

I m doing a package in that MS Comm is using for data Receiving and sending. I connected to machine and check communication it is working properly in VB and VB.NET. If i short cable the package working in vb properly but in VB.NET OnComm event not working(Event not Enable). If i change Buad Rate then Junk value is comming and OnComm event enabled). How can i solve this Problem.

I made a huge modification in my uncle business website. It is working properly except searching in google or yahoo (search engine) When I search in google or yahoo it is appear old page names. I deleted that pages. then also same problem. how can i show my webpage name in search engine. I used meta tag also. Thanks in advance.

K I will try once reinstall VS 6.0 application.