I'm trying to to display the first 50 characters of text from a database field.
I thought I could do it something like this: <%# Eval("BodyTxt").ToString().Trim("50")) %> but it doesn't work.
I've also tried this: <%# Trim(Eval("BodyTxt")) %> although I never expected that to work.
Suppose i am having 25 character length string and I want to bind only first 15 character of that string into the label control.
<a href="[URL]" >"<span class="name" style="text-align: left; font-family: Arial; color: #0094DA; font-size: 14pt">
<%#Eval("Name").ToString().Length >= 30 ? Eval("Name").ToString().Substring(0, 30) : Eval("Name").ToString()%></span></a>
I'm trying to trim a comma from the end of a string. I've tried the following:
Variable.TrimEnd(',');
I've also tried:
char[] CharToTrim = { ',' };
Variable.TrimEnd(CharToTrim);
Neither option is working. why?
I want to show just a part of a string for example:
Instead: "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua."
Just a: "Lorem ipsum dolor sit amet, consetetur sadipscing..."
Which method can I use to do that?
I have the following query;
[Code]....
How do I modify to trim all strings?
I developed crystal report using the tool available with VS2005.
I need help for extracting a string in a formula field.
Example :
String= CFG:1,132578992,1958| result should be 132578992
String= CFG:2,158974,1953| result should be 158974
in the string always starting part is "CFG" and ending part is "|" how can i trim the string after the first comma .
This is my first class ever buildt (I am a real beginner) in C#. My aim is to "Sanitize a string". The class should do: trim an input make the first letter upper case. Is there a way to better code it? Would it make sense to use a PARAMETER for a method like: CapitalizeFirstLetterTrim(string x) when I initiate an object I need write a lot of code like below, any other way to make it shorter?
UserInputSanitizer myInput = new UserInputSanitizer();
myInput.Input = " ciao world";
string ouput = myInput.CapitalizeFirstLetterTrim();
Useful resource http://msdn.microsoft.com/en-us/library/bb311042.aspx
----------- CLASS
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace WebProject.Core.Utilities
{
public class UserInputSanitizer
{
// Backing variables
private string _input;
// Properties
public string Input
{
set { _input = value; }
}
private string _output;
// Backing variables
// Properties
public string Output
{
get { return _output; }
}
public string CapitalizeFirstLetterTrim()
{
// Trim
_input.Trim();
// Make First letter UpperCase and the rest levae lower case
_output = _input.Substring(0, 1).ToUpper() + _input.Substring(1);
return Output;
}
}
}
I want to remove the last word from my sentence in C#. Here is my query:
"SELECT * FROM People WHERE City = @City AND County = @County AND"
I want to remove the last AND programatically, how can I do that?
I populated a DataList with a Title (<%# Eval("Title") %>) and Content (<%# Eval("Content" %>) and all is OK. My problem is to how to trim the "Content" so that it only shows part of the string, say only the first 5 sentences, and I would like to add a "more details" link afterwards.a url on the "Title", same url of the "more details" link.
View 13 RepliesI would like to use the trim() method to remove white spaces at the beginning and/or end of text entered in text boxes that are in Insert and Edit Item templates. example with the code below if there is a way to do this?
This is the example of one of my template fields:
[Code]....
I have a repeater that generates last names. My issue is for the names like Smith, Jr I want to remove the comma and everything after it so that is just displays Smith. I thought the code below would work, but it doesn't.
[Code]....
I'm concatenating a string in codebehind to use in a sql select statement.
in aspx
<asp:Label ID="LabelHidden" runat="server" Visible="False"></asp:Label>
SelectCommand="SELECT * FROM [Data] WHERE [ActivityName] IN (@ActivityName) AND ([ID] = @ID)"
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList_Employees" Name="ID"
PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter ControlID="LabelHidden" Name="ActivityName"
Type="String" />
</SelectParameters>
in codebehind
foreach (ListItem li in ListBox_Activities.Items)
{
if (li.Selected)
{
queryBuilder += li + "', ";
}
queryBuilder = queryBuilder.Substring(0, queryBuilder.Length - 1);
LabelHidden.Text = queryBuilder;
When i run the code it comes up blank. I did a query trace and it seems to be running as
exec sp_executesql N'SELECT * FROM [Data] WHERE [ActivityName] IN (@ActivityName) AND ([ID] = @ID)',N'@EmployeeID int,@ActivityName nvarchar(50)',@EmployeeID=4,@ActivityName=N'Production Technical Support'', Tools Development'','
with exta "'s
How can i format the queryBuilder string correctly in my code?
[Code]....
[Code]....
I am using this command to trim a cell value from a grid view.
row.Cells[i].Text.Trim().Length
The result return is always 6.
I have checked that the value of this is empty, when I display it on page using this code,
Response.Write(" '" + row.Cells[i].Text.Trim()+ "'<BR>");
I get ' ', it seems like there is a space in it.
I have a standard gridview, populated via a SQLDataSource, with columns converted to templates.
The edit templates have text boxes. When saving edited data via these text boxes, I need to trim the values to remove any spaces.
How do you recommend doing so? I've tried various methods but none seem to work.
Currently my update parameters are specified in the SQLDataSource.
I am using a gridview populated via a SQLDataSource. When editing or inserting data via the gridview, how do I trim the values before they are inserted to or updated in the database? I want to ensure that no spaces are accidentally added to the end of my text values.
View 4 RepliesI have a LinkButton that is databound to a description. Sometimes the descriptions are very long and unorganized so I would like it to show for example 75 characters and then append a '...' to the end of any description greater than 75 characters. I found this snippet which pretty much is exactly what I want to do :
from [URL]
[Code]....
I just cant figure out how to do this for the LinkButton in my ItemTemplate in the DataList.
I have problem in trim and change the space
This orginal Code
[Code]....
at present i'm using like this
If Not IsNothing(ID) AndAlso Not ID = "" AndAlso Not CInt(ID) = 0 Then do something End If
i'd like to add, if it is not string. How?
how to remove string using c# code behind
my input
a="xxxx?folder=/~/QC/uploads"
my output
a=xxxx;
where xxxx =12,
=123
1234
I m trying to change the img src using the code behind.
A dinamic image that the final user can alter anytime and after this he can send that html content to some email adress.
My trouble is that when I change the image using the code behind the img src doesn't come with html content.
s is possible to nest connection string code as in the following?
<asp:SqlDataSource ID="SqlDataSource4" runat="server"
ConnectionString="<%$ ConnectionStrings:'<%$ appSettings:myconnstr%>' %>">
</asp:SqlDataSource>
a typical Unique Identifier looks like this "e7321a77-8422-408e-90ed-eb3df9aca4d8"How can I trim that down to display only first 23 characters? I would like to display that output in a label.
for example:
lblUID.text = "e7321a77-8422-408e-90ed"
can someone give me a vb.net 3.5 example?
I have a textbox with a RegularExpressionValidator. I want to require the user to enter at least n characters. I'd also like to remove whitespace both at the start and end of the textbox. I'd still like to allow spaces within the textbox, I just want to remove the excess at the beginning and end. I basically don't know how to combine the trim regex and the count together for use in a REV.
trim: ^s*((?:[Ss]*S)?)s*$
count: .{10}.*
I basically want to know if the input, after leading and trailing whitespace is removed, is greater than n characters.
how can i search on my web page a specific string in source code ?
View 5 Replies