Javascript - Display A Truncated String Using Eval

Jul 29, 2010

I have a ASP gridview control. I have a ASP label control in the item template column. I bind data to the grid using -

<ItemTemplate>
<asp:Label ID="lblDesc" runat="server" Text='<%# Eval("Description") %>'></asp:Label>
</ItemTemplate>

But, the value of this string can be upto 80 characters. But, I cannot afford to have the column length to be so high. And, there are limitations so I cannot use Wrap="true" and limit the column width. So, I figured the solution could be to display only about 50 characters in the grid and display the entire string as a tool tip. I managed to do this by using this -

<ItemTemplate>
<asp:Label ID="lblDesc" runat="server" Text='<%# Eval("Description").ToString().Substring(0,50) %>' ToolTip='<%# Eval("Description") %>'></asp:Label>
</ItemTemplate>

This displays the first 50 characters of the string in the grid column. And, the complete string is displayed as a tool tip when the mouse pointer hovers over the text. But, the problem arises when the string length is less than 50 characters. In this case, an exception is thrown. I tried modifying this piece of code to allow conditional display by checking for the string length. But, I could not get this to work. Is there a way to fix this problem? Can we call a javascript function within Eval() ?

View 2 Replies


Similar Messages:

DataSource Controls :: String Is Truncated When Inserted Into DB?

Feb 10, 2010

I am trying to insert some string values into database.

The problem here is that, the string is truncated without warning..

Here is my vb.net code

[Code]....

And here is how I declared the varible in stored procedure

[Code]....

And If I insert "myCode01234567890" then it's truncated without warning at all.

How can I let it throw an exception rather then truncate the string without any warnings ?

View 9 Replies

String Or Binary Data Would Be Truncated - The Statement Has Been Terminated

Nov 11, 2010

String or binary data would be truncated. The statement has been terminated. I'm using the following code but some times(not all the time) i get the above error ....

View 2 Replies

DataSource Controls :: String Or Binary Data Would Be Truncated?

Jan 8, 2010

I tested my app locally and it works perfect, but as soon I publish it, upload it to server and try it, on a 100% copy of my local database it throw me a truncate message; now via this msg

that throws me the error query or via sql profiler I got this query:

[Code]....

View 1 Replies

File Upload String Or Binary Data Would Be Truncated

May 17, 2010

I have a website that uploads different file types, creates thumbs from the files and saves the file and thumbs to their respective folders. every so often it throws an exception string or binary data would be truncated, Ive never encountered this locally. I have a problem pinning down the circumstances that it happens, I thought it was documents with spaces in the name but that works sometimes as well. This is really bugging me and I need to fix this. The db table fields are long enough, trust me . Has anyone else ever encountered this issue?

View 1 Replies

C# - String Or Binary Data Would Be Truncated. The Statement Has Been Terminated

Apr 9, 2010

I have a SqlCommand object on my c# based asp.net page. The SQL and the passed parameters are working the majority of the time. I have one case that is not working, I get the following error:

String or binary data would be truncated. The statement has been terminated.

I understand the error and but all the columns in the database should be long enough to hold everything being sent.

Is there a way to see what the actual SQL being sent to the database is from SqlCommand object? I would like to be able to email the SQL when an error occurs.

View 4 Replies

SQL Server :: Error: String Or Binary Data Would Be Truncated?

Mar 23, 2011

Whenever I add more than a very short string to the "description" column in my table I get this error. That column (in the DVD table) is set to NVARCHAR(1000). I can't see what the problem is. I've add the procedure that throws exception below.

System.Data.SqlClient.SqlException was unhandled by user code
Message="String or binary data would be truncated.
The statement has been terminated."
Source=".Net SqlClient Data Provider"
ErrorCode=-2146232060

[Code]....

View 3 Replies

DataSource Controls :: Sql Server String Or Binary Data Would Be Truncated?

Feb 11, 2010

