Getting Error About Truncation
Nov 9, 2010
I have an upload control on a page. I was getting the error about truncation, so i put in a new label (Label5) to get the file name. now i get the error: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. I basically want a file uploaded to the /Images folder, it to be resized to be about 300px high by 250px wide, (and much lower kbs). Then the picstosort table be filled in with the images url and the email address which was entered at the same time. Also, the larger image id like to not be stored, so as to not clogg up my web space.. I have code below which has problems, but i dont think is too far off? This is the code i have at the moment:
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 a 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 + ".jpg", fileBytes);
litText.Text += string.Format(link,fileName + ".jpg",
fileName + " Original", "<br/>", "");
File.WriteAllBytes(fileDirectory + fileName + "_small.jpg",
ResizeImageFile(fileBytes, 10000));
litText.Text += string.Format(link, fileName + "_small.jpg",
fileName + " Small", "<br/>", "<br/>");
litText.Visible = true;
Label5.Text = string.Format(link, fileName + "_small.jpg");
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 2 Replies
Similar Messages:
Mar 21, 2011
I have a excel xlsx workbook that needs to be loaded into various SQL tables after the file's data has gone though various business logic checks. There can be multiple excel files as input to the program so i'm using the standard connection string and a data adapter to append the entire sheet into a DataTable so all the data can be checked at the same time. The code below works for this (sort of).
excelCon = new OleexcelCon = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strFileName + ";Extended Properties="Excel 12.0;HDR=No;IMEX=1";");
excelCon.Open();
strExcelSheetNames = GetSheetNames(excelCon);
for (int x = 0; x < strExcelSheetNames.Length; x++)
{
excelCmd.CommandText = "SELECT * FROM [" + strExcelSheetNames[x] + "]";
excelCmd.CommandType = CommandType.Text;
excelCmd.Connection = excelCon;
excelAdapter = new OleDbDataAdapter(excelCmd);
excelAdapter.Fill(dtExcelConvert);
}
I'm having an issue with the number columns however, if the number in the xlsx file is 612561120001 and it's displayed as 6.12561E+11 when i read it from the data table and convert it to a number it appears as 612561120000. I have tried to convert the file to a csv file and read it in but they're comma's in a lot of the fields which cause issues when splitting the data.
View 2 Replies
Jun 6, 2010
Error:
Executed as user: MACSTEELUSA.COMsa. ...9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:17 PM Error: 2010-06-02 20:00:18.56 Code: 0xC0202009 Source: CRM_ORACLE_ARSUMMARY Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle client
and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.". End Error Error: 2010-06-02 20:00:18.58 Code: 0xC020801C Source: Data Flow Task Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireCon... The package execution fa... The step failed.
Tasks Taken:Went to this folder checked for tnsnames.ora file but it is in good shape.
C:ORACLEproduct11.2.0client_1
etworkadmin
View 2 Replies
Dec 6, 2010
I have a serious problem with "Error on Page". The error message points to line number 939, char 13. In my code behind (C#) in line number 939 is only an obsolete method found which is no longer called. The aspx file has only 339 lines. What the heck is line number 939?The Webapplication allows a special user group to change some group memberships for members of another user group in Active Directory. The App handles 3internal DataViews derived from corresponding DataTables as DataSource for 3 GridViews and some other internal lists with objects (List<obj>).
It uses windows authentication to get current users credentials and his membership in the "Operators" group. This credentials will be passed-through to allow the process managing group memberships in active directory.After starting the App in browser it seems to work fine. But after an indeterminated time it doesn't longer respond. After each click on buttons (or link buttons) you only can see the message "Error on Page" in the browsers status bar below.I played with session timeout, storing the DataTables in session variables, without success.
Last week I found this article here: [URL]" and I addedEnableEventValidation="false" ViewStateEncryptionMode="Never"
to Page declaration. However, at some point the the server does not respond. Each time the worker process on webserver recycles it seems the application turn to wrong state. Might be important: All controls including GridViews are embedded in an AJAX UpdatePanel. How to get a better error message? Debugging is enabled and Custom Error handling On, Off or Remote Only brings the same result as described.
View 3 Replies
Nov 14, 2010
When a server error occurs for whatever reasons (YSOD), the server will send a message via SMTP class. In my case, my company employs microsoft exchange and uses NTLM authentication for all domain users. I am authenticating users via NTLA windows integrated authentication. My question is, is it possible to utilize this authentication data, and pass it to the system.web SMTP username/password authentication scheme to send an email to me (the web developer) when the error occurs? I am pretty sure my company requires a username/pwd to send emails via SMPT on the ms exchange server.
View 1 Replies
Oct 22, 2010
I'm receiving the following error occasionally when calling web service using a .NET 4.0 web application."The underlying connection was closed: An unexpected error occurred on a send."All of the articles I've read regarding this issue are for the Framework 1.1.Is there any solution to this issue for using .NET framework 4.0?
View 1 Replies
Aug 23, 2010
I am consuming a third party web service wsdl using my .net aps.net page. And I am getting following error message. Cannt get to resolve it. Its working on my machine but not in my development machine. I have installed the certificate also in certificates on that machine.
Error --> The underlying connection was closed: An unexpected error occurred on a send.
View 3 Replies
Aug 16, 2010
i write a site and get this error, i using VS2010.
An error occurred during local report processing.
The definition of the report 'ModulesReport1.rdlc' is invalid.
An unexpected error occurred in Report Processing.
Could not load file or assembly 'Microsoft.ReportViewer.ProcessingObjectModel, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
i try run on my machine its all work fine, but when i complier and run it on Window server 2008 get this error.
I read [URL] I install the ReportViewer.exe but still cannot find the Microsoft.ReportViewer.ProcessingObjectModel.dll, however I got find it Microsoft.ReportViewer.ProcessingObjectModel in C:Windowsassembly and is not a dll file.
View 1 Replies
May 25, 2010
I am REALLY stuck with this and need a solution in the next 24 hours .i I have uploaded my asp.net web application to the web and have the database and connection strings functioning and reading the data from the database. But when I try to write to the DB
I get the following error :
Server Error in '/' Application.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
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: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that
SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
The wierd thing about this is the connection strings work from the local machine when I run from Visual Studio and I can write to the DB there, I just cannot write to the DB from the URL.
I am pretty new to asp.net but I am sure it has to be something to do with the web.config.
View 5 Replies
Mar 31, 2011
I have an asp:BulletedList controls with AJAX:PagingBulletedListExtender on my aspx page.
It gives error as: Microsoft JScript runtime error: Sys.ArgumentException: Value must not be null for Controls and Behaviors. Parameter name: element
If I removed, the asp:BulletedList controls and AJAX:PagingBulletedListExtender from my page then page run without any error.
I am not getting the cause of the error.
View 3 Replies
Apr 15, 2010
im working with visualstudio 2005 and sql server 2005 c#,and i tried to insert an items to the sql but it gave me this error
Application server error '/ WebSite6'.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_StudentToCourse_Students".The conflict occurred in database "TopseaUser", table "dbo.Students", column 'id'.
The statement has been terminated.Description: The exception is unhandled occurred during the implementation of the current web request. the stack trace for more information about the error and where the source code.
Details exception: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_StudentToCourse_Students". The conflict occurred in database "TopseaUser", table "dbo.Students", column 'id'.The statement has been terminated.
This error: Line 243: sql_comm.Parameters.AddWithValue ("@ studentId", Convert.ToInt32 (id));
Line 244: sql_comm.Parameters.AddWithValue ("@ CourseId", Convert.ToInt32 (ListBox3.Items [j]. Text.ToString
()));
Line 245: sql_comm.ExecuteNonQuery ();
Line 246: split_listbox2 ();
Line 247: sql_conn.Close ();
Source File: c: Documents and Settings Ronen My Documents Visual Studio 2005 WebSites WebSite6 SiteMembers CourseSignUp.aspx.cs line: 245
this it the code :[Code].... !
View 7 Replies
Feb 24, 2011
I have an existing project with a silverlight3 app. First I created SALESservice.svc.This is working fine. Now I added another TARGETservice.svc to my project and rebuilded my entire project but when I am trying to add the service reference in to the silverlight app I get the following error:
There was an error downloading metadata from the address.verify that you have entered a valid address. I didn't write any code in ISALESservice.svc AND ITARGETservice.svc . I have written in SALESservice.svc.cs AND TARGETservice.svc.cs files.Is this causing error? But for SALESservice.svc it is working. I didn't add any code in web.config file.
View 1 Replies
Apr 22, 2010
<%# Eval("NAME").ToString() == "Edit" ? %>
<asp:ImageButton ID="imgEdit" runat="server" ImageUrl="../icons/icoedit.png" CommandName="Edit" CommandArgument='<%# Container.DataItemIndex %>' />
Error: Compiler Error Message: CS1525: Invalid expression term ',
View 2 Replies
Jun 28, 2010
I have got a problem tesing paypal sandbox IPN. i have got this error message: IPN delivery failed. HTTP error code 500: Internal Server Error
I could not find out what this error means.
View 1 Replies
Mar 7, 2011
I'm having a wicked time trying to redirect the different error scenarios to a custom error page. Basically, I have put some code in Application_Error in global.asax, and done the necessary web.config settings to use Custom Errors.
In global.asax on Application_Error, I stored the Server.GetLastError in Session. The reason I have to store it in Session is because (as far as I know) you lose the exception when using "ResponseRedirect". And the reason I have to use ResponseRedirect is because I am using an UpdatePanel with AJAX calls, and any exception during the AJAX call shows up as a JavaScript error, and doesn't get handled using the custom error page (see this post).
void Application_Error(object sender, EventArgs e){ ////must perform this check to avoid the "Session state is not available in this context" errors if (HttpContext.Current.Session != null) { Session["LastException"] = Server.GetLastError(); } else { // (I think this happens when there are compile-time errors) Server.Transfer("~/Oops.aspx"); }}void Session_Start(object sender, EventArgs e){ //must perform this check to avoid the "Session state is not available in this context" errors if (HttpContext.Current.Session != null) { //initialize the session (http://forums.asp.net/t/1405077.aspx) Session["LastException"] = ""; }}
View 3 Replies
Jan 31, 2010
I have uploaded all files to my server. and while im checking the site it shows the following error." Server Error in '/' Application. Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster,ensure that <machineKey> configuration specifies the same validationKey"what i have to do/how to fix it.
View 3 Replies
Jan 19, 2011
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
when i upload my site on webserver and connect with remote sqlserver2005 using connection string....
<connectionStrings>
<remove name="ConnectionString"/>
<add name="ConnectionString" connectionString="Data Source=69.16.253.19,1433;Initial [code]...
it shows an error above ..i m using aspnetdb.mdf in my website in APP_Data Folder... features i use in my website is Login Control, Password recovery, signup control...
View 2 Replies
Mar 24, 2010
I have written some vb code that inserts whatever has been written on my page into an Access database. Only problem is VWD throws up an error saying that the syntax of my SQL statement is wrong. I am 95% sure that this statement is correct because when I saw the statement in Text Visualizer and tried that statement in MYSQL the data went in perfectly.
I have pasted the code below:
strSQL = "INSERT INTO User (UserID, FirstName, LastName, Password) VALUES "
View 27 Replies
Aug 7, 2010
I have hosted a service in the IIS server, while consuming the service i am getting some error. I have mentioned the error code below.
Error code:
Server Error in '/' Application.
The type 'EchoTunnelService.EchoService', provided as the Service attribute value in the ServiceHost directive could not be found.
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.InvalidOperationException: The type 'EchoTunnelService.EchoService', provided as the Service attribute value in the ServiceHost directive could not be found.
Source Error: [Code]....
Version Information: Microsoft .NET Framework Version:2.0.50727.3607; ASP.NET Version:2.0.50727.3614
View 1 Replies
Aug 12, 2010
I am trying to Upload data from Excel file. Transfer data from Excel file to XML file and passed it to Store procedure. And insert the record into database.I also set the timeout for command to zero. when i upload 1 to 500 rows its working fine and when I upload the 10000 rows than its takes time but upload all the users successfully at localhost. But when I upload the code to remote srever,than its only upload upto 300 or 400 rows.After uploading these users it will gives the error of Request Time Out . Even more if I tried to upload 50000 rows its give me the error of 'Maximum Length Exceeded'. Can anyone tell me what the maximum size of Excel sheet to upload the users. How I can get rid of the Request Time Out Issue. How I can Increase the server response time.
View 4 Replies
Mar 8, 2011
All the examples and websites i have looked at redirect a user to the error.aspx page when an error occurs. How do you just display a friendly error message on the page the user is viewing saying something like "Sorry unable to do whatever" I've tried using a try catch block on my class that executes a stored procedure and put another try catch on the controller, but this does not work and i still get the default error message (System.InvalidOperationException was unhandled by user code) My code is below:
[Code]....
So how can i just return ViewData["SqlError"] message in page.
View 7 Replies
Feb 4, 2010
I want to redirect to Error.aspx page if runtime error occurs.How to acomplish this task.
View 8 Replies
Dec 11, 2010
I'm working on a page that uses a master page. In the master page, I have a drop-down and when a value is selected I generate an evenIn the web page, I have this statement "Addhandler Master.FilterChanged, AddressOf FilterChangedFromMasterPage"Everything works fine, and can edit the page as much as I want, but only with the Source view - because if I look at the design view, the entire MainContent section is reduced to this error; "Error Creating Control- MainContent / Object Reference not set to an instance of an object"But if I debug it locally, or FTP it to the server, it works just fine!
View 1 Replies
Jan 19, 2010
I am generating reports using localreport. It all works fine on my local machine but throws following error when deployed to dev/test/prod servers:
An error occurred during local report processing.
The definition of the report 'Main Report' is invalid.
The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1.
The code files are same on local as well as on the servers. What am I missing here?
View 3 Replies
Feb 10, 2010
I have been using the RemotePost Class( as per http://www.jigar.net/articles/viewhtmlcontent78.aspx) to post a form to a pay provider, for about 3 months successfully, I made some changes external from the call to this class that sent an email when user presses the button to notify us that the user has selected to go through to the pay provider (similar to PayPal). and suddenly got an exception error MSCROLIB, Thread was being aborted. I have since removed the code and I still get the error it happens when I call
[Code]....
I tried the suggestion on KB article [URL]/ but the control is not past to the Pay Provider I also took the actual response that is written and posted it to a new html file added a submit button and it works. So I am no stuck. The Pay provider claims they have changed nothing, and has tried to help but says they are receiving no input from either our dev site or the live site.I also tried to step into the call but it just throughs the exception
View 4 Replies