.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Workflow E-mails with Long Text Truncate the Text

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint
The title is pretty self-explanatory.  I have a few fields that are generated from some Infopath Forms.  The text, however, truncates and doesn't display the entire text.

Anyone have any suggestions?

View Complete Post

More Related Resource Links

ActiveX and Visual Basic: Enhance the Display of Long Text Strings in a Combobox or Listbox


The combobox and listbox controls in Visual Basic have no built-in support for displaying text strings that are too long to fit in the visible area of either control. This article describes several techniques to improve the readability of long strings in each control. The first technique uses tooltips to display a combobox or listbox item. The other techniques, which use various Windows APIs, include adding a horizontal scrollbar for a listbox and determining the necessary width of the longest string given the font attributes of the text. The required steps are described for both comboboxes and listboxes.

John Calvert

MSDN Magazine December 2000

How to use display Text in Hyperlink For SharePoint 2010 Designer Workflow


In SharePoint 2007 Designer, I have used the Hyperlink column to store the link "http://www.sharepoint.com/Default.aspx, Details". The details text will be shown in the Hyperlink column. Everything works fine in sharepoint 2007 Designer workflow.

In SharePoint Designer 2010 Workflow, I used the same method but the hyperlink column is displaying the full text "http://www.sharepoint.com/Default.aspx, Details" instead of only Details


Send a workflow email as plain text


I'm using a (SP designer) workflow to send e-mail alerts. I need to be able to send the e-mail in plain text because the recipient is an e-mail-to-SMS service that cannot handle HTML messages. I tried adding <pre> tags to my message, this causes the message to look like plaintext in Outlook, but is still sending the message as text/html type which isn't compatible with the aforementioned SMS service. Any ideas how I can make sharepoint send the messages as true plain text?

Mail server is Exchange 2003 SP2.


How do I send a workflow email in plain text

I'm using sharepoint designer to setup a workflow. My action is 'Send an Email'.  I have no problems sending the email, the problem is the email is always sent as HTML and I need it sent as plain/text as the application receiving this email only takes plain/text.  How do I send emails in plain text or is there an easy 2 step workaround?

Field shows as when using SSIS and sharepoint adapter


Hello, I am setting up an SSIS usingthe Sharepoint Source adapter. I am replacing and existing process that imports data from Sharepoint into Excel directly, but this is manual.  The sharepoint source adapter seems to truncate column names or provides different column names then what is visible on the user Sharepoin site - they all do not match my manual import into Excel and there are additional fields.  I'd assume that what it is returning is the actual Sharepoint Database column name.  Anyway, I need to map my fields to my existing process in SQL.  The only way I know how to do this and identify what columns are being returned, I am attempting to import the data into Excel using SSIS through the Excel Destination.  I'm having an issue with a few fileds....I have a field/column called QAReviews which is importing into Excel with all the fields for each record showing <Lon Text> instead of the value the Sharepoint site actually contains.  In my manual Excel import process, this field shows the correct data.  By the way, on sharepoint this is a choice field. Can someone tell me why I'm getting something different through SSIS then what I get from using the manual import in Excel.  I also exported the data from Sharepoint to Access and again I get the correct data. Please advise.



Rich Text editor comes up with random error The Page took too long to save. You can click "Cancel",

I seem to get a random error when i open the rich text editor in a content editor web part and try to save the changes.

The error i get is:
Are you sure you want to navigate away from this page?
The page took too long to save. You can click "Cancel", and then try to save the page again. If you click "OK", you might lose unsaved data.
Press OK to continue, or Cancel to stay on the current page.

If i click OK it seems to save the changes but this problem is very annoying and users are obviously worried when they see this error.
Does anyone have any ideas what is causeing this error across the entire site? and are there any fixes?

thanks for your time,

Tony Phillips

Multiline Gridview and Formatting with Long Text SQL ASP




I have a long text in SQL and passing it to a gridview. I am trying to make the gridview result display in a multiline scroll. I have tried the following code but to no avail. Can someone please assist? Additionally, the text in the gridview result is not in the same format as where it came from, eg. Word. That is the format such as bullet points and multiple spaces are removed. So what is left is a lenghty long string. Please help.





<asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
            AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
                <asp:TemplateField HeaderText="description" SortExpression="description">
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("description") %>' TextMode="MultiLine" ></asp:TextBox>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("description") %>' TextMode="

AutoCompleteStringCollection for text box in DataGridView 2.0

I have been searching for a way to have autocomplete in a DataGridTextBox
object. There does not appear to be an obvious way to do this like you would
for a TextBox outside of a grid using the AutoCompleteCustomSource. Any
thoughts on how I can add this collection? :)

Built-in Functions - Text and Image Functions in SQL Server

Text and image functions operate on TEXT, NTEXT and IMAGE data types. These data types are deprecated with SQL Server 2005 and should be replaced by VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) when possible. Alternatively you can also consider storing large string values using XML data type. Text and image functions are nondeterministic.

Future versions of SQL Server will not support TEXT, NTEXT and IMAGE data types. Columns with TEXT / NTEXT data type do not support commonly used string functions such as LEN, LEFT, RIGHT, etc. Furthermore, due to the large size of TEXT data you''re likely to see performance issues if you store such data in the database. However, at times you can''t help but use the TEXT / NTEXT / IMAGE data types (for example when supporting 3rd party databases when you cannot change the schema) - this is when text and image functions come in handy.

Built-in Functions - Text and Image Functions

Text and image functions operate on TEXT, NTEXT and IMAGE data types. These data types are deprecated with SQL Server 2005 and should be replaced by VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) when possible. Alternatively you can also consider storing large string values using XML data type. Text and image functions are nondeterministic.

Conversion of text files from ANSI to UTF-8

reading and writing text files in ANSI format and
writing html-files in Charset ISO-8859-1 (Western Europe).

Text to Voice

Text to Voice and Voice to Text convert

Voice to Text conversion:-

reference from menubuttons to text parts in article on the same page


Hi, I'm searching now for hours but couldn't find it.Cry

In my menu i have several buttons which (by a <a href..) should go the a part of an article that is in the same form.

Menu button : What is a database should go to the page default.aspx and in there is an article published.
A part of this article is having a piece of text about "what is a database"

Menu button: how to make a query should go to this same article in the same page but then to the part that is have the piece about the query. The next could be an example of what i'm doing:

    <li><a href="default.aspx ?????>what is a database</a></li>
    <li><a href="default.aspx ?????>what is a query</a></li>

Where my question marks are, there should be a connection to that particular piece of text.
In each article part there is an ID="text1" and the second part id="text2"

How shoudl i do that, Should i use a question mark.
Please give me some guidance how to structure the <li> statement or a pointer where I can read about it.


text editor


 I format lines in a .aspx file (source view) the way I can use them, and if I switch to design view or view in browser or debug, the many lines get reformatted to flow all onto one line.

I can't seem to find the correct setting to keep this from happening.

Any suggestions?


Unique text value in databse column


Hi Everyone!

I know this is probably a very basic question but how do I keep a column's text values unique in SQL server (ie for a unique username)?  The column is not an integer it's varchar(50), and it's not the primary key but I could make it the primary key if recommended.

The front end could handle it;  where the user would enter text, it's validated, then a query is done to see if that username is available.  If so, then user can decide to choose it and an insert is done, if not they pick a new username and process repeats.  With this approach, the responsibility of keeping the value unique solely rests on the front end, nothing on the database side.

Is this the correct way to handle this? 

Thank you!


Willing to Write Urdu in my text box


 hi want to write urdu in text box of my application if anyone has the solution how to do this kindly let me know

Change Button Text in Multi Language Website


Hi i developing multi language website

using Master pages

everything fine

Page_Load i set the Text property of Button Control from Resource file

like this

Button1.Text = GetLocalResourceObject("Button1")

then in the button click event i cnage the text of the Button control

Button1.Text = GetLocalResourceObject("Button1_new")

but the text doesn't change and no error messgae

what is the problem how to solve this


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend