hi,

I need to convert christain date that was produced in my Sql database to persian date like" دوشنبه 21 مرداد 1378" in a datalist.Could you recommend me any function.I use VisualStudio 2005 & VB.

thanks in advance

Sepid

Take a read of http://www.codeproject.com/KB/database/PersianDateInSQLServer.aspx

or maybe a javascript route like http://www.codeproject.com/KB/gadgets/PersianDateViewerGadge.aspx

Hope it helps

 If you search Yahoo! or Google it you may easily find it.

But you may download PersianDate Web Control at PersianDate.ir, this is exactly what you are looking for.

 After installation is completed then try this source:

1    <asp:DataList ID="DataList1" runat="server" DataSourceID="YourSqlDataSource">
2            <ItemTemplate>
3            
4            <%-- Remember that whenever you are displaying a specific date change AutoUpdate to false --%>
5            <sim:PersianDate ID="PersianDate1" runat="server"
6             AutoUpdate="false"  DateValue='<%# Eval("Column_Name_of_Your_Date_Values") %>' />
7             
8            </ItemTemplate>
9    </asp:DataList>

Hi eddy,

Thanks for your reply ,

I couldn't register in the site you recommended to get  the component.And I don't want to have a  trail version.

Could you please help me.

Sepid