I have the following error. Iam trying to put the method in try catch but still not sure what to put in catch. I am trying to make it thow an exception due to the folloing unspecified error.
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.
Line 282: directorySearcher.PropertiesToLoad.Add("cn");
Line 283: directorySearcher.PropertiesToLoad.Add("adsPath");
Line 284: SearchResultCollection computerCollection = directorySearcher.FindAll();
Line 285: foreach (SearchResult computer in computerCollection)
Line 286: {
I am facing some problem while uploading excel sheet upload and connecting it to dataset. The Code works fine in local machine but on website its showing following error.
System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnectionInternal
Below is my code:
string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName); string Extension = Path.GetExtension(name); string FolderPath = ConfigurationManager.AppSettings["FolderPathSMS"]; string FilePath = Server.MapPath(FolderPath + FileName); switch (Extension) { case ".xls": //Excel 97-03 s = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePath + ";Extended Properties='Excel 8.0;HDR={1}'"; break; case ".xlsx": //Excel 07 s = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties='Excel 8.0;HDR={1}'"; break; } EDT = new DataTable(); EDT.Columns.Add("MobileNo", typeof(string)); con = new OleDbConnection(s); con.Open(); // I am getting the error at this point da = new OleDbDataAdapter("select * from [Sheet1$]", con); ds = new DataSet(); da.Fill(ds);
Now i'm using visual studio 2008 for my web application project development. I had more than 80 forms and more than 20 modules include with it. Today morning i working with my applicatons normally. Suddenly i cant debug my applications but when i tried to run the webform by View in Browser option, The seperate form shows the page and output. And i cant dubug or Run my Whole project manually. When i tried to debug the applications, suddenly the below error pop-up will displayed without any debuging.
The Operation Could not be completed. unspecified error
I have an application that uploads an Excel .xls file to the file system, opens the file with an oledbconnection object using the .open() method on the object instance. The upload and writing of the file to the file system works fine but I get an error when trying to open the file on our production server only. The application works fine on two other servers (development and testing servers).
The exception comes on production server at connection.Open() some times, when I reset the asp.net worker process it started to work but after some hours/days It occurs again. how can I fix this issue which comes in production some times but very irritating, or there is some other work around.
I am developing one web application using MS Access database using oledb connection.Previously i checked the same application is works well in the same machine.Now Today i checked they provide "Unspecified Error". And also Provide the following Exception:
System.Data.OleDb.OleDbException: Unspecified errorat System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at clsOledbClass.opencon() in c:inetpubwwwrootcheckNPCApp_CodeclsOledbClass.cs:line 64
I am using the following connection string for connecting database:
I am creating an Asp.net web site which will support dynamic data. When I am creating a dynamic web site from Scratch (from template in VS) all is working fine. But when I am trying to add dynamic entity (.edmx) file and running the application I am getting following error
"The method 'Skip' is only supported for sorted input in LINQ to Entities. The method 'OrderBy' must be called before the method 'Skip'. "
I don't know what I'm making wrong.I have a submit button, and on click it should execute the funktion in the code behind, but I get the error that the funktion is undefined.this is my code in the .aspx webform:
I have seen 2 methods to handle error in project. One is using try catch in every method and another is using custom page and error log file .I know both method. Which one is the best method?
I added the extender and when i tried to add the method this message poped up; Cannot create page method "GetCompletionList" because no Code Behind or codefile was found.
What am I missing here; this should be straight forward, but when I attempt to access the "get_activeTabIndex()" method on my Tab Container's ID, I get the following error: "Object doesn't support this property or method"
This is using VS.NET 2010 with the AJAX Control Toolkit built for Framework 4, but I don't think anything was deprecated so this should not be an issue. I extract the ID of the control using serverside script variables, then attempt to access the method, but it fails. Take a look: [Code]....
Value 'tabCtrl' does indeed have value, as I can see it registers as an object (not NULL or Nothing) and ClientID resolves to the following: ctl00$ContentPlaceHolderMyApp$AJAXTabContainerNumData
I have the method 500 error problem, I have tried to do a simple reproduction of the problem still the same, if I run the webservice [URL] it returns the values needed ok (5) in xml format, but the dropdown always return error 500 inside, here are the codes (Using VS2008, NF3.5, Windows 7), I have the whole day trying to solve this but I just can't:
I downlaoded the sample code accompanying the "Cascading Drop Down Control to Access a Database" AJAX Toolkit video, and added the datasets from the sample code to my application running in VS2008 and AJAX 3.5. I think the sample code is in a prior version of AJAX.
When I ran my project I used to get Method Error 500 and after 2 days of searching the web could not get a solution. Finally by chance I recreated the datasets fresh in my app using the wizard as shown in the video and the error dissapeared and the cascading drop down worked beautifully.
I have a ProductService class that defines the following methods. It doesn't work, as I will explain further below, but it gives the compile error CS1061: 'ProductService' does not contain a definition for 'GetByid'. Unless I've dropped the ball on method overloading, why is the public overload of GetById not seen by other code?
I used this brilliant solution to convert a linq query to a datatable. But I'm getting a strange error when running it. Build succeeds though.
Compiler Error Message: CS0121: The call is ambiguous between the following methods or properties: 'Gruppkoll.App_Code.ConvertToDataTableFromLinqResult.ToADOTable<Gruppkoll.MessageSet (System.Collections.Generic.IEnumerable<Gruppkoll.MessageSet>)' and 'Gruppkoll.App_Code.ConvertToDataTableFromLinqResult.ToADOTable<Gruppkoll.MessageSet (System.Collections.Generic.IEnumerable<Gruppkoll.MessageSet>)'
I've tried re-building it and restarting the IIS. It seems as there are two classes with the same method but I've checked this and that's not the case. I'm using .NET 4.0 ASP.NET Webforms.
I am trying to get my cascading comboboxes to work, but am getting a [Method error 500]. Any ideas? I've searched online, the code should work....Thanks in advance for your help!
ADDSTORY.ASPX:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="addstory.aspx.cs" Inherits="addstory" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %> <form id="form1" runat="server"> <asp:ToolkitScriptManager ID="ScriptManager1" runat="server" /> <td class="style3"> <asp:DropDownList ID="selectproject" runat="server" Width="225"></asp:DropDownList> <asp:CascadingDropDown ID="ccd1" runat="server" ServicePath="~/dropdown.asmx?company=<%=co_id %>" ServiceMethod="GetProjects" TargetControlID="selectproject" Category="Project" PromptText="Select Project" /> </td> </tr> <tr> <td class="style3"></td> <td width = "150" class="style3">Iteration:</td> <d class="style3"> <asp:DropDownList ID="selectiteration" runat="server" Width="225"></asp:DropDownList> <asp:CascadingDropDown ID="ccd2" runat="server" ServicePath="~/dropdown.asmx?company=<%=co_id %>" ServiceMethod="GetIterations" TargetControlID="selectiteration" Category="Iteration" PromptText="Select Iteration" /> </td> </tr> DROPDOWN.ASMX: using System.Web.Script.Services; using AjaxControlToolkit; using System; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; using System.Collections.Generic; using System.Collections.Specialized; using System.Data.SqlClient; /// <summary> /// Summary description for WebService /// </summary> [WebService(Namespace = "[URL]/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. [System.Web.Script.Services.ScriptService()] public class dropdown : System.Web.Services.WebService { private string GetConnectionString() { return System.Configuration.ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString; } [WebMethod] public CascadingDropDownNameValue[] GetProjects(string knownCategoryValues, string category) { string co_id = this.Context.Request.QueryString["company"].ToString(); SqlConnection conn = new SqlConnection(GetConnectionString()); sonn.Open(); SqlCommand comm = new SqlCommand("Select ProjectName, ProjectID FROM Project WHERE CompanyID = '" + co_id + "'", conn); SqlDataReader dr = comm.ExecuteReader(); List<CascadingDropDownNameValue> l = new List<CascadingDropDownNameValue>(); while (dr.Read()) { l.Add(new CascadingDropDownNameValue(dr["ProjectName"].ToString(), dr["ProjectID"].ToString())); } conn.Close(); return l.ToArray(); } [WebMethod] public CascadingDropDownNameValue[] GetIterations(string knownCategoryValues, string category) { int ProjectID; StringDictionary kv = CascadingDropDown.ParseKnownCategoryValuesString(knownCategoryValues); if (!kv.ContainsKey("Project") || !Int32.TryParse(kv["Project"], out ProjectID)) { throw new ArgumentException("Couldn't find project."); }; SqlConnection conn = new SqlConnection(GetConnectionString()); conn.Open(); SqlCommand comm = new SqlCommand("SELECT Select CONVERT(VARCHAR(10), StartDate, 103) + ' - ' + CONVERT(VARCHAR(10), EndDate, 103) AS Iteration, ProjectIterationID FROM Iterations WHERE ProjectID=@ProjectID", conn); comm.Parameters.AddWithValue("@ProjectID", ProjectID); SqlDataReader dr = comm.ExecuteReader(); List<CascadingDropDownNameValue> l = new List<CascadingDropDownNameValue>(); while (dr.Read()) { l.Add(new CascadingDropDownNameValue(dr["Iteration"].ToString(), dr["ProjectIterationID"].ToString())); } conn.Close(); return l.ToArray(); } }
I currently facing a cascading drop down list problem. When I develop my website at local pc, everything work just fine. However I deploy it to server, I get Method Error 500.
Dim roommates = From p In dbroom.Residents _ Where p.room = queryStudent.First.r.id _ Where p.building = queryStudent.First.b.id _ Where p.year = year _ Where p.semester = term _ Select p.person_name
It currently returns no results. I was getting an error when attempting to bind this resultset (since it was empty) to a repeater in ASP.NET, so I attempted to escape it:
If roommates.Count() = 0 Then Dim nomates As String = "No current roommates." rptrRoommates.DataSource = nomates rptrRoommates.DataBind() Else rptrRoommates.DataSource = roommates rptrRoommates.DataBind() End If
But I still get the same error:
The method 'First' can only be used as a final query operation. Consider using the method 'FirstOrDefault' in this instance instead.
i created an asp.net "web application" in VS 2008, building on .NET 2.0 framework. i have a form page with a code behind file. the form is very basic: a table with some text boxes and radio buttons. here is a piece of the form:
I am implementing web service into my web application, i added web reference to my application of required web methods from my asmx file.
i am able to create object of this weservice and able to see all the web methods available from the reference object. In debug mode(working environment), i could invoke and get result from the webmethod and working fine as expect. i created test page for testing this.
But, when i deploy same in my beta i am getting below error.(my both test page and asmx file available in my beta server where i deployed)
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 138.108.18.207:80
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 138.108.18.207:80
I am binding dropdown list using Object data source. I got an error like this
"ObjectDataSource 'objDSStatus' could not find a non-generic method 'GetIssueAllowedStatusByCategoryIDStatusIDandUserType' that has parameters: IssueCategoryID."
My code is as follows .aspx
< asp:DropDownList ID="ddlStatus" runat="server" DataSourceID="objDSStatus" DataTextField="IssueStatusName" DataValueField="IssueStatusID"> < /asp:DropDownList> < asp:ObjectDataSource ID="objDSStatus" runat="server" TypeName="DA"></asp:ObjectDataSource> .cs private void Bind(int IssueCategoryID, int IssueStatusID, int UserType) { ddlStatus.Items.Clear(); objDSStatus.SelectMethod = "GetIssueAllowedStatusByCategoryIDStatusIDandUserType"; objDSStatus.SelectParameters.Clear(); objDSStatus.SelectParameters.Add("IssueCategoryID", IssueCategoryID.ToString()); objDSStatus.SelectParameters.Add("IssueStatusID", IssueStatusID.ToString()); objDSStatus.SelectParameters.Add("UserType", UserType.ToString()); objDSStatus.DataBind(); ddlStatus.DataBind(); } DA.cs public List<IssueStatus> GetIssueAllowedStatusByCategoryIDStatusIDandUserType(int IssueeCategoryID, int IssueStatusID, int UserType) { List<IssueStatus> issueStatusList = new List<IssueStatus>(); }