I am using Sql server version enterprise edition 9 on win NT.I have an issue with the stored procedure, when I execute the SP I get an error message "String or binary data would be truncated." In general I know that we get this error when the inserted value is greater than the column length, but in this scenario the SP is failing only the for the section 1 insertion. The same SP contains one more section where we are inserting records in to same table from same source table based on some different condition and it works.I wrote a script in which I copied the section from the SP which has the problem and storing the output of it in an temp table and inserting one by one record using cursors in to the destination table and then it works.I tried with the option SET ANSI_WARNINGS OFF and SET ANSI_NULLS ON, but it did not work. I am sure that it is not failing because of the length of the data inserted.Is there are other configuration that i can set??

View 1 Replies

ADO.NET :: Error 'String Or Binary Data Would Be Truncated" When Trying To Upload An Image

Nov 9, 2010

I am getting the error: String or binary data would be truncated. The statement has been terminated. when trying to upload an image. What would cause this? my code is:

protected void Button1_Click(object sender, EventArgs e)
{
if (IsPostBack)
{
HandleUploadedFile();
}
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
System.Data.SqlClient.SqlConnection sqlConnection1 =
new System.Data.SqlClient.SqlConnection(connectionString);
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "INSERT INTO picstosort (imageurl, useraddy) VALUES (@imageurl, @useraddy)";
cmd.Parameters.AddWithValue("@imageurl", Label5.Text);
cmd.Parameters.AddWithValue("@useraddy", TextBox1.Text);
cmd.Connection = sqlConnection1;
sqlConnection1.Open();
cmd.ExecuteNonQuery();
sqlConnection1.Close();
if (TextBox1.Text != null)
{
string strTo = TextBox1.Text;
string strFrom = "noreply@test.com";
string strSubject = "Picture Uploaded";
SmtpMail.Send(strFrom, strTo, strSubject,
"Thank you for uploading your picture! ");
}
}
private void HandleUploadedFile()
{
string root = Server.MapPath("~/");
if (!root.EndsWith(@""))
root +=@"";
string fileDirectory = root + @"Images";
string link = "<a href='Images/{0}' target='_blank'>{1}</a>{2}{3}";
for (int i = 0; i<Request.Files.Count; i++)
{
HttpPostedFile fi = Request.Files.Get(i);
byte[] fileBytes = new byte [fi.ContentLength];
using (System.IO.Stream stream = fi.InputStream)
{
stream.Read(fileBytes, 0, fi.ContentLength);
}
string fileName = Guid.NewGuid().ToString();
File.WriteAllBytes(fileDirectory + fileName + "_small.jpg",
ResizeImageFile(fileBytes, 10000));
litText.Text += string.Format(link, fileName + "_small.jpg",
fileName + " Small", "<br/>", "<br/>");
Label5.Text = fileDirectory + fileName + ".jpg";
litText.Visible = true;
fileBytes = null;
}}
private static byte[] ResizeImageFile(byte[] imageFile, int targetSize)
{
using (System.Drawing.Image oldImage = System.Drawing.Image.FromStream(new MemoryStream(imageFile)))
{
Size newSize = CalculateDimensions(oldImage.Size, targetSize);
using (Bitmap newImage = new Bitmap(newSize.Width, newSize.Height, PixelFormat.Format24bppRgb))
{
using(Graphics canvas = Graphics.FromImage(newImage))
{
canvas.SmoothingMode = SmoothingMode.AntiAlias;
canvas.InterpolationMode = InterpolationMode.HighQualityBicubic;
canvas.PixelOffsetMode = PixelOffsetMode.HighQuality;
canvas.DrawImage(oldImage,
new Rectangle(new Point(0, 0), newSize));
MemoryStream m = new MemoryStream();
newImage.Save(m, ImageFormat.Jpeg);
return m.GetBuffer();
}}}}
private static Size CalculateDimensions(Size oldSize, int targetSize)
{
Size newSize = new Size();
if (oldSize.Height > oldSize.Width)
{
newSize.Width = (int)(oldSize.Width * ((float)targetSize / (float)oldSize.Height));
newSize.Height = targetSize;
}
else{
newSize.Width = targetSize;
newSize.Height =
(int)(oldSize.Height * ((float)targetSize / (float)oldSize.Width));
}
return newSize;
}
}

View 3 Replies

Web Forms :: Insert Query Error - String Or Binary Data Would Be Truncated

Jul 16, 2012

this is my ImageButton event code

