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:

Forms Data Controls :: Remove The Underscore Character Inside The Repeater

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

DataSource Controls ::character To Column Name Then A New String Random Will Auto Insert Into Column Random?

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

Web Forms :: Norwegian Character Does Not Show Instead Showing Some Strange Character?

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

Web Forms :: Remove The Last Character In String?

Jan 19, 2010

how to remove the last character in string

View 9 Replies

InvalidUserName In CreateUser When Creating User With Character Before The @ Character

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

Web Forms :: Remove Extra Spaces (Space Character) From A Sentence

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

How To Read Character By Character From Text File

Jan 25, 2011

How to read character by character in line from text file?

View 1 Replies

Convert A 40 Character SHA1 Hash To A 20 Character?

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

DataSource Controls :: Insert Special Character To The Database?

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

AJAX :: How To Change "Day Name" In Calendar Extender From "2 Character" To "3 Character" Long Name

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

How To Remove The Character From String

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

Remove String Character In C#?

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

DataSource Controls :: How To Insert Character To The Filed Of Temp Table

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

C# - Remove The Invalid Character From Price?

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

DataSource Controls :: Unable To Insert The Record In The Table While Using Special Character?

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

Remove The Underscore Character Inside The Repeater In C#?

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

Reading Line Character By Character

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

Web Forms :: Read Character Delimited File And Insert Records Into SQL Server Database

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

C# - Allow Some Specific Character From Long Text In Telerik Column?

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

SQL Server :: Transpose A Column In To Rows Based On Special Character

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

Forms Data Controls :: Show Only 20 Character / How To Set Width Like 20 Characters

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

ADO.NET :: Conversion Failed When Converting From A Character String To Uniqueidentifier - Comparing UserID Column

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

Forms Data Controls :: Populate Dropdown List With Special Character

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

Forms Data Controls :: Character Limit In Textbox In Range Validation?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved