Forms Data Controls :: Change The Column Name - "Remove First Character And After 3rd Character Insert Colon
Jan 14, 2011
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
View 2 Replies
Similar Messages:
Feb 21, 2011
here is the pagehttp://www.avakian.gr/Default3.aspx?categorysID=111&parentCategoryID=1&products=aunder the product image is the same product in different views inside a repeaterut this underscore character is annoying
View 2 Replies
Dec 15, 2010
I create a table as picture below :
when I insert any character to column Name then A new string random will auto insert into column Random (picture below) I had used Trigger but It was error !
I want to column Random use to code :
DECLARE @myid uniqueidentifier
SET @myid = NEWID()
insert into table_1 values(@myid, substring(CONVERT(varchar(255), @myid), 1, 5))
but It must auto like column Number (column Number is Identity)
View 1 Replies
Dec 7, 2010
Norwegian character( å æ ø) does not show instead showing some strange character.
used function below:
utf8 = System.Text.Encoding::get_UTF8();
View 4 Replies
Jan 19, 2010
how to remove the last character in string
View 9 Replies
Jul 27, 2010
I looked up the msdn documentation and it says that InvalidUserName is thrown when it does not find the username in the database, which is fine because the user I am creating should not exist in the database. If I use test@example.com, it works, but if I try it with test.@example.com, the status from Membership.CreateUser is InvalidUserName.
View 1 Replies
Oct 21, 2015
How to remove whitespaces if it is more than 2. What i want to say is -
1. If there is one whitespace, its OK.
2. If there is two whitespace, its OK.
3. BUT, if there is more than two whitespace than replace them with only two whitespaces.
String may be like this :- (it may contain any character)
DuntaviDilaniyd.dilaniy@woridnitattnit                       15 jim alixandir id        PALESTINE     TX
48568 2470325837 US             FEMALESunday, April 09, 1939 162      170    A+     • Duntavia
Delaney          Jon Muller        Sherman                         TX       84321 US         9974766226 NO          NO      YES
[CODE]..
View 1 Replies
Jan 25, 2011
How to read character by character in line from text file?
View 1 Replies
Mar 17, 2010
I have a legacy MySQL database which stores the user passwords & salts for a membership system. Both of these values have been hashed using the Ruby framework - roughly like this:
hashedsalt =
Digest::SHA1.hexdigest("--#{Time.now.to_s}--#{login}--")
hashedpassword =
Digest::SHA1.hexdigest("#{hashedsalt}:#{password}")
So both values are stored as 40-character strings (varchar(40)) in MySQL. Now I need to import all of these users into the ASP.NET membership framework for a new web site, which uses a SQL Server database. It is my understanding that the the way I have ASP.NET membership configured, the user passwords and salts are also stored in the membership database (in table aspnet_Membership) as SHA1 hashes, which are then Base64 encoded (see here for details) and stored as nvarchar(128) data.
But from the length of the Base64 encoded strings that are stored (28 characters) it seems that the SHA1 hashes that ASP.NET membership generates are only 20 characters long, rather than 40. From some other reading I have been doing I am thinking this has to do with the number of bits per character/character set/encoding or something related.
So is there some way to convert the 40-character SHA1 hashes to 20-character hashes which I can then transfer to the new ASP.NET membership data table? I'm pretty familiar with ASP.NET membership by now but I feel like I'm just missing this one piece. However, it may also be known that SHA1 in Ruby and SHA1 in .NET are incompatible, so I'm fighting a losing battle.
View 2 Replies
Apr 20, 2010
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'
View 3 Replies
Jul 7, 2010
I am using AJAX Toolkit's Calendar extender control.
When the control is rendered on page, the day names are 2 character long and shown as "Su", "Mo", "Tu", "We", "Th", "Fr" and "Sa".
Instead, I want it to be rendered as 3 character long format as "Sun", "Mon", "Tue", "Wed", "Thu", "Fri" and "Sat". note that I further need to localize this application too. So, I probably need some setting that could do the magic instead of overwriting on some server side event to achieve it.
There is probably some settings that I am not aware of.
The code for localizing the Calendar extender is as follows (in case if you need to test).
[code]....
View 3 Replies
May 14, 2010
my insert query is generated in runtime here i want to remove last ',' character from that string query
my string is below
Insert Into Payroll_AllowanceSettings(EmpID,PFNO,CompanyID,Basic,DA,HRA,CONV,SAll,LeaveAll,OT,Bata,Others,)Values(EmpCS001,1234,1,1,2,3,4,5,6,7,8,9,)
here i want to remove last ', ' character both coloumn fields and value fields how can i remove the characters
View 5 Replies
Jan 19, 2010
how to remove string character in asp.net, im having a string variable string str = "1234, ". i want to remove the comma. its possible ?
View 4 Replies
Mar 18, 2010
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].....
View 5 Replies
Dec 3, 2010
i have a scenario where i have to remove the invalid character from price using c# code.i want the regular ex to remove the character or some thing good then this.
For Ex- my price is
"3,950,000 ( Ex. TAX )"
i want to remove "( Ex. TAX )" from the price.my scenario is that. i have to remove the any character from string except number,dot(.), and comma(,)
View 7 Replies
Jun 28, 2010
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 Replies
Feb 21, 2011
here is the page that has the problem, look at the photos with different views of the product, they are separated with an underscore character
i tried to use template seperator, and added a space character but that didn't do the trick.
View 2 Replies
Mar 4, 2010
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 Replies
Aug 10, 2012
I 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 "|".
View 1 Replies
Jul 20, 2010
I have an aplication in asp.net MVC and using telerik grid for displaying the record. Now one of my field has some large text about 1000 character due to which the text is getting extended vertically and layout is not looking good.
Is there any way to show some specific number of character in the column and show the whole text in a tool tip on mouse hover or any other way to show the complete text for that column.
View 2 Replies
Dec 29, 2010
i 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
Feb 11, 2011
I have datagrid , i have 4 columns , one columns contain 120 charcater , i set width 4th columns as 35%
my this grid column get extend like 120 character , i want to set width like 20 characters , i dont want to extend width like 120
View 5 Replies
Aug 7, 2010
I have a database call that is comparing UserID column of two tables. The UserID is a uniqueidentifier. The page errors on the r.read() line with Conversion failed when converting from a character string to uniqueidentifier. I'm not sure how to code this to avoid the error.
cmd.CommandText = "SELECT a.CenterName FROM Centers a INNER JOIN UserInfo u ON a.CenterID = u.CenterID WHERE u.UserID='{ + SessionManager.UserID + }'";
r = cmd.ExecuteReader();
r.Read();
View 5 Replies
Nov 1, 2010
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.
View 2 Replies
Sep 15, 2010
I am inserting some text in texbox and there is range validation set as minimum as 10 and maximun as 100. But when i run the program, though i insert the text atleast or more than 10 characters, it is showing the error message of this range validation. how to set range so that user has to input atleast 10 character minimum ?
View 7 Replies
