Hey i am making a project on VB.NET in which my text boxes have FONT property set to "TERAFONT-VARUN, 12pt " which is for GUJARATI language.
Now i want to save the data of text box into my MS ACCESS data base.
I also want to retrieve that data for other purpose.
Can you please tell me what to do?
.Net uses Unicode and you should be able to safely save Unicode strings to Access without problems.
Note that the font you are using doesn't matter here, it's only important for displaying Unicode to the user. It has nothing to do with the database.
To save data to Access from .Net, you can have a look at these resources:
How do you insert new entries into an Access db table through an ASP.net website?
Introduction to some basic classes of ADO.NET on CodeProject.
This should get you started on using Access databases from your .Net programs.
Please note that unicode text inserting to or from the database is not the issue neither formating the unicode. The problem to notice is that while inserting, unicode may contain coded value (") which indirectly terminates the string at that point only. and the rest of the string is considered as code, which is considered to be stack overflow by the program at the runtime.