I have a flat file with text that has a special character like this: "RIBA® Generic Strip Labeling." so the registerd symbol is coming as square when i am simply reading the file in c#. is there a way to read the symbol as is and print on screen? i am working in on a console application. Also other german characters, not all but a few are showing as squares as well.
View 3 Repliesi have flat files in some direcotry. each flat file contains around 60,000 rows of data. earlier we were using excel sheets to upload data. but now the challenge is it is taking more time to upload data into DB tables. which is the best way to upload such a huge data into db tables. can we use SSIS for uploading data. if so, how can we achieve that.
View 1 RepliesIn web service reading *.txt file .this file contains some special characters like "" .so its shows error while reading .
string fullPath = Server.MapPath("sample.txt");
string reconciliationData = string.Empty;
StreamReader ObjReconciliationDataStream = new StreamReader(fullPath, Encoding.UTF8);
string strReconData = ObjReconciliationDataStream.ReadToEnd();
ObjReconciliationDataStream.Close();
ObjReconciliationDataStream = null;
return strReconData;
above code i am using .
I am reading a CSV file created by Excel. the string I am reading needs to be encoded (it shows small boxes instead of hebrew characters) so I wrote a lil routine to convert the string -
Function encodeName(ByVal name As String) As String
Dim src As Encoding = Encoding.UTF8
Dim dest As Encoding = Encoding.Default
Dim srcBytes() As Byte
srcBytes = src.GetBytes(name)
Dim asciiBytes() As Byte = Encoding.Convert(src, dest, srcBytes)
Dim mychars(dest.GetCharCount(asciiBytes) - 1) As Char
dest.GetChars(asciiBytes, 0, asciiBytes.Length, mychars, 0)
Dim asciiString As New String(mychars)
End Function
From what I read FileStream.ReadLine reads the text with encoding UTF8 so I try to convert from UTF8 to Encoding.Default buy instead of little boxes I get question marks.
iam Working on Asp.net Web apliation using c#.net. in system folder (Ex: E://Santhu) i have few Flat files and Excels Files .So My Application should read those files automatically and should store the data into my database..
View 1 RepliesI have a web application project with a App_GlobalReousrces folder which contains a *.resx file that I would like to access (read) from a separate class library project.
What's the best way to deal with this one?
I want to read a line character by character, in the sense I want to read each and every character on the line. can I can make that line as a string. breaking string into substrings ? if possiblw how.? I m unable to start. can anyone give the code.
View 7 RepliestxtPhoneWork.Text.Replace("-","");
txtPhoneWork.Text.Replace("_", "");
txtMobile.Text.Replace("-", "");
txtMobile.Text.Replace("_", "");
txtPhoneOther.Text.Replace("-", "");
txtPhoneOther.Text.Replace("_", "");
location.ContactWork = txtPhoneWork.Text.Trim();
location.ContactMobile = txtMobile.Text.Trim();
location.ContactOther = txtPhoneOther.Text.Trim();
but it is not replacing and is there any method so that both - and _ can be replaced in single function.
buildLetter.Append("</head>").AppendLine();
buildLetter.Append("").AppendLine();
buildLetter.Append("<style type="text/css">").AppendLine();
Assume the above contents resides in a file. I want to write a snippet that removes any line which has empty string "" and put escape character before the middle quotations. The final output would be:
buildLetter.Append("</head>").AppendLine();
buildLetter.Append("<style type="text/css">").AppendLine();
The outer " .... " is not considered special chars. The special chars may be single quotation or double quotation. I could run it via find and replace feature of Visual Studio. However, in my case i want it to be written in c# or VB.NET
i want textbox which can enter all special character. if any type of textbox is there then give me download link.
View 5 RepliesI have a gridview with checkbox column. I loop through all the rows of gridview, if it's checked I enter the second column text into my database. The second column text at one point shows the word Küche, but when I take that text (in order to insert it in db) it gives me Küche and that's what I see when I then read it from db.
View 4 RepliesI have recordsets in my MySQL database like this (in german): Karrieren im Porträt: Interview mit Thorsten Franck - „Ich liebe Produkte". Now when I get the data with the MySQL connector reader and write it into an xml file I get just this: Karrieren im Porträt: Interview mit Thorsten Franck Ich liebe Produkte As you (hopefully) can see, the minus (it's one of those long ones) and the upper and lower quote signs are not shown. The table is defined as UTF-8, the output of the xml file also.
View 1 RepliesWe are using microsoft report in our project, in that we are showing some special character like japanese character. In rdlc file we have applied Arial Unicode MS font for that label. We are rendering this file into the pdf format.
In development environment (Window vista OS) we are able to see that unicode character properly but when we deploy on windows 2003 server then that special character shown as '????' .
Previously Arial unicode MS font was not installed on windows 2003 server, we have manually installed it after that also we are not getting unicode character in report.
I receive data from a database that contain character such as '&', 'é', 'è', ... In the page, they corectly shown, but when I want them in a textbox, they appear like "&", é" ...
is there a way I can make them appear correctly?
I am doing user authentication from mail. So I am sending the email and encrypted pass to user. and user clicking on the link getting the value of query string
[URL] ....
this l=1+E4Hccj9hE=
the value of l is "1+E4Hccj9hE="
but when i am getting the value of the query string the value of l is getting "1 E4Hccj9hE="
string password = Request.QueryString["l"].ToString();
I have designed a page where user can write messages and send within a group but i want that if they enter any special character like <>?#@ etc a msg should be displayed irrespective of the crashing of the page.
View 3 RepliesI am using a ASP.Net Editor on the website I am developing. For some reason, it doesnt like special characters like german umlaut (ö, ä, ü) or "ß". It renders it allright during typing, but when I postback the page all I get back looks like this when I access the editor.content-property:
special characters:<br />
[....�lots of square brackets....] � � �<br />
using a different editor like freetextbox doesnt seems to have a problem with that. but I cant believe the microsoft-editor doesnt support that. its probably a setting in xml-configuration file or something like that.
When i try to pass this string "- !@#$%^&*()_+|}{:"?><<>?/.,';[]`" as a parameter to SQL Server Reporting it crashes. Here is code sample
ReportParameter[] ReportParams = new ReportParameter[1] { new ReportParameter("Name", HERE-COMES-SPECIALSTRING)
IS there any way to pass special character safely like in SP's we use @ sign for parameter name
I would like to have an regular expression that does not allow any spaces(before,within,after the word) and alphanumeric characters.
View 3 RepliesI have some data with delimited by "~" character. Now I want to display this data in multline textbox and replace "~" with line break, Let me know How can I do this?
View 4 RepliesI want to insert the symbol α (alpha) to the database.
i am using the field type as nvarchar
when i directly copy-paste it to database it works
when i try it over sql it is entering as 'a'
I have a table that contain special characters and when the user search for nguyen I want to return string that contain Nguyá»…n or nguyen or any other nguyen variations.
I have absolutely no idea where to start and will be greateful if someone know any article that explain how I can do this.
How can I generate a 7-digit random number and special character string in a textbox on a button click event, in VB.Net?
View 2 Repliesi have table a with fourcolumns and more which need not be considered i would like the fourth column which has a special charcater ^ within it to act as row seperator such tht the values of 1,2,3 are comon for ALL THE ROWS BASED ON THE SPECIAL CHARACTER.
View 3 RepliesI have field_1, the data format store in the field is about "Mary, Amy, Billy, Ma" how can i extract the record that the field_1 has Mary.
I can't use the like'%Mary%' because it can extract 'Ma' too.
I would like to extract exactly Mary. or can i split the field_1 by ',' in sql?