protected void ImageButton_Click1(object sender, ImageClickEventArgs e)
{
string data = Server.UrlDecode(Request.QueryString["BehCode2"])
SqlCommand _cmd = new SqlCommand("insertinfo", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();

[code]...

View 1 Replies

Data Controls :: File Upload - String Or Binary Data Would Be Truncated

Jun 20, 2013

I uploaded above 10 mb file i am getting this error..

"String or binary data would be truncated. The statement has been terminated"

my datatype in database is set as varbinary(MAX) then also i am geeting error

View 1 Replies

Data Controls :: String Or Binary Data Would Be Truncated - The Statement Has Been Terminated

Mar 26, 2016

CREATE TABLE [dbo].[login] (
[Id] NVARCHAR (50) NOT NULL,
[username] NCHAR (10) NOT NULL,
[password] NCHAR (10) NOT NULL,
[Phone_no] NVARCHAR (50) NOT NULL,
[Email] NVARCHAR (50) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)

[Code] ....

When I am trying to save the value then get above mentioned error ....

View 1 Replies

Data Controls :: DropDownLists - String Or Binary Data Would Be Truncated

Mar 4, 2013

I have 2 DropDownList and 1 button  in admin.aspx page

1=DDLtradeO and 2=DDLclassO

users should select Item from both of them I use RequiredFieldValidator for both of them and when they click on button in HOuse_info Table it insert their data here when users select first item from DDLtradeO  (that text is="State" )

{ DDLclassO.Enable=false}

below is code

<asp:DropDownList ID="DDLtradeO" runat="server" CssClass="DPCDDLs" AutoPostBack="true" OnSelectedIndexChanged="DDLtrade_SIC">
</asp:DropDownList>

and behind code

protected void DDLtrade_SIC(object sender, EventArgs e) {
if (DDLtrade.SelectedItem.Text != "State") {
BindTrade();
DDLclass.Enabled = true;
Rfv11.Visible = true;
} else {
DDLclass.Enabled = false;
Rfv11.Visible = false;
}

here RFV11 is RequiredFieldValidator for DDlclasso..problem is here when users select other item from DDltradeO and they select Item form DDLcalssO when they click on button it insert data into House_info table correctly but when they select "STATE" Item from DDLtradO (they can't select Item from DDlcalssO) when they click button this error occurrence Server Error in '/behtop website' Application.

String or binary data would be truncated. The statement has been terminated.An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details:  System. Data. SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. Source Error: 

Line 312:
Line 313:
Line 314: int result = Convert.ToInt32(_cmd.ExecuteScalar()); Line 315: _cn.Close();
Line 316: //LBLERROR.Text = _cmd.Parameters["@Success"].Value.ToString();

I think its depend to RequiredFieldValidator but I want if users select other Item from DDltrade they select Item from DDLcalssO. Server Error in '/behtop website' Application.

String or binary data would be truncated.The statement has been terminated. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. Source Error: 

Line 312:
Line 313:
Line 314: int result = Convert.ToInt32(_cmd.ExecuteScalar()); Line 315: _cn.Close();
Line 316: //LBLERROR.Text = _cmd.Parameters["@Success"].Value.ToString();

View 1 Replies

Converting Integer To String Within The Eval Function?

Jan 11, 2010

I'm trying to add a parameter at the end of a url obtained from the database as follows:

This is giving error because of the ID value, which is an integer...how can I convert it to string here? I can do it in code behind, but I just want to know how it can be done within the Eval function...

NavigateUrl

='<%#Eval("Filepath") + "&ID="+DataBinder.Eval(Container.DataItem,"ID")%>'

View 3 Replies

C# - Binding To A List <string> Using DataBinder.Eval?

Sep 3, 2010

I have the following object:

CrossTabDataObject
{
string RowName{get;set;};
int RowId{get;set;}
List<string> CellContents = new List <string>();
//Constructor..... etc.
}

I'm building a dynamic crosstab grid using GridView in asp.net 3.5

I wish to bind to CellContents[0] for dynamic column 1, CellContents[1] for dynamic column 2 (dynamic column 0 is the RowName field from the CrossTabDataObject) etc. I am using:

object boundValueObj = null;
Control ctrl = (Control)sender;
IDataItemContainer dataItemContainer = (IDataItemContainer)ctrl.NamingContainer;
boundValueObj = DataBinder.Eval(dataItemContainer.DataItem, strSelectedID);

This code is in the InstantiateIn function of the gridview as I'm creating drop down list templates in each cell of the crosstab.

I have code (not shown) that sets strSelectedID depending on the column being created.

When strSelectedID is equal to "RowName" for dynamic column [0] the DataBinder.Eval function works fine and sets boundValueObj as expected. The problem comes when strSelectedID is set to "CellContents[n]" where n is the Column Index.

DataBinder.Eval only works with properties and fields of objects. How do I get around this?

View 1 Replies

Javascript - Navigate Url And EVAL

Aug 16, 2010

I am trying to Navigate URL in this way

<asp:HyperLink runat="server" NavigateUrl='javascript:NavigateUrl("<%#Eval("TicketID")%>","<%=RedirectURL %>");'><%# Eval("TicketID") %></asp:HyperLink>

but an error occurred in the javascript Error Console in Mozilla browser. Error: missing ) after argument list Source File: javascript:NavigateUrl("<%#Eval("TicketID")%>","<%=RedirectURL%20%>");
Line: 1, Column: 22
Source Code: NavigateUrl("<%#Eval("TicketID")%>","<%=RedirectURL %>");

I want to remove the error. but functionality is ok.

View 3 Replies

Web Forms :: Passing Eval() As Parameter In Javascript

Oct 22, 2010

I have got a drop down list in a gridview and would like to pass eval() as parameter to javascript..

<asp:DropDownList ID="ddl_grprowcutter" runat="server" onchange='<%# "fn_ddl(" &#43;Eval("Order_No") &#43; " );" %>'

View 15 Replies

Web Forms :: Bind Multiple Query String Parameters From Database When Working With Eval

Aug 26, 2012

I have the following Repeater, I need to bind multiple querystring parameter in  HREF

<li class="current">
<a href="house.aspx?H_name=all"></a>
<ul>
<asp:Repeater ID="rptMenu" runat="server">
<ItemTemplate>

[code]...

View 1 Replies

How To Bind Javascript Function With OnClientClick Event With Eval

Sep 30, 2010

my link button -

<asp:LinkButton runat="server" ID="lbtnEdit" Text="edit" OnClientClick="javascript:msgDisp('<%# Eval(LocationId).toString() %>')" />

and the javascript msgDisp is-

<script type="text/javascript" language="javascript">
function msgDisp(lid) {
alert(lid);
}
</script>

but it is not giiving LocationId in pop but the whole string <%#......%> is comin in popup message. How can I pass Eval values in javascript.

View 2 Replies

Pass Eval As Javascript Function Parameter In Gridview?

Jun 25, 2010

I have the following:

<EditItemTemplate>
<asp:Button ID="wrqst_need_ind_btn" runat="server" Text = "Create WR"
onClientClick="javascript:popUp('popup_createWR.aspx')"
CommandArgument='<%# Eval("dvc_nm") + "|" + Eval("data_orgtn_yr") %>'/>
</EditItemTemplate>

I want to pass in as two additional params the Eval("dvc_nm") and Eval("data_orgtn_yr") to the popup function.

UPDATE:

I tried by removing the single quotes from insode the <% %> tags. Which gave me this:

onClientClick='<%# "javascript:popUp(popup_createWR.aspx," + Eval("dvc_nm") + "," + Eval("data_orgtn_yr") + ")" %>'

which complied, but when I clicked the button I did not get a pop up, the page just posted back and reloaded and said errors on page, but no popup...

View 2 Replies

Eval And ItemDataBound Or RowDataBound Event To Display Data Which One Is Better?

Nov 4, 2010

Which method is better (performance-wise) if I have DataBoundControl such as GridView, Repeater, and/or DataList and I use the following method to display data:

Eval("ColumnName")
or handling the ItemDataBound or RowDataBound event like:
void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
// my code to display data here
}

I prefer the second one for code readability reason, but for performance reason, are they the same (or are they even the same thing)?

View 2 Replies

Data Controls :: Pass EVAL Value To JavaScript Function From GridView

May 7, 2015

How do I pass Hidden Variable to javacript function on GridView hyperlink click.Below is the code used

<asp:GridView ID="gridMicroscopicCode" runat="server" ...
<ItemTemplate>
<table id="Table2" cellpadding="0" style="border-width: 0px; width: 100%;" class="tableBorder" runat="server">
<tr class="botborder1">
<td style="width: 25%;">
<input id="Hidden1" runat="server" value='<%# Bind("preferenceid")%>' type="hidden" />
<asp:HyperLink ID="hypMicroscopicPopUpEdit" runat="server"
Target="_self" NavigateUrl="javascript: EncryptDataFunc('VAAddEditMicroscopic.aspx?editoption=yes&queryprefid=' + <%# Hidden1.value %>);">
</asp:HyperLink>

View 1 Replies

C# - Client-Side Validation Prvent Manually Postback By JavaScript Eval ()

Mar 8, 2010

I encouter some postback issue when using GetPostBackEventReference. Here is the Scenario:I have a javascript modal popup dialog and got a button in this modal dialog which used to select things (this is NOT an asp:button control)

When this javascript dialog HTML button is clicked, it will call the MS AJAX web service call by the javascript: eval() method. And this MS AJAX web service call is dynamically generated. So the code is like this:

var serviceCall = svcCall + "(" + parameters + ")"; //dynamically generate the MS AJAX web service call here
eval(serviceCall);

//use eval to trigger the MS AJAX web service call

As you may all know, after complete the MS AJAX web service, you can define a callback function to handle the completion:

function OnComplete(result, userContext, methodName) {

//force to call postback manually
eval($(userContext[0]).val()); [code]...

As you can see, this is how I bound the asp:button (i.e. btnSelectUser) 's Click Event to the asp:hiddenfield using the GetPostBackEventReference, and set the registerForEventValidation argument to false. I have also tried to use different ValidationGroup and set the CausesValidation to false.In summarize, I bound the asp:button's Click PostBackEventReference(i.e. __doPostback(....)) to the asp:hidden field's Value attribute, and using javascript eval() to eval this hidden field's value in order to manually trigger postback.

p.s. the btnSelectUser is an asp:button control and used to call out the javascript modal dialog.

Ok, here is the Problem:In the same page, there is some asp:validator, e.g. and , and of coz, when the page run into error, this validator and callout will display to the user. e.g. When the user didn't fill in anything and submit the form, the ValidatorCalloutExtender will display a ballon and tell the user. Imagine one of this ballon/validatorCalloutExtender come out and on top of your screen at the moment.

Then you click the btnSelectUser (asp:button) to show the javascript modal dialog, and in the dialog, you Add some users, and once you hit the SELECT button inside this modal dialog, a MS AJAX web service is trigger as mentioned above, and once this web service is complete, it eval() the asp:hidden field's value (i.e. __doPostback(...))......and do the postback manually.

However, because of the validatorCalloutExtender ballon has display, it somehow cannot trigger the postback in this way, but when I close the ballon/validatorCalloutExtender, the manual postback using eval() is just working fine. Even more strange is that, when the ballon is displayed, the first time I click the SELECT button inside this modal dialog it doesn't fire the postback, however, if I do the same thing again (i.e. open up the javascript dialog, and choose some users, then click the SELECT button again). It able to do the manual postback....and I don't understand why the first time doesn't work.

View 1 Replies

C# - If Statement Inside A ListView With Eval() Or DataBinder.Eval()?

Nov 11, 2010

I have a listview control on an .aspx page. Inside this list view i want to check "Type" property which comes from database. here is the example code :

[code]...

As a last resort i tried to user DataBinder.Eval() but i get the exception "Expected class, delegate, enum, interface, or struct". What can i be doing wrong? Writing a function in code-behind isn't an option for me.

View 3 Replies

Data Controls :: Pass Multiple Eval Values To JavaScript Function Inside GridView

May 7, 2015

I want to pass hidden variable to javascript from href. Below is the code used

<input runat="server" id="hidOrganizationId" type="hidden" value="" />
<ul class="gloMenu">
<li id="liOrg" runat="server">
<a href="javascript: DataEncryption('../Admin/DetailPage.aspx?OrganizationId=' + hidOrganizationId)">
<b>Ordering Facility</b>
</a>
</li>

View 1 Replies







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