Display Chinese Characters in Gmail

As some of my clients from china, they want to save Chinese characters in database and retrieve it in web page. It is a piece of cake to save and display those characters in web page.


To save Chinese character in database:


Insert into Table1 ( Field1, Field2) values ( Test1 , N'藏青')


But there is a function to send system generated email to customers. Here is the problem !!! I am very strange that the Chinese characters cannot display both of my gmail and outlook . There is ?????-???? instead of displaying Chinese characters. So I research online and I found some code from codeproject website that can able to see Chinese characters in Gmail. See the following code:


public string getCorrectCharacter(string str)
{
       Encoding iso = Encoding.GetEncoding("iso8859-1");
       Encoding unicode = Encoding.UTF8;
       byte[] unicodeBytes = unicode.GetBytes(str);
       return iso.GetString(unicodeBytes);
}

Although Gmail can display chinese character correctly, Outlook Email still cannot display. I will continue to find to display correctly in every email.

If you guys have the code, please share to me. Thanks in advance

Freeze Columns and Header Row

Last week, I got headache for freezing the first column and the header row in gridview. So I researched to fix the columns and row simultaneously by setting the <div> width, height and scroll as auto. And I write some in stylesheet and I did add some code in code behind. Finally, my griview got fixed columns and fixed rows. Below is the steps to do:

Step1 :  StyleSheet1.css
/* Div container to wrap the datagrid */
div#gridviewstyle {
width: 850px;
height: 400px;
overflow: scroll;
border: solid 1px black;
}

/* Locks the left column */.testlock{color:#5E9709;
background-color:#D6F4DC;
border-right: 1px solid silver;
text-align:center;
position:relative;
width:20%;
cursor: default;
 left: expression(document.getElementById("gridviewstyle ").scrollLeft-2);
}

 /* Locks table header */
.testlockvertical
{
background-color:#D6F4DC;
text-align:center;
border-right: 1px solid silver;
position:relative;
cursor: default;
top: expression(document.getElementById("gridviewstyle ").scrollTop-2);
z-index: 99px;
}


Step2 : Default.aspx
We declare StylSheet1.css to our web page. So we can use the styles in that stylesheet.
<link href="../../StyleSheet1.css" rel=stylesheet type="text/css" />

<div id="gridviewstyle">
<asp:GridView id="GridView1" runat="server" CssClass="Grid" UseAccessibleHeader="True" AutoGenerateColumns=True OnRowDataBound="GridView1_RowDataBound1">
</asp:GridView>
</div>


Step3 : Default.aspx.cs
/* For Autogenerated first columns freezing*/
protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e){
e.Row.Cells[0].CssClass = "testlock";
e.Row.Cells[0].Width = Unit.Pixel(200);
}

Step4 : Default.aspx.cs
/* I put the binding gridview as seperate function.*/
/* For Autogenerated Header rows freezing.*/
private void binddata(DataView dv)
{
      GridView1.DataSource=dv;
      GridView1.DataBind();
      GridView1.HeaderRow.CssClass = "testlockvertical"
      GridView1.HeaderRow.Cells[0].CssClass = "testlock";
}

That's all. After that, you can see your gridview first column and header row are freezing.

HAPPY CODING!!!!!!!!!