473,320 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to create Asp.Net Application with Multilingual storage with Multibackend

bsm
Hi,

I need to develop an Asp.net Application which should support any
backend (SQL/Oracle). Also it store Multilingual data.

I found the Query for SQL Server as follows:
---------------------------------------------------------------
INSERT INTO MusicAlbum (Album_ID, [Year], Name, Artist_ID, Company_ID)
VALUES (12345, 2005, N'Abida', 4653, 403)

For Oracle
-------------
INSERT INTO Employee (ENAME,EID) VALUES (UNISTR('" +
unicode_iso8859(TextBox1.Text) + "'),'"+ TextBox2.Text +"')"

I want to use "ENTERPRISE LIBRARY". So that I need to write a common
query which Insert into both SQL Server/Oracle (depends upon the
req).

PLZ HELP.

Apr 19 '07 #1
2 2006
You will have to write 100% ansi 92 compliant sql statements.

A better idea is something called the Factory Design Pattern.
public interface IEmployeeData
void InsertEmployee ( int empid , string lastname, string firstname )
Then have 2 "concrete" employee data objects.

public class EmployeeDataSqlServer : IEmployeeData
public class EmployeeDataOracle : IEmployeeData

See
http://www.15seconds.com/issue/020611.htm


"bsm" <se*************@saksoft.co.inwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...
Hi,

I need to develop an Asp.net Application which should support any
backend (SQL/Oracle). Also it store Multilingual data.

I found the Query for SQL Server as follows:
---------------------------------------------------------------
INSERT INTO MusicAlbum (Album_ID, [Year], Name, Artist_ID, Company_ID)
VALUES (12345, 2005, N'Abida', 4653, 403)

For Oracle
-------------
INSERT INTO Employee (ENAME,EID) VALUES (UNISTR('" +
unicode_iso8859(TextBox1.Text) + "'),'"+ TextBox2.Text +"')"

I want to use "ENTERPRISE LIBRARY". So that I need to write a common
query which Insert into both SQL Server/Oracle (depends upon the
req).

PLZ HELP.

Apr 19 '07 #2
bsm
Thanks for your immed help.

This is really going to be a new one for me. Let me go through it and
get back to you.

On Apr 19, 9:00 pm, "sloan" <s...@ipass.netwrote:
You will have to write 100% ansi 92 compliant sql statements.

A better idea is something called the Factory Design Pattern.

public interface IEmployeeData
void InsertEmployee ( int empid , string lastname, string firstname )

Then have 2 "concrete" employee data objects.

public class EmployeeDataSqlServer : IEmployeeData

public class EmployeeDataOracle : IEmployeeData

Seehttp://www.15seconds.com/issue/020611.htm

"bsm" <senthilmurug...@saksoft.co.inwrote in message

news:11**********************@y80g2000hsf.googlegr oups.com...
Hi,
I need to develop an Asp.net Application which should support any
backend (SQL/Oracle). Also it store Multilingual data.
I found the Query for SQL Server as follows:
---------------------------------------------------------------
INSERT INTO MusicAlbum (Album_ID, [Year], Name, Artist_ID, Company_ID)
VALUES (12345, 2005, N'Abida', 4653, 403)
For Oracle
-------------
INSERT INTO Employee (ENAME,EID) VALUES (UNISTR('" +
unicode_iso8859(TextBox1.Text) + "'),'"+ TextBox2.Text +"')"
I want to use "ENTERPRISE LIBRARY". So that I need to write a common
query which Insert into both SQL Server/Oracle (depends upon the
req).
PLZ HELP.- Hide quoted text -

- Show quoted text -

Apr 24 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: smjmitchell | last post by:
Hi, I am writing an application in VB6.0 that will have the option to select the language. For instance when Spanish is selected all the text on the program interface will display in Spanish. ...
9
by: Amadrias | last post by:
Hi, In one of my current projects, I am willing to create a secure zone such as Acronis does in its application to store some confidential information only accessible to the current machine...
23
by: Allan Ebdrup | last post by:
I hava an ajax web application where i hvae problems with UTF-8 encoding oc chineese chars. My Ajax webapplication runs in a HTML page that is UTF-8 Encoded. I copy and paste some chineese chars...
1
by: Brijesh Gupta | last post by:
Hi, Can anybody help me to make multilingual application in VB6? Thanks in advance. Brijesh Gupta
7
by: Luc The Perverse | last post by:
Hello! I am looking for a good way to make an application multilingual. Danish/English for now (but I don't want to preclude more than two languages eventually) Every dialog will have an option...
2
by: raju | last post by:
Hai all, I am working on the multilingual application, in asp.net. In that we are displaying contents in some other language (user selected language). In that page, we are having some textbox...
2
by: PrateekArora | last post by:
Hi Guys, I need to develop a MultiLingual Application (Arabic & English) in VB.NET, as far as Labels and captions are concerned in User Interface I am done with that using Resource Manager Class &...
2
by: Peter | last post by:
Firstly let me be very clear about this, I do not want to create a web service proxy nor do I want to do anything with web services. Basically, I have a shrink wrapped desktop application which...
1
by: Abhijit D. Babar | last post by:
I have to create a multilingual application in Visual c++ .net 2008. I have a Windows form application and i want to run this on multilingual support. So how can i do this. Which change i have...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.