store tamil string value in the textbox to sql server databse - windows application

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hi need help................

We have an windows application developed in asp.net,C# and SQL server 2005.

We use our regional font (Tamil) to display in the application. The table in the database is set to nvarchar, so that it cud accept unicode character.

We have a textbox in the win form where its font set to tamil, when we type we cud see tamil letters in the textbox but if we we say textbox1.text and save to database it saves as english.

So my actual requirement is to get the textbox value (i.e tamil string) and store that tamil string to database (in db also it should stored as tamil). :( :(

please let me know if you are not clear on my question.....

Posted 16-Jun-11 0:56am

senthilraj1983

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-06-16T01:28:00

Solution 1

Don't do it that way - it will confuse things, and leave you open to an SQL injection attack.

Instead, use a parametrized query - it isolates the Tamil from the SQL command and means it should just work:
Instead of:

SqlCommand cmd = new SqlCommand("INSERT INTO table VALUES ('" + textboxName.Text + "')", con);

Use

SqlCommand cmd = new SqlCommand("INSERT INTO table VALUES (@NAME)", con);
cmd.Parameters.AddWithVAlue("@NAME", textboxName.Text);

Posted 16-Jun-11 1:28am

OriginalGriff

Comments

senthilraj1983 17-Jun-11 7:39am

thats okay.. but if we say textboxname.text at run time we see english letters instead of tamil letters.... for eg... if i type "தமிழ்" in the textbox and when i say textboxname.text the string is "thamiz".. so i cant save as "தமிழ்" to the database.

Dhruval Dave 31-Mar-14 9:57am

I am also facing the same thing. Does anyone have any possible solution ?