I use this C# codes to save unicode text into NVARCHAR field (SQL SERVER 2005 EXPRESS):

DataRow row;
row = cData.DatTable.Rows[i];

row.BeginEdit();

row["CompanyName"] = txtCompanyName.Text;
//...

row.EndEdit();

cData.DatAdaptor.Update(cData.DatSet, TableSelect);
cData.DatSet.AcceptChanges();

When I input some unicode text into txtCompanyName,
it is save SQL SERVER like that: "B?n ph?i nang d?ng"

How can I solve this problem?
Thanks for reading!

: I use this C# codes to save unicode text into NVARCHAR field (SQL
: SERVER 2005 EXPRESS):
:
: DataRow row;
: row = cData.DatTable.Rows[i];
:
: row.BeginEdit();
:
: row["CompanyName"] = txtCompanyName.Text;
: //...
:
: row.EndEdit();
:
: cData.DatAdaptor.Update(cData.DatSet, TableSelect);
: cData.DatSet.AcceptChanges();
:
: When I input some unicode text into txtCompanyName,
: it is save SQL SERVER like that: "B?n ph?i nang d?ng"
:
: How can I solve this problem?
: Thanks for reading!


Did you specify the column data type in your code? And if so, what is it?



Brad Wang
.NET Freelancer from China