I'm working in an ASP.net web application. I'm trying to export a crystal report file (.rpt file) to pdf viewerthe following code:
rystalDecisions.CrystalReports.Engine.ReportDocument doc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
doc.Load("C:\Users\amino\Documents\Visual Studio 2005\WebSites\WebSite1\Report.rpt");
CrystalReportViewer1.ReportSource = doc;
[code]...
i want to display dynamic text like the News in Arabic and english Language should I create two fields in the database For arabic and english?and how to select the english News when the user select English? (Note:i know to display the static text like the menus in arabic and english)
View 2 RepliesI have a Default.aspx program that contains a Treeview with a SiteMapDataSource. I also have a web.sitemap loaded up with urls. When I run the deafult app I get the tree layout that matches the numbers of options but no text on any of the options to click.
View 1 Replieshow to translate the numeric to arabic numbers in label.. anyone?
here's my code:
passportlabela.Text = "" + drReaderb["DOC_NUMBER"].ToString() + "";
i want to translate the doc_number = 12345 in arabic numbers
I have developed a website in English, i want this application to be in arabic also. Say suppose there are 50 members 30 knew english and 20 knew arabic , when i open my application it should open to them in specific language.
my application will have many entry fields(name,address..) and buttons to save , search. The arabic text entered in textbox should be viewable by both english and arabic known guys in their respective language. (ie) the arabic text should be readable in english for english known person and in arabic for arabic known person and viceversa., so that 50 member details should be viewable to 50 persons in their language.
I am sending arabic text in querystring to SMS gateway website by using the follwoing code:
protected void Button1_Click(object sender, EventArgs e)
string cellno,username,password ;
cellno = "966505326609";
username = "Aazar Jameel";
password = "12345678";
string val01,val02,val03,val04;
[code]...
Am developing a SMS Application, from there I have to send Arabic text by SMS, problem is that SMS Gateway does not accept Arabic text directly, Gateway accept Arabic text in Unicode/UCS2 format. So I need code to convert Arabic text in Unicode Format.
View 5 Repliesi am getting arabic words like as follows in my system (server 2003) "ÎÕÈ ÈÎÇ" .
same words getting correctly in another machine.
artro.ttf and artrbdo.ttf files i nstalled in font folder.
My application is in arabic. When i run my application locally it is working fine but after uploading it on the server, the arabic content is not showing. All my labels and HTML content are not showing in arabic. I am using Master Page.
View 2 Repliesi am using COM Component in my asp.net project. My problem is that i am not able to assign the Arabic string to the property of that component. Whe i debug it shows that input textbox has arabic text and when i assign that text to the property of my COM Component then it shows that in the property is save. where i have to change my .net code. is there any settings related to globalization etc.
View 1 RepliesI have a gridview with date column, and my datastring format is: [Code]....
I need to display this in arabic encoding for my arabic pages.
how to type the user in textbox in arabic text without changing the language in their pc?! using c# .net
View 3 RepliesI am developing a site in Persian (it a right to left language), and it's supposed to be used both with IE7 and IE8. I don't have any problems with IE7 but in IE8 all my numbers show in English instead of Persian; ie instead of showing ١٢٣ , IE8 shows 123. I tested Culture and UICulture but they didn't solve the problem.
By a great chance, I found that if I Omit "DocType" tag from top of my pages this problem resolves, but some other problems appear like my Ajax popup dialog box won't work as it used to in both IE7 and IE8; I've also seen warnings that say CSS Styles may not work properly without "DocType" tag.
What's wrong with <!DocType>? And How can I solve my problem?
i have a problem,when i export grideview to pdf,not show coulmname with formate farsi why?
View 1 Repliesthough paramerter in crystal report with stored procedure
View 1 RepliesIam exporting dataset to excel , the numbers on the sheet shown as text when export it to excel. Here is the code:
public class Excel
{
const int rowLimit = 65000;
private static string getWorkbookTemplate()
{
StringBuilder sb = new StringBuilder(818);
sb.AppendFormat(@"<?xml version=""1.0""?>{0}", Environment.NewLine);
sb.AppendFormat(@"<?mso-application progid=""Excel.Sheet""?>{0}", Environment.NewLine);
sb.AppendFormat(@"<Workbook xmlns=""urn:schemas-microsoft-com:office:spreadsheet""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:o=""urn:schemas-microsoft-com:office:office""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:x=""urn:schemas-microsoft-com:office:excel""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:ss=""urn:schemas-microsoft-com:office:spreadsheet""{0}", Environment.NewLine);
sb.AppendFormat(@" xmlns:html=""[URL]
sb.AppendFormat(@" <Styles>{0}", Environment.NewLine);
sb.AppendFormat(@" <Style ss:ID=""Default"" ss:Name=""Normal"">{0}", Environment.NewLine);
sb.AppendFormat(@" <Alignment ss:Vertical=""Bottom""/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Borders/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Font ss:FontName=""Verdana"" x:Family=""Swiss"" ss:Size=""12"" ss:Color=""#0000A0""/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Interior/>{0}", Environment.NewLine);
sb.AppendFormat(@" <NumberFormat/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Protection/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" <Style ss:ID=""s62"">{0}", Environment.NewLine);
sb.AppendFormat(@" <Font ss:FontName=""Calibri"" x:Family=""Swiss"" ss:Size=""11"" ss:Color=""#000000""{0}", Environment.NewLine);
sb.AppendFormat(@" ss:Bold=""1""/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" <Style ss:ID=""s63"">{0}", Environment.NewLine);
sb.AppendFormat(@" <NumberFormat ss:Format=""Short Date""/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" </Styles>{0}", Environment.NewLine);
sb.Append(@"{0}
</Workbook>");
return sb.ToString();
}
private static string replaceXmlChar(string input)
{
input = input.Replace("&", "&");
input = input.Replace("<", "<");
input = input.Replace(">", ">");
input = input.Replace(""", """);
input = input.Replace("'", "'");
return input;
}
private static string getCell(Type type, object cellData)
{
Object data = (cellData is DBNull) ? "" : cellData;
if (type.Name.Contains("Int") || type.Name.Contains("Double") || type.Name.Contains("Decimal")) return string.Format("<Cell><Data ss:Type="Number">{0}</Data></Cell>", data);
if (type.Name.Contains("Date") && data.ToString() != string.Empty)
{
return string.Format("<Cell ss:StyleID="s63"><Data ss:Type="DateTime">{0}</Data></Cell>", Convert.ToDateTime(data).ToString("yyyy-MM-dd"));
}
return string.Format("<Cell><Data ss:Type="String">{0}</Data></Cell>", replaceXmlChar(data.ToString()));
}
private static string getWorksheets(DataSet source)
{
StringWriter sw = new StringWriter();
if (source == null || source.Tables.Count == 0)
{
sw.Write("<Worksheet ss:Name="Sheet1">
<Table>
<Row><Cell><Data ss:Type="String"></Data></Cell></Row>
</Table>
</Worksheet>");
return sw.ToString();
}
foreach (DataTable dt in source.Tables)
{
if (dt.Rows.Count == 0)
sw.Write("<Worksheet ss:Name="" + replaceXmlChar(dt.TableName) + "">
<Table>
<Row><Cell ss:StyleID="s62"><Data ss:Type="String"></Data></Cell></Row>
</Table>
</Worksheet>");
else
{
//write each row data
int sheetCount = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((i % rowLimit) == 0)
{
//add close tags for previous sheet of the same data table
if ((i / rowLimit) > sheetCount)
{
sw.Write("
</Table>
</Worksheet>");
sheetCount = (i / rowLimit);
}
sw.Write("
<Worksheet ss:Name="" + replaceXmlChar(dt.TableName) +
(((i / rowLimit) == 0) ? "" : Convert.ToString(i / rowLimit)) + "">
<Table>");
//write column name row
sw.Write("
<Row>");
foreach (DataColumn dc in dt.Columns)
sw.Write(string.Format("<Cell ss:StyleID="s62"><Data ss:Type="String">{0}</Data></Cell>", replaceXmlChar(dc.ColumnName)));
sw.Write("</Row>");
}
sw.Write("
<Row>");
foreach (DataColumn dc in dt.Columns)
sw.Write(getCell(dc.DataType, dt.Rows[i][dc.ColumnName]));
sw.Write("</Row>");
}
sw.Write("
</Table>
</Worksheet>");
}
}
return sw.ToString();
}
public static string GetExcelXml(DataTable dtInput, string filename)
{
string excelTemplate = getWorkbookTemplate();
DataSet ds = new DataSet();
ds.Tables.Add(dtInput.Copy());
string worksheets = getWorksheets(ds);
string excelXml = string.Format(excelTemplate, worksheets);
return excelXml;
}
public static string GetExcelXml(DataSet dsInput, string filename)
{
string excelTemplate = getWorkbookTemplate();
string worksheets = getWorksheets(dsInput);
string excelXml = string.Format(excelTemplate, worksheets);
return excelXml;
}
public static void ToExcel(DataSet dsInput, string filename, HttpResponse response)
{
string excelXml = GetExcelXml(dsInput, filename);
response.Clear();
response.AppendHeader("Content-Type", "application/vnd.ms-excel");
response.AppendHeader("Content-disposition", "attachment; filename=" + filename);
response.Write(excelXml);
response.Flush();
response.End();
}
public static void ToExcel(DataTable dtInput, string filename, HttpResponse response)
{
DataSet ds = new DataSet();
ds.Tables.Add(dtInput.Copy());
ToExcel(ds, filename, response);
}
}
Is it possible to disable export options on a server report in the ReportViewer control without changing the reportserver.config file?
I have the code to change a Local Report but not a Server Report. We have a group of reports we only want to be able to export to PDF and TIFF while the other server reports should be exportable in all formats.
I have data display in a gridview base on a dropdownlist. Basically, base on the downlist selection my gridview will be populated with the corresponding data. I have addresses and emails in the list. Where I am stuck and not sure how to do is export the emails to outlook for a mailmerge. For example, when the user clicks on button to send the emails in Outlook. The emails should be the ones that are display in the gridview. For the MS Word is to export the address to populate the the labels so the user can print out labels. Another button to send the address for the labels
View 7 RepliesAs i am using asp validation and they are working fine,my next issue is how to make appear the requiredfield validator into arabic as well,because i am developing multilanguage webisite n now how can i make the error message to be appeared in arabic when
the arabic button is selected
< asp:RequiredFieldValidator
ID="RequiredFieldValidator1"
runat="server" [code]...
I was using this UR [URL] for exporting the data to excel. Can I do the following two things while exporting:
1) I want to remove the autofilter options, which are displaying now when you open the excel workbook soon after exporting finishes.
2) Some of the columns which are numerics, are formatted to text by default, and it is displaying a small green rectangular icon at the left top corner of each cell which is very disturbing while viewing the sheet.
Is it possible to fix both the above options.
I want to display English and Arabic Contents on the same page using App_LocalResources in ASP.Net, C# and SQL Server. For English its Menu should be left side, text alignment should be left and page contents direction should be left to right. For Arabic its Menu should be right side, text alignment should be right and page contents direction should be right to left. How I will develop it ...
View 1 RepliesHow do i display arabic data in correct format?
The following information(fig -1) is displayed correctly in crystal reports viewer but when i export the report in to word or pdf, using the export feature in cr viewer, iam getting a differnt output (fig -2).
on my page i have a time range printed in the format of 12:00 AM - 12:00 PM i have to display this appropriately for whatever culture the browser supplies. i'm having an issue with arabic (ar-ae): the am/pm indicator seems to change the text ordering for part of the string. the string has the right characters in the right places in memory, but shows them in a different order.
so for my start and end times, i have strings like 03:00 ص and 11:00 مand then i put them together like
string dummytext = t1string + " - " + t2string; when the page is written, the range is displayed as 03:00 ص - 11:00 م i've tried putting each piece in a Label control and wrapping everything in a div with dir="ltr" and haven't made any progress. this is happening in a table cell if it makes any difference.
I was read your post: "Export GridView to Excel in ASP.Net with Formatting using C#" and is very useful. That code works perfect. But I need create a new format for a specific column in my sheet before to export it. For example:My DataTable have a column with decimal numbers and I'm trying reduce the tenths for each number.I want this: 2,874444 ----> 2,87 for a specific range. In this case I need it for all numbers in the column 13 or well said for the Column called N in Excel. Only reduce two tenths.
I used:
xlWorkSheet.Range["N"+h,"N"+h].NumberFormat = "0.00";
And no works (h is for rows, N is the column. Into a foreach).
I have the following issue where I cannot seem to display a negative number and the result seems to stay on zero.
The code is as follows:
[code]...
In my code iNumber1 = 108 and iNumber2=27 however when the result is divided again by 108 the answer seems to stay on 108. I tried using doubles but with no luck.