将urdu语言存储在Visual Studio数据库中 [英] store urdu language in visual studio database

问题描述

private void button1_Click_1(object sender, EventArgs e)
 {
   try
    {
SqlConnection abc = new SqlConnection(Connection);
abc.Open();
SqlCommand cmd = new SqlCommand("insert into policrec values('" + polnam.Text + '",'" + loct.Text + '",'" + cort.Text + "')", abc);
cmd.ExecuteNonQuery();
        MessageBox.Show("Data succefully enter");
             Show();
            }
           catch (Exception ee)
           {
            MessageBox.Show(ee.GetBaseException().ToString());
           }

        }

我们使用了上面的代码在数据库中插入urdu值，但是它没有像这样正确显示语法.. ????????????????????????
我们还在数据库nvarchar中使用了数据类型，但是仍然有问题...
请给我正确的任何urdu函数urdu只是存储在unicode中...请给我

WE used the above code for insert urdu value in database but it not display correct syntax display like this..????????????????????????
we also used data type in database nvarchar but still have a problem...
plz give me correct any urdu function urdu is just store in unicode...plz help me

推荐答案

您可以使用以下命令更改数据库的collation:

You can change the collation for your database with the following :

ALTER DATABASE [database_name] COLLATE SQL_Latin1_General_CP1_CI_AS;

通过以下链接为您的文本格式选择有效的排序规则:
http://msdn.microsoft.com/en-us/library/ms144250.aspx [ ^ ]

Select a valid collation for your text format fro the following link:
http://msdn.microsoft.com/en-us/library/ms144250.aspx[^]

OOH MAN
只需将"N"定义为Unicode类system.string ....就像下面的代码

OOH MAN
just put "N" Define Unicode class system.string....like this below code

private void button1_Click_1(object sender, EventArgs e)
 {
   try
    {
SqlConnection abc = new SqlConnection(Connection);
abc.Open();
SqlCommand cmd = new SqlCommand("insert into policrec values(N'" + polnam.Text + "',N'" + loct.Text + "',N'" + cort.Text + "',N'" + datc.Text + "')", abc);
cmd.ExecuteNonQuery();
        MessageBox.Show("Data succefully enter");
             Show();
            }
           catch (Exception ee)
           {
            MessageBox.Show(ee.GetBaseException().ToString());
           }

        }

但请记住您的数据库字段数据类型为nvarchar

享受....

but remember your databse fields datatype nvarchar

Enjoy ....

这篇关于将urdu语言存储在Visual Studio数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！