I 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 Am using Special character while insert in the database. When i user single Quotes('), it shows an error that "Unclosed quotation mark after the character string" How can i over come this issue. But i want to insert the special characters"
View 5 RepliesI 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.
Below is House_info table in database
Id Behtop Service1 Service2 Service3 Name
1 1111 Ser1 Ser2 Ser3 Sara
2 2222 Ser4
I have lable=lblservice in my page that bind it from data base I want in lblservice show service1 and service2 and service3 column's data like below
ser1 , ser2 , ser3 so I wrote below code in SP
SUBSTRING (ISNULL([Service1]+','+' ',' ')+ISNULL([Service2]+','+' ',' ')+ISNULL([Service3]+','+' ',' ')+ISNULL(' ',' '),0,66)+'...'
as Service but here as you see in row with id=2 there isn't any data in service2 and service3 columns and just in service1 is data(ser4) so it show in lblservice data like below ser4, , , Â ...
but I want if in one of column doesn't be data it doesn't show (,) that come after data I mean I want if in 1 columns be data in show:
ser1,... NOT ==> Â ser1, , , ...
if in 2 columns be data shows
===>( ser1,ser2, ...) Â NOT ===>(ser1,ser2, , ...)
after a complex sql script I finally get temp table like this
No Invalid Port
1 AA,BB,CC,AE,CD,LA,SE,GE,XX,A2,A3...
2 PO,FD,SE,LE,SE,AQ,GB,NK,NA,OM,IA,JO,YA,LL,EN...
then I will use this temp table to join with another table to get the finally result like this
No Invalid Port Start No EndNo
1 AA,BB,CC,AE,CD,LA,SE,GE,XX,A2,A3... AA QO
2 PO,FD,SE,LE,SE,AQ,GB,NK,NA,OM,IA,JO,YA,LL,EN... BB QP
I have problem here.. the Invalid Port list will be a very very long string.. I want to insert symbol to this field (each 2 ports with one symbol)
[Code].....
My issue is that , need to change the column name(following format "Remove first character and after 3rd character insert colon") of the gridview (which is binded with XMLTextReader). Without changing directly XML file, Required to change the column name dynamically at runtime .
Performance.xml
<Performance>
<Departments>
<Heading>FS</Heading>
<S0015>1</S0015>
<S0020>2</S0020>
<S0025>5</S0025>
<S0030>5</S0030>
<S0035>6</S0035>
</Departments>
<Departments>
<Heading>BS</Heading>
<S0015>0</S0015>
<S0020>3</S0020>
<S0025>5</S0025>
<S0030>1</S0030>
<S0035>3</S0035>
</Departments>
</Performance>
Heading S0015 S0020 S0025 S0030 S0035
FS 1 2 4 5 6
BS 0 3 5 1 3
Required Format: Remove first character and after 3rd character insert colon (S0015 -- 00:15)
Heading 00:15 00:20 00:25 00:30 00:35
FS 1 2 4 5 6
BS 0 3 5 1 3
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 referring [URL] ....
I want to apply this function on all textboxes and text area rather than applying it on keypress event on all text boxes.
Using a gridView to read some data from a SQL database. The user can select a record in the gridview. On the SelectedIndexChanged property I populate this to a couple of text boxes & drop down list; txtCountry,ddlProvince,ddlCity.
I have special characters in France ( accent marks) and when I populate it to the drop down list it fails giving out the error message "SelectedValue which is invalid because it does not exist in the list of items".
Example of items that I try to populate are as follows. ( separated by commas) ÃŽLE-DE-FRANCE , PROVENCE-ALPES-CÔTE D'AZUR , RHÔNE-ALPES, DRÔME,ISÈRE ........ When I looked in the drop down lists for Province and Cities I see those Provinces there in the item list. When I debug line by line the word ÃŽLE-DE-FRANCE comes out like ÎLE-DE-FRANCE which is not there in the drop down list. Got to know the ÃŽ is typed by pressing down ALT+206 and lloks like this is what is coming in at the start of the string above.
txtPhoneWork.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 am having a list of contents in the notepad.
I having the following content.
000012|vasanth|Sofware Engineer|Chennai|
0000215|Arun|ASE|Keral|
The field is static and the column name is ID,name,Designation,City.
I need to read the note pad charecter by charecter and i have to insert the records corresponding in the field which is seperated by "|".
I 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 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 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 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 RepliesHow 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 Replies
