About Rohit Prakash Expertise I can answer questions on VB.NET 2003. Areas include: Designing/Developing/Deploying desktop/client-server applications. I can also help in database connectivity using ADO.NET to connect to popular databases like Oracle,Access,SQL Server,MySQL,PostgreSQL etc.
Experience I have 3 years experience using Visual Basic.NET in corporate environments. I have been providing consulting to private organizations and large departments and also developed solutions for custom needs.
Education/Credentials Master of Computer Applications.
Expert: Rohit Prakash Date: 2/24/2007 Subject: image of datagrid
Question We thought of that, we also thought of writing a trigger so that whenever any updations or insertions are made they get recorded .but the image of the db appeared as the best solution because first it would be visually more pleasing are we are not working in english but hindi ,second the users of the software are not so computer literate so a simple button press and the whole db gets stored in an image appeared as an easy alternative and third if the user ever wanted review some changes he could open the image and see the changes done.He could get the old value from the image and the new value is already in the db.
What do you think Is our solution feasable?
-------------------------------------------
The text above is a follow-up to ...
-----Question-----
hi again rohit
Actually the problem is this we have a database and we have a vb.net program that has a datagrid to display the records to the not so computer literate user.
Now the database gets updated yearly and the changes made are numerous.Some new records are added ,some are updated etc.Now since the database has changed we need a record for future reference as to what was displayed earlier i.e before the changes were made.
So we were thinking of offering a button in the program that could save the image of the datagrid before the changes were made and save the image on disk.
This was our plan .Can you suggest another way to do this?
Thank you
-------------------------------------------
The text above is a follow-up to ...
-----Question-----
Hello rohit
How can i create an image of a datagrid lets say in gif format and save it on disk
Eg:-
If the grid contains 100 records then the first 50 records should be saved in a first gif and the rest 50 in another gif
Can images be created of datagrid's ?
Thank you
-----Answer-----
Sourav,
Your questions seem to be interesting and bit awkward. You want to do things that are not done in real world.
Any way, why not press PRINTSCREEN button when your first 10 records are displayed on screen and convert the image to GIF from a tools like Photoshop.
-----Answer-----
Sourav,
Follow a professional approach. Storing images is not accurate and it does not guarantee the result you are expecting.
For this type of situations what is professionally done is called "Database Logging". Check the documentation of PostgreSQL and Oracle databases. Though you need to design your own approach after studying the basic functionality there.
I would suggest that whenever your application starts, it should create a Log File (simple text file) and whenever any insertion, deletion or update is about to happen you transfer the values to that text file along with date and time of insertion.
Here you have to note that your program must not write to the same file daily instead it should create a new one daily. This way you can check the logs of users actions any time.
Please let me know if it helps you.
Answer I don't think the image solution feasible. The images will occupy more space as compared to simple entries. Alternatively you can make a table in your database itself where each and every change is recorded. You can query this table to display the changes to the user.
