Need a procedure in SQL for translate a datatable in English to Arabic .I am having English table which is having category ID ,Code etc upto 25 columns in the SQL Database.We want to translate this table to arabic when user opts for Arabic .So need a procedure to convert this English table to Arabic.Do i want to use google translator for this case . Then how will it is linked with database .
View 1 Replies
design a form with multilingual on interface depend on the user!
View 6 RepliesI m working on an school management application, i design the database in access2003 and forms in vb.net2005. but i dont have any idea about the database conectivity. with the help of a book to connect with the db but i cannot save the data in the mdb file. in my application 1 add the followin buttons add new record modify record delete search using id or enrolment no.
View 1 RepliesI'm trying to learn how to make multilingual apps. All defaults text for controls are saved in Form1.resx (Created automatically by VB.NET). I've set the Localizable property to True and Language to German(Austria). So far so good and VB.NET created the file Form1.de-AT.resx.Both resource file contain text for the different controls on the form. When I click on a particular button on the form, I want a custom message to be displayed according to the language setting/resource file in use.In both Form1.resx and Form1.de-AT.resx i've added another row for the custom message. How do I write the code so that when the button is clicked, it retrieves the custom message from the appropriate resource file? [code]Another thing, is Localization only for changing language or does it affect date and number formats also? Just asking because if a PC Regional Options settings is set to English(United Kingdom) and I do 5/2 the result is 2.5. If it's set to German(Austria) the result returned is 2,5But in VB.NET, if I use Thread. CurrentThread.CurrentUICulture = New CultureInfo("de-AT") (i.e German-Austria) the result returned for 5/2 is 2.5 and not 2,5
View 1 RepliesI need to write multilingual application (two languages). That's means labels, buttons and other objects on forms display in language which user can select. This n-tier (3-tier) application with central database on remote machine.
View 15 RepliesI am currently working on converting an app from VB6 to VB.NET 2.0 - I am only using 2.0 to provide Win 2k compatibility, AFAIK, Win 2k can't run any framework newer then 2.0. Part of the conversion includes moving multilingual support over. In the VB6 version, we were storing the translated text in an Excel document - the xls could be passed to translators. A script in the xls file would dump the languages to individual text files and generate a LanguageRescource.rc file which was then compiled using RC.exe.
When the app started or the user selected a language, the resource file was read using:
Public Sub LoadLang(ByVal LangNum As Byte)
Dim bData() As Byte
[CODE]...
It was then split using vbNewLine as a delimiter and the lines assigned to the labels and to a public array for use in other places in the program (message boxes, log files, etc). Doing the same thing in .NET doesn't seem possible, or is rather convoluted. I have read many articles on globalisation, localisation, etc and it doesn't make a whole lot of sense to me. I am wanting to have the language files built in to the executable, not as dependencies. From what I can tell after reading all of this information is there are at least 2, if not more to do it.
1) Use form localisation. This would require changing all the captions and things for each language, this would in turn generate frmMain.<lang>.resx files.
The correct file would be loaded automatically on form/program startup and is hard to change at runtime if the user wishes. it would also cost me a fair bit of time to add every one of the 23 languages. It also would not satisfy my other requirements of message boxes and output to log files.
2) Make a resource file and store the strings in there, in a similar fashion to what I was doing in VB6. The problem is, how do I separate each languages strings? Each resx file only seems to be capable of storing on string table.
I want to update my existing application(s) to support multiple languagescultures.
There are a lot of artilcles on Globalization and using cultureinfo class.
I haven't came accross any article which tells about the approach to carry out such conversions.
From what i can see is that I have to update all my interface text , consider culture specific number, date formats and string comparisons.
1. What is most recommendedused method for setting interface text to support multiple languages.
2. Are there any tools available which helps me carry out these changes
I am developing an multilingual application in vb.net 2008.I had given a combobox for language selection when user select any language like marathi or hindi then all labels are change in the selected language but i am facing problem with textbox if i select any language it takes input from user in english only.I want when user select any language and enter data in textbox then he is able to enter data in the selected language.
View 2 Repliesimplmentation of using resource files for my UI, based of user preference.
Note: Ive never worked with resources files before for creating a multi-lingual app.
also this might be placed on the wrong forum board.
How to load external xml files for multilingual purposes?
View 4 RepliesTrying find some good examples of support different languages in VB.NET. I've read sites on System.Globalization and resource files but none explain fully how to implement them in my application.
What happens to the form title, msgbox strings etc. How do I make these multilingual?
We have localized our application menubar(Ex: Spanish language).The menubar menuitems have few shortcut keys i.e CTRL + N along with the text. The shortcut key is diplaying in some dummy character.We want the menuitem (Ex: New File CTRL+ N) text in local language and CTRL+ N should display as English
cMenuBar.Font = New Font(Configfontname, Configfontsize)
strMenuText = rsManager.GetString("cbmNewFold")
cbmNewFold = New CommandBarButton(ilToolbar20.Images.Item(0), strMenuText, New
[code].....
The main purpose of the my app that I need your help with is, to deliver an always (or close to) up to date a list of files for the user to choose from for a variety of common purposes. For instance, opening the selected file in its native client editor application so the user can make changes. Another purposes would be to print the file, and I have others.
If nothing else (meaning recommendations for a better design that still keep my desired in mind) I'd like ideas on how to update my complex DataSet (background processing options, what's the most efficeient/quickest way to update my DataSet) as the list of files changes while my app is running and my app is designed to never close due to the long amount of time it take to load it initially.
The list must be always kept up to date while my app is running because not only the intial loading of data takes a lot of time but updates (new/modified/deleted) could potentially take too long depending on not only how much data to update/add (new files) but how efficeient my code is in updating the list. To be perfectly clear: If a new file is created then it need to be somehow (automatically preferably or manually i.e. button code) add to the list. If a file is deleted then it needs to bet removed from the list. And if the file has changed, perhaps some of it metadata or thumbnail image have changes so update the file's data in the list. All of which (new/modified/deleted) need to be as real-time as possble without degrading the server too much and without the user waiting more than a handful of seconds.
Listing all the files as quick as possible whether that be with or without metadata initially is very important because most of the time the user is going to filter (or scroll the list by typing) for a partial file name. Once the user filters/scrolls to the desired file there's a very good chance that he/she isn't even interested in the metadata, most of the time the user wants my app to open the selected file in its native client editor application so he/she can view or modify the file. The initial
load time of the data doesn't concern me as much as updates because the user can possibly do other things while it initially loads all the data as long as it not too long (more than a few minutes). From there the updates will either be automatic if possible (most desirable from a users standpoint) or the user initiated (e.g. button). Plus I'm thinking the updates might need to be done with a few different background processes (multiple threads) because I think I need one for periodic updates (e.g. every
15 minutes) and one background process for page updates meaning whatever the user has either scrolled to or filtered for, more accurately all files currently display to the user will be systematically update in the background so the user can still operate my app.
I'm currently using SqlDataAdapter.Fill to fill a DataSet object variable (which is bound [BindingSource] to a DataGridview control) to first populate the DataSet from the SQL query and then prorgammatically adds records (DataRow) for local files but please make recommendations. I don't mind big changes or starting over if necessary, I just want the best app possible based on the aforementioned criteria. I'm not sure if it complicates matters but I've also added custom columns in the DataSet for some special needs (thumbnail of files, booleans for tracking custom statuses). For the local files I'm currently populating the DataSet prorammatically (iterating a path/file string collect made by System.IO.Directory.GetFiles) since the list is first (and very quickly) populated with Vault files (which is always a far larger list than the local files) so . Again, I don't have to take this direction, make recommendations.
i try using both detail view and form view but they are not flexible enough to place my picture where i want it
View 1 RepliesI've been studying design patterns off-and-on now for a project I've recently been working on. I've been fortunate with this last one not to have to work with databases, but will soon have an opportunity.
View 8 RepliesI am developing an "AddressBook" like project in VB.NET. While developing database in SQL Server2005, i want to follow the principals of normalization and keep its degree of normalization as high as possible. Fields i am using are these.
Create table AddressBook_Contact
(
Contact_ID int Primary Key,FirstName varchar(15),MiddleName varchar(15),LastName
[code]......
I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends. I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea of how I would go about designing the classes for the system, the bit that I don't know how to do is, how I would go about getting the data to and from the database.
For example with my other applications, I have done a couple of things;
1) Gathered all the data when the application started up, creating the objects then. Then when the application closed sending the data back to the database.
2) Have the code which deals with getting the data in the specific class, so the student class for example would take only one constructor argument which would be the studentID, then the class code would connect to the database and populate the object fields as appropriate.
3) Variations of the above. I have also looked into LINQ, which seems like it would be very useful if you don't expect your classes to deal with any business logic and just data, but I suppose it would be possible to create a wrapper class that would include the business logic.
[Code]....
I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends.I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea of how I would go about designing the classes for the system, the bit that I don't know how to do is, how I would go about getting the data to and from the database
View 3 RepliesI am designing a database using access 2010 and I ve been asked to design the user interface with Visual basic.I actually have designed tables and their relationship and did some queries according to the requirements. how do I create user interface in VB from this point knowing I don't have any form and report designed in access?
View 6 RepliesThere exists a database that holds information on each planet in the solar system. The database has multiple tables.The program intends to access this data to display it to the user in a variety of manners. The program does not intend to manipulate the data at its source, though calculations on two fields may be performed to determine certain display characteristics.What is the optimal method for accessing the data?My initial approach, (read: gut feeling, no research) was to take each related row of data from the database and create an object of a custom class based on the data. So you might wind up with:[code]Then use these objects to perform whatever actions the program needed to. I ran into a lot of problems trying to implement this, so that I believe my design approach is fundamentally flawed.
View 1 RepliesI am looping through a database with pdf locations. The application is button click event driven. The problem I am having is that I display a pdf. If the user clicks on the button then the pdf information is inserted into a database and the loop should be taking me to the next pdf. However, this loop does not seem to give what I need. What ends up happening is the first pdf gets displayed twice. I think mainly because I display the first pdf onload, but when I click the button it agrees and grabs the first item from the database. And it ends up falling behind because its restarting the query and I cant quite figure out how to get the button to catch the first displayed pdf, or skip it entirely since I am using a welcome pdf. So on the welcome pdf that is supposed to be displayed initially the user clicks agree and it agrees to the welcome pdf instead of just skipping it. I am not quite sure how to just move past the pdf.
public sub onload()
display the welcome pdf
end sub
[CODE]...
Now if I run the code without the loop it works fine. I just end up having to run the app however many pdfs I have in my database.
query data
display data
insert data
Windows.Forms.Application.Exit()
To display pdfs I imported the com control for adobe so pdfs get displayed like this:
axacropdf1.src = my.mysettings.default.readpath & pdflocation
pdflocation is passed from a query fill.
I think I have an underlying design issue which probably precedes the loop.
I am using visual studio 2008 professional edition, and i need some help in my assignment project.below are my screen interface and my database design view, relationship view, and coding and this is my coding Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
[Code]...
:( I am have been trying to update changes from my vb.net program to an access database file and it simply will not work. I have am using table adapters. I'm not familiar with SQL so i can't go that route. It updates the dataset fine but not the database...
I have pasted my code below.
Private Sub BooksBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BooksBindingNavigatorSaveItem.Click
[code]....
I'd like to get some feedback what you think is the best way of designing a VB 2005 application that can be set up ("scaled"?) to work with different database backends (say MS-Access vs. SQL Server vs. Oracle). For example, where would you store the connection info, where should the repository of SQL statements (which will vary slightly from DBMS to DBMS) reside, etc.
View 9 RepliesDeveloping a multilingual application in VB.Net 2008, Im able to add resources to forms and create a multilingual forms depending on uiculture. On reading Msdn on creating the multilingual string values for messagebox contents, have added the .resource file to the project files path as specified. There is no error on compilation but throws the MissingManifestResourceException error
Dim rm As ResourceManager
rm = ResourceManager.CreateFileBasedResourceManager("strFormResources", ".", Nothing)
[code].....
There is strFormResources.resources and strFormResources.fr-FR.resources in Resources of the project. I have searched for this error details but could not find a solution. What am i doing wrong or is there any other method for displaying multilingual strings in the messagebox.
I would like to creat database by access 2010 in design view i am using data type is Attachment. Then i want to connect this access with vb 2010 .. now how can effect attachment file Which code i can use?
View 7 RepliesShould I run a classic VB6 app thru the upgrade wizard in VS08 or should I re-design it from scratch. The database is a mess. Originally designed in ACCESS and imported to MS SQL SERVER. The main entities are e.g. ROLLER_SKATES and RENTALS. If you would like to rent a pair of roller skates you can. So this more or less comprises an Inventory system for the roller skates. Now you have 2 different skating rings. Skate-B1 and Skate-Z9, and you keep redundant and duplicate data from the previously mentioned entities in the skating ring tables as well.It's a nightmare.
At least the tables have row ID's. But no explicit foreign keys, just implicit columns identically named that "seem" to correspond to each other. But the rest of the table's attributes all default to NULL. Considering what C.J Date says about Types in his book SQL and the Relation Model, isn't it desirable to have CHECK CONSTRAINTS on attributes?
I am developing a new application for Students Training. how the database design should be? And could you provide a sample application similar to my requirement? Following is the requirement of the Application, The objectives of the program or application are:
Get Information about the total number of students trained in all company's department
Get Information about the total number of students who were either withdrew/ apologized /rejected
Anticipate of the future needs for student's work placement opportunities (numbers of students as well as the majors)
On light of the objectives mentioned above I consider the following data for the application preparation: Company's Department Needs Department Major Number of students for each major Supervisor Mobile Number
If it is possible when entering students details the program will automatically register him/her in the Department that has vacant place and already fit the requirements of the certain department-Internship Information.
I have a multilingual company website (Visual Studio / VB / ASP.NET 4.0), and when, on the homepage, you click a flag, the text changes to that language and stays with you the entire session, after I made a class, BasePage.vb. Everything works great, but the URL never changes .... clients.aspx remains clients.aspx although the text DOES switch to Dutch.
It's been recommended by @Aritstos to make it so it looks like clients.aspx?lang=nl as opposed to just clients.aspx in another language.
Currently, my asp homepage hyperlinks that work look like this:
<asp:LinkButton ID="LinkButton7" runat="server"
CommandArgument="nl" OnClick="RequestLanguageChange_Click"
class="flagbutton">
[Code]....
My click-once app has english and spanish content. In development, it runs fine with the two resource files I have - named multilingual.en-US.resx & multilingual.es-MX.resx accordingly. When I publish it looses these resources for referencing.The files reside in the root directory for the app.
View 1 Replies
