DataSource Controls :: Remove Sepcial Characters From The Column Value?
Feb 15, 2010I have one requirement i.e i wanted to replace or remove all the special characters except alphanumeric in the column value
how to do ....
I have one requirement i.e i wanted to replace or remove all the special characters except alphanumeric in the column value
how to do ....
I'm trying to remove extraneous characters like quotes, commas, etc from my dataset. I get the fact in the standard way of doing things in your code behind you simply go
string data = data.replace(",",""); or something like this. However, a datasource doesn't seem to give me that capability. What can I do to make it do this? I'm importing data from an excel sheet into a gridview. The commas are goofing up my view. I'd like to replace any commas in the dataset with spaces. Here is the code I have.
[Code]....
I am using this code to find titles depending on user criteria:
[Code]....
The search is non-english charachters, and it has some problems. when you looks for "Marker" and in database you have this title: "Markers" it won't find it..... This search just not good enough and I am looking to replace it urgently....
i have string
Dim str As String = "C#app_wiod_200"
i want to remove characters from wiod in string which one is the best string function to do this.
I have users emails in my database and when i retrieve those usernames, i want to remove every charecter after the @ charecter in the email for example, i have myname@domain.com i want to cut that to myname.
View 3 Repliesi want to display values in dropdownlist using querystring[which is successfully happening] but the problem is when id passed in querystring is 7.17 then in dropdownlist it is displaying values as 7 . 1 7....but i want to display it as 7 and 17...
here is a part of the code
string imageid;
string logoid;
string id1;
string id2;
String Name;
protected void Page_Load(object sender, EventArgs e)...
string="/?UPID=1000001&One=1&Two=2"
UPID is always equal to 7 digits. I want to remove "UPID=(any 7 digits)".
I'd like the output to be:
string="/?One=1&Two=2"
Or if no query strings
string="/"
I've wrote this little method to achieve the goal in the subj., however, is there more efficient (simpler) way of doing this? who will search for this like I did.
var fileName = new System.Text.StringBuilder();
fileName.Append("*Bad/ :, Filename,? ");
// get rid of invalid chars
while (fileName.ToString().IndexOfAny(System.IO.Path.GetInvalidFileNameChars()) > -1)
{
fileName = fileName.Remove(fileName.ToString().IndexOfAny(System.IO.Path.GetInvalidFileNameChars()), 1);
}
?
I am looking a regular expression that will remove all of the text except for the charachters that comes after the last "-" character. in this way I can get the ID for a URL.
[URL] so that after the regular expression will be exutes I will have "t43g2g" ID.
Om C# how can i remove all the characters on the left and the #?
Take this: aaaeeae#http://www.sharepointsite.net/Staff/_w/lawn_JPG.jpg'
And make it this: http://www.sharepointsite.net/Staff/_w/lawn_JPG.jpg'
I am using a master page and I need to change how the <title> element is rendered. The <title> content renders as expected. The problem is the whitespace that bounds my <title> element. I want to get rid of it.How do I remove the leading and trailing characters
View 4 RepliesNeed a regular expression to replace the following sequence
Before : abbbccdd After : abcd
And also if numeric data is present instead of alphabets i would like to remove the duplicates and display
I used many methods but not getting the output, till yesterday it was working but cant understand now whats happening??
i enter the right data but still it returns this error:
"Invalid control characters"
see my code;
public string officelist(string uname, string pwd, long id) {
WebReference,CommonWSEndPointService eps = new
WebReference.CommonWSEndPoinService;
string url = "xxxxxxxxxxxxxxx?wsdl";
HttpWebrequest req = (HttpWebRequest)WebRequest.Create(url);
req.connection = eps.m291524(uname,pwd, id);
string conn = req.connection;
return con;
}
I have a column in my repeater which allows as many as 255 characters and causes the page contents pushed away to the right if any of the record has all 255 characters in that column. How can I tell it to wrap the text after 50 characters?
View 4 RepliesWhen creating a new column chart, by default a lot of space is inserted to the left of the first column in a series, and to the right of the last column. This means that a lot of space is wasted in the ChartArea.
How can I get rid of this spacing? In other words, how can I align the columns in a column chart so that the first column is all the way to the left of the chart area, and the last column is all the way to the right in the chart area?
Note: I have tried asking this question in the social.msdn "Chart controls" forum [URL], however there does not seem to be many people answering questions there.
[code]....
BroughtForward and Pending both columns contain hyperlink values. When we click the values then another page opens with the details. I don't want to open another page if user click 0 in any column or in other words how to remove hyperlink if there is 0 in any cell?
I am facing a problem with Gridview control. I have created a Gridview1 which is having 3 button column that has been added at design time and some column can be added through the Datatable at runtime. At Design time GridView1 has 3 button column
At Runtime I do GridView1.Datasource=dt; //Now my gridview is having 7 columns i.e. 4 more columns added through datatable.
I can easily display that GridView1 on webpage but I dont want to show some column that I added through Datatable to the user.
When I try to hide that column, I get error like Index out of bound exception but when I hide button column I can able to do that easily.
i am working with a gridview and created it in following way:
[Code]....
Now i want to remove the Select, Edit and Delete link buttons in the last columns for a particular row. It should remain as it is for other rows. Only linkbutton from a particular row(being determined from data key) is to be removed.
I have autogenerated columns some columns come from db and some are virtual columns what i am adding to a dataset that consist of columns from db.i want to disable sorting for the virtual columns which i add to dataset
View 2 RepliesI'm wanting to remove all the special characters (leaving only numbers) in a phone textbox. Here is my current code:
Regex.Replace("(123)456-7890", "[\(\)\-\.+]", "");
I'm currectly tryin to access a specific value in my database in a specific column. I'm tryin to use the primary key of the table to access the actual value in the row of that ID.
The current code:
[Code]....
Just iterates through the table and looking for any row with the boolean 'checkin' value is True, then it takes the 'id' value of that row and stores it into an array. Is there a way that I can access a another entry, and only that entry, in the table with the 'id' stored in the array?
Like if my data base contained and int, primarykey, `id` value, a boolean, `checkedin` value, and a `time` value, is there a way to access, lets say, the row with `id` equalling 3 and and the checkIn value from that row?
I'm using SQL Server 2005 and am getting security errors when the user enters certain characters in the aspx page. For example, the simple string,
&#
causes an error. How do I allow the user to enter anything they want and keep the site secure? In my VB all fields are sent with Parameters.AddWithValue.
I'm trying to retreive a column value from gridview5 to use it in a query to display resuls in gridview, Also how do you hide a column in the grid?
Where (p.Link_ID Like GridView5.?
[code]....
i have a datatable with several columns and rows. now i want to copy the last column fully (all rows) and create the new column with that values.
it means last column values sholud be moved to new column (now this is the last column).
I have SQL2012 database, which has a Table with many columns in it . One of the columns is "Start Date" and i set the dataType to "Date". Now I am putting the data into a gridview but the data is different to the database, the "Start Date" column has time as well. why this is happening ( the Start Date column is the gridview is a BoundField).
View 1 Replies