多语言存储过程

问题描述

我的问题是如何将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]

推荐答案

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

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