Hi folks! this is the code thats giving me problems.

try{
ResultSet rs = Main.dbase.search("select * from myTable");
//rs.next()
while(rs.next())
{
cmb.addItem(rs.getString(1).trim());
}
rs.close();
} catch (Exception ex) {System.out.println(ex);}

here dbase is an object executing Statement.executeQuery, and cmb is JComboBox. the problem is that even though the table has 10 rows, i get only single row in cmb. if I don't comment out the first rs.next(), i get the 2nd row in cmb. i tried to track the value of rs.next() and found that after while(rs.next()) it gives out false, always. My target is to get all the 10 values in cmb.

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

which database should I use in order to achieve the highest speed possible while reading and writing? I need to write to database once, but read the database quite often I write about a million strings.

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

hey thanks fer tha info

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

Yes I need frequent data retrieval. can you tell me waht will be the right data structure to do so. Thanks

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

if you mean using the Trim() function, there is no need because there are no spaces(leading or trailing). thanks anyway for the suggestion.

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

My app saves data (string) in the database which is of .mdb format. At the startup all the data from the database is loaded into the memory because the app needs to iterate through the data many times. I think it will be faster to iterate through the string array rather than iterating through the database, thats why i load it in a string array. am I correct in thinking so? I use ADODB to connect to the database. Is there a way to have the strings in the memory, without eating up the RAM? how do i convert the data into stream? well what is stream anyway?

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

My main motive is to save the data in the database and then on loading the application ALL the data from the database is loaded into an array of string datatype. well it is really essential to load all the data, so i'll have to load it. what i am looking for is a method to lower the memory utilization. i tried to minimize the window and then restore it. This solves the memory problem but i want to use it as the last available option. can you(or anyone) tell me how to lower the memory(RAM) utilazation?

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

Hi all. in my app i have to load one or two million of strings from the database to an array. after loading i close the database connection. i run a FOR loop and load the array but memory reaches 125 MB how to make it low?

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

well.... partially you were correct to guess. what you suggested was not the Q i asked. But I am glad for the links of these articles. Thanks. My initial problem is solved. It was a case of index. Let me explain my 2nd Q. Suppose i have new database D. In it i write about 20 MB of data. so the size of D is 20 MB. What I wish is compress D so the 20MB reduces to a less value. Is it possible?

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

No No This was not the case. thanks anyway for trying to help.

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

I have a database in which I put data by using ADO. The database is .mdb When i run the sub which puts the data in the database everything goes fine. I add about 30k rows. But when i run the same sub again,ie when i update the database, it tries to put the data, but in that data some old data is also present and there comes a msgbox saying that duplicate entries and much more. How to avoid this? one more Q: the size of the mdb file reaches to 50MB. is there a way to have the size less?

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

hey thanks! but i have one more doubt. suppose i have a bitmap : rectangle(0,0,10000,10000) and i want to have a another bitmap having (300,300,300,300) of the above bitmap, how can i do that.

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

i am using the drawimageunscaled from drawing a bitmap before showing the image i am setting the height and width of form = that of bitmap

height = b.height
width = b.width

but if the image is large, say, 3 megapixels then the size of form is limited to resolution of monitor what should i do?

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

Hi I got the answer to my question. The file gets read quickly but the sorting in to the array takes time. There one thing I would like to ask you. The basic purpose of this is to search within the text file for a word. As there can be multiple occurrences of that word I first put the sentences, sentence by sentence, into an array. Then I search the array element by element to find the word by looping through the array. Now if I use the database, I would have access to the data already sorted sentence-wise. Then I just need to loop the database to search. Now I wanted to ask you, if I use the above defined process, will it be faster? Is the algorithm I am following is an efficient one? I know you are a busy man. But please spare a minute and tell me. Thanks.

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

Hi Luc, Thanks for reply. Yes I do more than reading. I read the file.

Dim s$ = my...readalllines(myfile.txt)

There are sentences separated by # which I transfer in an array so that one sentence get into one element of array using simple code of 6 lines. This operation I do in the variable s. that's all I do. The size of the testing file is 10 MB and it takes about 4 min and 24 s The size of real file is nearly 50 MB. So what do you suggest now?

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

Hi In my app i have to read thousands of lines of data written in a text file. I have saved the lines previously. The size of text file is 50 MB. My problem is that it takes a lot of time to read that. If i save the lines in a database, would the 'reading' be faster?

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

Hi Luc, Can you please tell me what details you want? My code is exactly as listed in the article shown above. The string to encrypt is: encryptitman The key I use is: 123456789012345678901234 The iv I use is : 12345678 The encryption goes on fine but the code is not able to decrypt the encrypted string. I supply the encrypted string exactly to the decrypt function.

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

Hi I searched google for encryption algorithms to use in vb 2008 and got one listed in CodeProject listed at Making TripleDES Simple in Visual Basic .NET[^] It encrypts the string fine but is not able to decrypt it and shows the following message. Length of the data to decrypt is invalid. I searched google for the solution but not got any satisfying one. what to do now?

TheMrProgrammer http://www.icbse.com/2009/funny-exam-answers-school-students http://download.cnet.com/TheCalcMan/3000-2094\_4-10958266.html

try filext.com if you want info abt extension.

TheMrProgrammer TheCalcMan: A no-mouse required Calculator supporting constant operator and visual effects Try it once, its awesome! Just 17.1 KB download. No installation required. No dlls. Just unrar and go. And its a freeware. http://www.hotlinkfiles.com/files/2646879\_9gqxe/TheCalcMan.rar http://www.icbse.com/2009/funny-exam-answers-school-students

i think that you are loading too many databases' tables into memory

TheMrProgrammer TheCalcMan: A no-mouse required Calculator supporting constant operator and visual effects Try it once, its awesome! Just 17.1 KB download. No installation required. No dlls. Just unrar and go. And its a freeware. http://www.hotlinkfiles.com/files/2646879\_9gqxe/TheCalcMan.rar http://www.icbse.com/2009/funny-exam-answers-school-students