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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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(" +Eval("Order_No") + " );" %>'
View 15 Replies
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
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
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
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
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
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
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
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