why cyrillic text is getting corrupted in PDF report.
I have set Arial UNicode Ms font in report. The column from where the data is retrived is also nvarchar(max).
So why the cyrillic text is getting corrupted.
I want to change text of text object in crystal report (.rpt file). The datasource for the report is a datatable which consists of a column named sale, if it is '0' then I want to display the text of text object as 'sale' and if it is '1' then I want to display the text of text object as 'lease'. how to add formula and based upon the result of formula I have to change the text of text object being displayed.
View 1 RepliesSqlDataSource1.SelectCommand = "select * from [xw] where [CustName] Like '" + TextBox2.Text +
"%'"
How Can I make two textboxt1.text and texbox2.text ?
SqlDataSource.selectCommand = "Select* from [xw] Where [Country]= textbox1.text and [CustName] Like '"+Textbox2.text+"%"
I need to pull an Access Report, insert values into its fields and print it. The original website that should have this functionality is written in ASP.NET using VB. I'm willing to install what ever. (Report Manager?)
View 1 RepliesI am working with a set of data that looks something like the following.
[Code]....
The name and number of assignments, I need to get results simlilar to the following.
[Code]....
On our site, I use the category (in Russian) in the querystring. E.g.: [URL] (I notice the link is not clickable here, you need to copy the entire link to view the result) If you paste this link in IE8, it is translated to cat=???? and it does not work If I paste it in FireFox, it works. It gets even more weird: the same URL is reachable from the homepage, and if I click the same URL in IE8 from the homepage it works fine (unless I click open in a new tab, that it is back to ????). I am using ASP.NET 3.5(C#)
View 1 RepliesHow i can make the normal search string to sql server full text search parse, because when we are user enyer search text "how to run windows schedule in C#", in database we have article to to this, but data not returning and sometime is say error in key word and etc.
View 1 RepliesI'm having a problem with a web app I'm managing. Users starting receiving the following error occasionally:
Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.
The problem is that it's not a cluster - it's a single Windows 2003 server. After digging around, it appears that adding a machineKey section and some extra attributes to the Pages directive in my web.config resolves this error:
<machineKey validationKey='MACHINE KEY SNIPPED'
decryptionKey='DECRYPTION KEY SNIPPED'
validation='SHA1'/>
<pages validateRequest="true" enableEventValidation="false">
After changing these two things in my web.config, the error goes away, but now I have a new problem - Instead of an error that my viewstate is invalid, the app just "Forgets" who my user is, and sends them back to the login page. Now, the users are browsing through the application, and then they're unexpectedly sent to the login page, even after they've already been logged in for a few minutes. While I can't force this to happen, it usually happens within visiting 10-12 different pages, so pretty frequently.
I'd love a resolution to this - does anybody know what else might be causing the viewstate error on a single server, or what I can do to ensure that it's validated properly?
I have a field called IsAdmin in my user database which is a bit and i have used a checkbox for entering its value in my forms...but i get an error
Conversion failed when converting the varchar value 'System.Web.UI.WebControls.CheckBox' to data type bit. How do i sort out this error....and i want IsAdmin to be either 1 or 0 in my database
I have a situation where my session variables seem to get corrupted. I Page_Load I am calling 2 subs. Each of them fills a GridView with data from a table. I am saving the content of each Data.DataTable into Session Variables:
Get_Summary_Last_Completed_Shift()
code in sub:
mySqlDataAdapter.Fill(mySqlDataTable)
Session("mySqlDataTable1") = mySqlDataTable
GridView1.DataSource = mySqlDataTable
GridView1.DataBind()
Code:
Get_Petroleum_Disbursement()
code in sub:
mySqlDataAdapter.Fill(mySqlDataTable)
Session("mySqlDataTable5") = mySqlDataTable
GridView5.DataSource = mySqlDataTable
GridView5.DataBind()
After I call the 1st sub and I debug the session variable "mySqlDataTable1" contains all the data from the table. After I call the 2nd sub and I debug the session variable "mySqlDataTable1" has been changed and contains a mix of data from the 2 tables.
I have written the following code to download a file from sharepoint. The downloded file works fine in only some machines. For others, it says that the file is corrupted. The issue is for MS Office and image files, however the PDF is not having any issues. We have identified the issue of corruption as due to the addition of a hexadecimal number at the top of the file contents. When it is removed, the file gets opened correctly. The hexadecimal character has been traced out to be representing the file size in bytes. Why this is happening only in some machines and how can we fix it?
private void DownloadFile()
{
SPListItem item = GetFileFromSharepoint();
[code]...
I have followed tutorial at [URL] .....
The file does upload via ftp but it is corrupt when downloaded. I've tried uploading a jpg file.
I am developing web application using csharp. But I want one copy to apper with a writing in background as Copy? Forexample the report should pull details which a m doing. But want in the background of the report a text which is saying COPY COPY.
View 1 RepliesI have MS SQL Server 2008 and I would like to store formatted text from a rich textbox. Formatted in the sense that I want to store a multiple choice question's formatting, an example would be like this:What is 2 + 2?
4 6 2 8
Then when I retrieve it from the SQL database it saves its formatting.
I'm writing a sql query for my database, that goes:
comn.CommandText= "INSERT INTO tb1 VALUES(' " + textbox1.text.tostring() + " ',' " + textbox2.text.tostring() + " ' )";
Which works great until one of the characters in one of the textboxes is ' (apostrophe).
I have 2 tables A and B. Table A has a text field, fundIDs with comma delimited values like 23,44,55 etc. I would like to select all the records in table B whose ID matches the values in the fundIDs field from only one record in Table A. So, I need a function which first gets 1 table A record and uses the fundIDs field values to query and return all the matching records from Table B. I don't know how to parse and query in sql
[code]....
I have 3 Labels : Label1, Label2, Label3.
I want to add Text on this Labels from database.
I'd like to do it like that:
[Code]....
But it doesnt work (thats just pseudo-code;-)). It is possible to do it like that with value i ?
I have used this example when exporting data to PowerPoint:
I have modified the GenerateSlidesFromDB() method:
public void GenerateSlidesFromDB()
{
string slideName = @"C:UsersxDesktopoutput.pptx";
File.Copy(@"C:UsersxDesktopTest.pptx", slideName, true);[code]....
As you can see I overwrite the placeholder with "Test User", and it works like a charm.I need to add an image (as a placeholder) to this pptx-file. When I do that (and run the code again) I get a corrupted pptx-file?
Error message: PowerPoint removed unreadable content in output.pptx. You should review this presentation to determine whether any content was unexpectedly changed or removed.
Edit: If I try the original code (which is slightly modified since I dont have Adventureworks), I get some other kind of error message:
This file may have become corrupt or damaged for the following reasons: Third-party XML editors sometimes create files that are not compatible with Microsoft Office XML specifications.
The file has been purposely corrupted with the intent to harm your computer or your data. Be cautious when opening a file from an unknown source.
PowerPoint can attempt to recover data from the file, but some presentation data, such as shapes, text,and formatting, may be lost.
Do one of the following:If you want to recover data from the file, click Yes.If you do not want to recoverdata from the file, click No.
I am using :
FtpWebRequest request = (FtpWebRequest)WebRequest.Create("ftp://www.contoso.com/test.htm");
request.Method = WebRequestMethods.Ftp.UploadFile;
// This example assumes the FTP site uses anonymous logon.
request.Credentials = new NetworkCredential ("anonymous","janeDoe@contoso.com");
// Copy the contents of the file to the request stream.
StreamReader sourceStream = new StreamReader("testfile.txt");
byte [] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());
sourceStream.Close();
request.ContentLength = fileContents.Length;
Stream requestStream = request.GetRequestStream();
requestStream.Write(fileContents, 0, fileContents.Length);
requestStream.Close();
FtpWebResponse response = (FtpWebResponse)request.GetResponse();
For uploading images and songs to the server. But the file is getting corrupted on upload. Normal upload is getting error due to security reason and access issues.
Had to dwell on to ftp. But in this case, file is getting corrupted.
i 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.
i'm using crystal reports in asp.net3.5 with third party tool coolite....my rports are printing in .pdf format...i want to place the back ground logo(image) or text to my report . if i take the printout of the report the logo or text should be displayed on the page. But if i take the photocopy (xerox) of that printed page, the text or logo should not display or it should display in reverse manner...
(mirrored image)...
I have a column with a random length of text, basically it's an old crappy mfg system that stores data in a tilde delimited list. I need to output this column into each seperate column for a view. Column names don't matter, they can all be unnamed but so long as the data returns as seperate columns is what I'm after.
[Code]....
I am using sql to create a table from stored procedures and then streamwriter in vb.net to create a text file based on the sql table. Where and how do I control the right or left justification of the records in the text file?
View 1 Repliesi have made fulltext index in 4 columns in a table ( 2 ARABIC columns (title,Desc(html) AND ENGLISH(title,Desc(html))it works fine locally when i use contains function in search but in sever arabic search doesnt work well .
View 2 Replieshow to get sql query output in text file?
View 1 Replies