VS 2008 Multi Language Application - Two Tables In Database
Jul 10, 2009
I'm building a multi language application, but in the application, there will be some data that will be retrieved from the db. In the db I have two tables (Access Groups, Teams) the two tables are related, there are some groups, that have teams, example (sellers can belong to team 1, team 2, team 3...). The data that will change it's the names for the access groups and the names for the teams. The only way that I can think to do this, is to have the different values for all the languages in the code, or some auxiliar file, and when loading the application I'll truncate the two tables and fill them with the current language values. By the way those values never change...
View 5 Replies
ADVERTISEMENT
Feb 14, 2009
VS 2008 SP1. I cannot get my application to display in English, it always displays in French. I have an application that uses 2 languages. The default language is en-GB and the second language is French. For setting the text of the buttons and labels. I have set the localized property to true and changing the language to fr-FR on the form. So setting the default languages controls by choosing the default the language property, and then switching to French language to set the French controls. So I have the following files:
formMain.resx
formMain.fr-FR.resx
formMain.Designer.vb
formMain.vb
And for message boxes and other strings I have added these 2 resource files
formMain.Strings.resx
formMain.Strings.fr-FR.resx
So if I want to switch to different languages I have changed the cultureInfo as follows:
If My.Settings.Default.Language = "fr-FR" Then
Thread.CurrentThread.CurrentUICulture = New CultureInfo("fr-FR")
Else
Thread.CurrentThread.CurrentUICulture = New CultureInfo("en-GB")
End If
And for string I use the following: MessageBox.Show(formMain_Strings.SameStringName)
I also an address book form that is a child of the formMain. Which I have used the same method. However, the address book works as normal, but the formMain never changes to the language I want. Even though tested by explictly setting the language to en-GB in the form constuctor before the inializeComponent() it will always default to French. Not sure why the address book (child) work correctly, the parent form (formMain) will always display in French, no matter if I have set this to en-GB. I am 100% that my method is correct using what I have show you above. I was thinkng about deleting the formMain and creating a new one. But that would mean doing everything again and would take too long.
View 2 Replies
Feb 23, 2009
If i want to create a vb.net windows application in multi-language (EnglishArabic). Is there any steps i need to do?I installed the Arabic at my windows XP and I am able to write the labels and the the textbox for example in arabic but is there a way for the controls to shifts automatically?
View 7 Replies
Apr 6, 2010
Is there any tool specific to build a multi language application? And in general what is the procedure to be followed when you want to create a multi language application??
View 7 Replies
Jun 3, 2009
I M DEVELOPING AN ASP.NET APPLICATION I WANT TO PROVIDE INTERFACE IN ARABIC AND ENGLISH
View 2 Replies
Apr 13, 2009
i 'm develloping an application that uses a sql server database, in my computer where i'm programming i installed the sql server in the same language of the OS, in the tests of the application everything worked fine. Biut after migrating the db to the main server, the values went crazy.. After some research and tests, i saw that the language of the sql server was in english and that was the problem.
My language settings says that the decimal separator is "," and the agrupment digit it's ".", and the sql server works in the other way "." is the decimal separator and the "," it's the agrupment digit. In my code i was using the CDEC to pass the values to the DB, to solve this i removed the cdec and send the parameter as a string (So if i send 2,33 to DB with CDEC i get 233 if i send the 2,33 string i get 2.33). This works for now, but i don't know if in the future i'll have problems...
View 1 Replies
Nov 6, 2010
how to make a multi language desktop application in vb.net 2005. only a small desktop application in which i can change language according to countries.
View 1 Replies
Oct 19, 2009
I am developing heavy mathematical engineering windows application in VB.NET (VS2005) with MSAccess Db. This application has resource files in English, Spanish and German Language. I have same setup to run in all these 3environment Windows XPs. In English, calculations are perfect; but in Spanish ',' is treated as '.' and '.' is treated as ',' e.g. 12.24 in EN is '12,24' in Spanish. I somehow managed to do it by manually replacing ',' by '.' and vice versa; but this is now not manageable since program is expading like anything. I saved number in DB while installing. User selects his language and so I check, if its Spanish, I explicitly replace "." in labels and text in TextBox to ",".
View 2 Replies
Nov 23, 2009
Currently I am doing a CMS and I want to
View 2 Replies
Aug 27, 2009
I have a question about creating a multi-language application and the use of resource files. I will explain what I have done and what I would like the final product to be like.I am doing this in VB.Net and using Visual Studio 2008 After creating a new project, I added a resource file to the project (Add -> New Item, Selected Resource File, named it Resource1.resx).
I then double clicked the resource file and was able to add some names and values. For example,
Name - lblFirstName, value - John
Name - lblLastName, value - Smith
On my form, I have 2 labels: FirstName, and LastName
In Code, I added
FirstName.Text = My.Resources.Resource1.lblFirstName
LastName.Text = My.Resources.Resource1.lblLastName
If I run this code, it works fine. John and Smith are displayed on the labels. Now for my question. Say instead of first and last name the labels (buttons, menu items, etc.) were actually words that would be different in different languages. What I would like is to have something like
EnglishText.resx
SpanishText.resx
GermanText.resx
Each resource file would contain the same names, just different values. Depending on what language was selected, decided by the user (from a menu), how can I get the matching resource file to be used.
Basically what I want would be FirstName.Text = My.Resources.<Language Specific Resource File>.lblFirstName
Is something like this possible? Is this an acceptable approach? Is there a better way of doing this? I try to check often to see if there are follow up questions or if more information needs to be provided.
View 1 Replies
Dec 4, 2011
I am a Network Administrator in the Army so programming is not my strong area. I have been messing with Batch files and WMI, just recently i started VB Scripts (VERY BASIC) like adding an input box to set computer name, scan network for computer name on domain, return wmi info for that remote computer etc... I know there are programs out there that can do all of this, however the Army will only allow certain approved programs to be installed on government workstations, i have been using .Bat files to gather info which is fine, however it is very time consuming when you have entire subnets with computers, networked printers, etc to place into a spreadhseet for higher headquarters tracking not to mention the over 20 columns of required data to track for each computer. I have VB 2010 Express, working on a Windows Form Application Project. Goal is to interface my VB Script (written with notepad) with a GUI that will generate an internal spreadsheet on the form window in a datagridview. So far i have the basic window and i have my gridview with my column headers set. How do i get the data into the columns and rows accordingly.
Application Basic: Execute Program, in main window select button (Scan IP Range) <--- I want this to open an input box for the beginning subnet, input base address to start scan from, next input box for end range, then msgbox for start scan. i want the results of the scan to autofill the datagridview and add new row for each IP address that had a ping reply, returning valid data from WMI results as it receives the data. What would be the best method to achieve my goal. i am not asking you to write the program, i have been looking and studying MULTIPLE sites, think i just need another set of eyes on this to unlock the knowledge i have locked away, if ya know what i mean. Also, if you don't mind let me know what you think of this app im trying to turn out... Super Thanks for your help.This is the Base Batch File running. It calls an external VB Script written in notepad. (I want this implemented into the app form so there is no console window.)This is the inputbox from external VB Script that is called.This the result of the external VB Script (the info i want to put in the datagridview of the app.)I also, for some reason can't get scroll bars to show in the app when i hit F5, theres about 15 columns passed the MAC column...?
View 1 Replies
Jan 28, 2011
i just want some opinnion or suggestions regarding database softwares. we are going to develop a system for 20 or less users, i am planning to use MYSQL community server as our database to lessen the budget for that system, i just want to know if it is ok to use that version.is there a big differece between mysql community server, enterprise server and MS SQL Server in terms of handling data i.e security, speed, etc...
View 2 Replies
Jun 2, 2011
I want to learn the Database application programming. Especially, the multi-user environment. User can update the data at the same database. So, could you give me some advices ? Does it should use SQL server db ? How to connect with the the SQL server from other PC user ?
[Code]...
View 1 Replies
Dec 7, 2009
how to make an application with a multiple user.
language: VB
resource: Visual Studio 2008 Pro(90-day trial)
Sql express (the packages when u download the VS 2008)
scenario: i will make database located in a server (LAN) and a multiple client that can access the server database to add,modify,delete records.Im not aware that building a multi-user application database is different from a normal one user application database. T_T.i read some guide and other walkthrough on building a database but it became confusing when it doesnt my requirements. coz when i try to open my database(.mdf) to connect from other client (in another station) it says its currently in use and connot connect to it. err. @_@..
View 3 Replies
Apr 28, 2009
hen you add for example German language you will have these files: formMain.resx ormMain.de-DE.resx formMain.Designer.vb formMain.vbIn first file you will have resources for neutral language, like strings, images, ..So now you need to add also resources for strings used in code. Add a new resource file and name it formMain.Strings.resx Then i will enter name, value pair for every string that should be translated. When you add resource file then it is automatically typed because another file with name ormMain.Strings.Designer.cs is automatically regenerated on every close of resx designer.Add another resource with name formMain.Strings.de-DE.resx. Add the same Name key's from previous resource, and just change the Value with coresponding german words. Now to access created resource from the source it will be like this
View 2 Replies
Jun 10, 2009
I've been trying to connect a MS database to a V.B. form unsucessfully.Actually when i try to do that, i can't connect the tables information to the form or store the information i enter in the form in the MS table.I was doing an exercise here, and to store the information in the table called readers, i typed:
View 1 Replies
Dec 1, 2011
I am working on a C# project, which needs a VB.NET Class library.I have added the DLL reference of VB.NET Project into C# project.This works fine, but sometimes I need to debug the VB.NET project or pause the project and check the variable values of my VB.NET Project.Is it possible in Visual Studio 2010 Express Edition?
View 2 Replies
Mar 9, 2009
I use resource files in my web page.
my language in website is English and Farsi(Persian)
BUT I DO'NT KNOW .....
how to change text align or text direction in webpage with ASP.net and VB.Net 2005 ?
View 2 Replies
Jun 10, 2012
I really need assistance for this multiple problem am facing here. Let me take you to my hell: I've got three tables in my database that are:
1) tbAthlete (athleteID, nationID, gameID, fname, lname)
2)tbNation (nationID, nation)
3)tbGame (gameID,game)
I connected the database to vb and created a (form1) based on a query that use all fields except IDs. that form1 is just good as displaying and navigating throug records. Now i wanted to link that form1 to another form(2) which will allow me to update and add new record. in the form2, country and game need to be combobox as there is no need to enter new record for them. so when adding new record, only "tbAthlete" table get affected. form1 works as excpected. how do i go for the form2
View 6 Replies
Jun 23, 2010
Using Visual Basic 2005 So this is the problem I have run into. I need to populate a Datagrid with Data from 4 different tables of which I have gotten down to 3 DataTables in one DataSet.
The first one is called Letters and includes: LastPrintedOn & requiredpaper The second is called ImportParams and includes: ImportParamsID, BlockLetterGroup1, BlockLetterGroup2 and BlockLetterGroup3
The Last is called ClientInfo and includes: ClientGroupID, CapturedOn, ProcesingCommittedOn, ProcessingStartedOn, ProcessingCompletedOn, ImportParamsID
Now I can attack this from one of two ways (at least that is how I see it)
Select the ClientGroupID's I need (1,2,3,6) from that I will have the ImportParamsID which will then get me to the second table which has the blocked letters 1, 2 or 3 of them of which I can then check against the last table to get the date. There is one clients as of now that will end up with 3 thus being 3 seperate lines on the DGV or Table to show the different letter types.
Method 2:Bascially the reverse, look at the letter types and work backwards though I think the first method is easier. Where should I start? I'm not looking for code but the path I need to be on to get to the end.
View 5 Replies
Jul 25, 2012
I am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
View 4 Replies
May 10, 2012
We are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
View 3 Replies
Mar 26, 2009
I'm using SQL 2008 Express with a multi user VB.NET Windows application. Do I have to add each user to the SQL user account? Does NT AuthoritySYSTEM work? I do not know how this works. So far I have NT AuthoritySYSTEM in the Security-Logins of the Server. But do I have to add it also in the database? In the databse Security-User, I have the following:
[Code]...
View 1 Replies
Sep 23, 2010
I have a problem using my database in which I have a table with product names, codes, prices and information. I use the below method to get connected to my database and tables.
Dim dtCOP As New AmetailorDataSet.COPDataTableDim adapterCOP As New AmetailorDataSetTableAdapters.COPTableAdapter
adapterCOP.Fill(dtCOP)
[code]......
View 1 Replies
Mar 27, 2009
There is a "how do I video" on how to properly control updates, inserts and deletes in multi-user applications on forms that edit master-detail related data. [URL] Massi worked through the process using Order (OrderID is PK) as the master table and Order Detail (OrderDetaiID is PK) as a related table in dataGridView. The dataGridView automatically generate orderDetailID whenever the mouse enters in a new row. I am doing a similar form, but placing order form and orderDetail form in two separate tabs in a tabcontrol, and also using Details view for both tables. When I click "new" button in BindingNavigator, the orderID is automatically generated. If I use dataGridView for my orderDetail tab, then the orderDetailID is automatically generated when the mouse enters. This allow me to insert/update tables correctly. However I need the Details View for my orderDetail form too. How do I get a orderDetailID automatically generated when user insert a new order and have the mouse click on OrderDtail tab?
View 1 Replies
Aug 3, 2010
I have a problem using my database in which I have a table with product names, codes, prices and information. I use the below method to get connected to my database and tables.
Dim dtCOP As New AmetailorDataSet.COPDataTable
Dim adapterCOP As New AmetailorDataSetTableAdapters.COPTableAdapter
adapterCOP.Fill(dtCOP)
But in one row, I have product descriptions so there should be sentences. I set the type of this row is Text in the database. When I use single numbers in the table, there is no problem. But if I write sentences (that is a must because it is product description) or even a single word, I get the below error on adapterCOP.Fill(dtCOP):
"Input string was not in a correct format.Couldn't store <(the written text in description)> in Description Column. Expected type is Decimal."
There is a richtextbox in my form that should show the product description when the product code is selected from a listbox available in my form.
View 8 Replies
Mar 17, 2009
I'm working on a multi user VB.Net windows application with back end as SQL Server 2008 Express. The SQL Server is installed on the intranet network drive. This is the connection string I will be using. Is this correct?
Data Source=.SQLEXPRESS;AttachDbFilename=Q:DatabasePrintDB.mdf;Integrate d Security=True;Connect Timeout=30;User Instance=True
View 3 Replies
Nov 22, 2009
So Im working on updating our company's program from Visual FoxPro to VB and this is the first step. I can access and read data from the table
Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
View 1 Replies
Jul 1, 2009
I seem to have a major problem. when I add a typed dataset to my project and go back to my sql server and click on the databse I use it doesn't open. the tables and stuff just vanish. using the wizard, it creates this connectionstring:
<add name="Schenectady.My.MySettings.SISQL2ConnectionString"
connectionString="Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataSISQL3.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
It connects fine. but after I try opening it in sql server i get an error. It doesnt let me restore or anything. i tried restarting my pc incase the db was locked but it is still gone. now my app cant connect. Just for clarity, is user instance supposed to be set to true. and what is the purpose of it. also when the wizard asks to make a copy of the file that will be copied accross each time I run my project I select No.
View 5 Replies
Jun 27, 2011
I need some expert help in achieving this task. I have an xml file which will be emailed to me everyday. I need to loop through the xml and create tables in a database based on the xml nodes and their attributes. looking at the following xml fragment for example: Code:
So based on the above xml, I would have to create a Shipment table as a Parent with fields like ShipmentIdentifier. Then I would have to create an Event table with the ShipmentID as a foreign key and fields like Source, Code. Basically a field for each node. Then if there are columns in the table that are new, I would have to modify the table and add the column. I only have to create tables where there are child nodes or where the nodes have attributes.
View 1 Replies
