多语言存储过程 [英] stored procedure for multilingual

问题描述

我的问题是如何将c#.net页的印地文字母传递给我的存储过程?

我已经编写了这样的sql存储过程

my problem is how to pass the Hindi letters from c# .net pages to my stored procedures?

I''ve written a sql stored procedure like this

CREATE proc [testinsert]
(
@nameE nvarchar(max),
@nameT nvarchar(Max)
)
as
begin
   INSERT INTO tblmultilangstudentE ([name]) VALUES (@nameE);
   INSERT INTO tblmultilangstudentT ([name]) VALUES (@nameT);
end

我通过了像这样的值

i passed the values like this

SqlCommand cmd = new SqlCommand("testinsert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@nameE", txtEng.Text);
cmd.Parameters.AddWithValue("@nameT", txtTamil.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

但这不是将印地语值存储在tblmultilangstudentT表中.在数据库中
仅提交"??????".高级人才的关键问题.在此先感谢........

[edit]为清晰起见添加了代码块-OriginalGriff [/edit]

But it''s not store the Hindi values in tblmultilangstudentT Table.In database
only ''?????'' submited. A critical Problem for advance brainers. Thanks in Advance........

[edit]Code blocks added for clarity - OriginalGriff[/edit]

推荐答案

在添加参数时指定数据类型.

Specify the data type while adding parameters.

cmd.Parameters.Add("@CategoryName", SqlDbType.NVarChar)

如果要插入泰米尔字符，则必须设置SqlCommand对象的参数SqlDataTape.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx [ ^ ]

cmd.Parameters.Add("@ CategoryName"，SqlDbType.NVarChar)

Hi,
if you want to insert tamil characters, you must set SqlDataTape of parameters of SqlCommand object.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx[^]

cmd.Parameters.Add("@CategoryName", SqlDbType.NVarChar)

我尝试了相同的操作，但它类似于cmd.Parameters.Add("@ HindiText"，SqlDbType.NVarChar)但它仍未将印地文文本保存到数据库中.但是如果我执行
这样的插入查询 Query =插入到myTable(HindiTitle)值(N""+ txtTitle.Text +"'');

一切正常.

I tried same thing but it like cmd.Parameters.Add("@HindiText", SqlDbType.NVarChar) but it is still not saving Hindi Text into database. But if I execute Insert Query like
Query = "Insert into myTable (HindiTitle) values(N''" + txtTitle.Text + "'')";

it is working fine.

这篇关于多语言存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！