ADO.NET :: Getting The Error "System.IndexOutOfRangeException:"?
Aug 4, 2010I am getting the following error and .Net master how to solve or getrid from this error
eg: datareader["ColumnName"];-----------------> i am getting error on this line
Similar Messages:
ADO.NET :: Read CSV Using Linq - System.IndexOutOfRangeException
Oct 19, 2010I'm trying to get data from a CSV file and add it directly into a database using Linq.
I'm using the following code:
[Code]....
The code works if I remove all the but the first property e.g.
[Code]....
But then I get the old "System.IndexOutOfRangeException: Index was outside the bounds of the array." exception when adding more columns.
Web Forms :: System.IndexOutOfRangeException: There Is No Row At Position 0?
Jan 19, 2011I am getting this error"System.IndexOutOfRangeException: There is no row at position 0." same code and concept working fine in 2 websites i could not able to solve this,only difference between current implementation and earlier implementation database,previously i used MySql database and now Ms-Excel data.I debugged data set is retreiving Code
Protected Sub chkSelect_CheckedChanged(ByVal sender As Object, ByVal e As
System.EventArgs)
Dim indx As Integer
Dim strExcelConn As String =
[code...]
Forms Data Controls :: System.IndexOutOfRangeException Was Unhandled By User Code
Nov 30, 2010I'm trying to do a master-detail by first search the database when a user click on the search button. Then display the result to a ListView control. After that, if the user click on the hyperlink, it displays the detail on the Formview control. Below are my code:
[Code]....
And here's the part that causes the error:
[Code]....
The error is on this line: string strID = ltvLusHmoob.DataKeyNames[e.Item.DataItemIndex].ToString();
DataSource Controls :: IndexOutOfRangeException Error / How To Fix It
Jan 27, 2010Can anyone tell me why I get this error:
I'm trying to output my query results:
SELECT * FROM sites LEFT JOIN pages ON sites.siteid=pages.siteid LEFT JOIN subpages ON Pages.pageid=subpages.pageid WHERE sites.siteID = 1 ORDER BY sites.siteid ASC
using the code:
[code]....
Source Error:
[Code]....
Line 35: Line 36: While reader.Read()Line 37: mydata &= reader.Item("sitename") & " " & reader.Item("pageid") & " " & reader.Item("pagetitle") & "<br>" & reader.Item("subpages.pageid")Line 38: Line 39:
AJAX :: Ajaxtoolkit - Debug Error Could Not Load Type System.Web.UI.ScriptReferenceBase' From Assembly System.Web.Extensions
Dec 15, 2010i have installed ajaxtoolkit 3.5 but when i debug i am getting this error Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' even i have changed my tags to
<asp:ToolkitScriptManager
ID="ToolkitScriptManager1"
EnablePartialRendering="true"
runat="server"></asp:ToolkitScriptManager>
C# - IndexOutofRangeException Occurred?
Oct 12, 2010I am getting 'indexOutofRangeException occurred' error - 'FixedActual'
SqlDataReader dataReader = null;
SqlCommand Scmd = new SqlCommand("SalesGetRecalcOrderItemCosts", this._connection);
Scmd.CommandType = System.Data.CommandType.StoredProcedure;
[code]...
Error : The Entry 'asp:System.Web.UI:System.Web.Extensions / How To Fix This
Jan 27, 2011We are working on a web application and the target deployment includes Windows 2003 64-bit. When we run the application on the 64-bit OS, it gives the following error:
The entry 'asp:System.Web.UI:System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' has already been added
The web.config file includes the following:
<pages validateRequest="false" enableEventValidation="false" viewStateEncryptionMode="Never" theme="esl_theme">
<controls>
<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
</controls>
</pages>
And if we remove the line <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>, it seems to work.
Can somebody understand the problem and take corrective action? The application does not compile on 32-bit OS without this.
Web Service Returns IndexOutOfRangeException With Arguments?
Dec 15, 2010I have the following web service:
[ScriptService]
public class Handler : WebService {
[WebMethod]
public void method1() {
string json = "{ "success": true }";
System.Web.HttpContext.Current.Response.Write(json);
[code]...
The first method accepts a traditional html form post and response writes a JSON string to the page.The second method accepts a JSON value posted via AJAX and returns a serialized object.Both these methods work fine on their own but when put together in the same web service I get this error when calling method1:
System.IndexOutOfRangeException: Index was outside the bounds of the array.
When I remove the arguments from method2 they work.Can anyone suggest why this is happening?
Edit:The problem spans from the argument type of method2. If I change it to a string or simple data type it works fine.As Joel suggests it's probably because Dictionaries can't be serialized.This doesn't seem to affect my requests sent by ajax and only breaks direct form posts to this handler.Therefore my workaround is to put the form post handlers in a separate file by themselves.Not ideal but works for my application.
Avoid IndexOutOfRangeException Indexing DataReader Columns?
Feb 9, 2010I am having a little trouble with an 'IndexOutOfRangeException'. I think it is because when the code tries to get the DateModified col from the database it sometimes contains NULLS (the users haven't always updated the page since they created it).
Here is my code;
s = ("select datemodified, maintainedby, email, hitcount from updates where id = @footid")
Dim x As New SqlCommand(s, c)
x.Parameters.Add("@footid", SqlDbType.Int)
x.Parameters("@footid").Value = footid
c.Open()
Dim r As SqlDataReader = x.ExecuteReader
While r.Read
If r.HasRows Then
datemodified = (r("DateModified"))
maintainedby = (r("maintainedby"))
= (r("email"))
hitcount = (r("hitcount"))
End If
End While
c.Close()
I thought (after a bit of msdn) that adding;
If r.HasRows Then
End If
after adding I am still getting the same old IndexOutOfRangeException
(ps, I have tried datemodified as string / datetime)
Forms Data Controls :: ObjectDataSourceView.BuildDataObject Throwing IndexOutOfRangeException?
Jan 27, 2010I've got a FormView bound to an ObjectDataSource. The FormView/ODS selects and displays my data correctly but when I change the data and try to update,nothing (seemingly) happens.Stepping through the code and digging deeper into the stack trace and output window,I figured out that the following sequence of events happens:
- The ObjectDataSource drills down to System.Web.UI.WebControls.ObjectDataSourceView.BuildDataObject to create the object I specified in the "DataObjectTypeName" property
[code]...
- Here is where the IndexOutOfRangeException happens. Sometimes one or two of the data object's properties will be set, sometimes none. Either way, the exception is thrown and the sequence is stopped (the business object's update is never called).
- The exception is not thrown inside any of the properties' set methods.I'm assuming that the exception is happening when BuildDataObject is using Reflection to find my data object's properties (GetProperty() etc.. ). Since I can't see the source code of BuildDataObject and the debugger won't give me any more information, there is no way for me to see which property (if any) is causing this.I double checked the names and types of all 27 of the data object's properties.
Configuration :: Getting An Error "Parser Error Message: Could Not Load File Or Assembly 'System.Web, Version=4.0?
Aug 25, 2010I have created an application which runs fine in VS2010.Now i am trying to host that application using inetmgr.When i try to browse the page from inetmgr content view then i get the "Parser Error Message: Could not load file or assembly 'System.Web, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified".If i browse the page from VS i am able to do it.I am not able to host the app. may be the reason is the above stated error.
View 1 RepliesMVC :: System.Web.Mvc.ActionResult UpdateActingRoles() Error - How To Fix This Error
Jun 25, 2010This error is severely pissing me off
I have a main View which has an ActionLink that redirects to another View
[Code]....
This new view has a submit button
[Code]....
The problem is that when i click on "Update", i get the infamous No parameterless constructor defined for this object error in the controller. The Post Action is this:
[Code]....
Which it doesnt even get to! If i add a parameterless constructor:
[Code]....
I get the Ambigious error:
The current request for action 'UpdateActingRoles' on controller type 'EmployeeController' is ambiguous between the following action methods:
System.Web.Mvc.ActionResult UpdateActingRoles() on type ProjectY.Controllers.EmployeeController System.Web.Mvc.ActionResult UpdateActingRoles(ProjectY.ViewModels.Forms.ManageActingRolesViewModel) on type ProjectY.Controllers.EmployeeController
Using System.Web.Mail And System.Net.Mail - Error "MailMessage Is Ambiguous"
Dec 29, 2010We have a website which we have re-designed and coded to work using System.Net.Mail but other parts of our website use System.Web.Mail We have specified the namespaces to be used in our web.config file but as we are specifying both System.Net.Mail and System.Web.Mail and they both use MailMessage it throws an error 'MailMessage' is ambiguous, imported from the namespaces or types 'System.Web.Mail, System.Net.Mail'. Is there anyway to avoid this error and still use both namespaces?
View 2 RepliesSystem.EnterpriseServices.dll Error With .NET 3.5?
Jan 17, 2011I'm trying to create a test app to work out some code to connect to an Oracle database. The target project is in .NET 3.5 so that's the framework that I choose for the project. However, when I attempt to set that as the target framework and run the app, I get the error:
Server Error in '/' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS0006: Metadata file
'C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll' could not be found
Source Error:
[No relevant source lines]
Source File: Line: 0
Show Detailed Compiler Output:
Version Information: Microsoft .NET Framework Version:2.0.50727.3607; ASP.NET Version:2.0.50727.3614
I get this error when creating a test app both with Visual Studio 2008 Pro and 2010 Express Edition.
In 2010, if I don't change the target framework from .NET 4, the test application (default app and settings) works as expected. I've googled around for various other posts on this same error and have attempted their solutions to no avail. I've tried reinstalling .NET 2, but I can't get a dialog with an option to do so to appear. When I try to change the program settings, either the installer will load and then just exit, or it will load and tell me I can't uninstall.
System.IO.IOException: Unknown Error (-1).
Feb 16, 2010I'm getting this error when I'm trying to run a page that works on other servers. Having trouble finding much info on this error or possible solutions.As far as I can tell, the appicable permissions have all been set, on both the app folders and the framework folders. I've taken all the code out of the page to isolate
View 2 RepliesWhy Getting An Error For System.data.linq
Nov 15, 2010I've just used Visual Studio to create a linq to sql class. In the .designer.cs file the code includes:using System.Data.Linq;However, when I compile the projeget:Compiler Error Message: CS0234: The type or namespace name 'Linq' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)The code is completely generated by Visual Studio
View 5 RepliesWeb Forms :: Error: System.IO.FileNotFoundException
Feb 25, 2011I'm need to put the alarm sound in my webpage and trying to play .wav file and its throws an error.Error: System.IO.FileNotFoundException: Please be sure a sound file exists at the specified location.
SoundPlayer objSoundPlayer = new SoundPlayer();
Line 139: bjSoundPlayer.SoundLocation = "Roland-GR-1-12-String-Guitar-C4.wav";
Line 140: objSoundPlayer.Play();
I put the file under that same folder (inetpub/wwwroot/website1/.wav).Working in :localhost:5587/webiste1/default.aspx [no problem while exuting with port number]
VS 2008 Get The Following Error: System.NullReferenceException / How To Solve It
Jul 28, 2010I am having some issues accessing a literal in a usercontrol.
I get the following error: System.NullReferenceException: Object reference not set to an instance of an object. at page.sbPageLoad(String sTypeCD, Int32 iCategoryID, String SortExpression)
Does the following code below look right?
Here is my usercontrol named: topbanner.ascx:
Code:
[code]....
VS 2008 DataRow Error System.NullReferenceException?
Jul 26, 2010When I click on my btnMissionary_Click which is suppose to add a datatable row I am getting the following error:
System.NullReferenceException: Object reference not set to an instance of an object. If I add a entry right away it seems to work fine.
Here is my form
HTML Code:
<div id="container">
[code].....
SQL Bulk Insert And Operating System Error 3
May 14, 2010I have two servers. One is a web server and one is a sql server. What I'm trying to do is as follows: User uploads a document to a web site. File is stored on a web server in a directory, verified that it's a certain type of file, and saved. When the user presses a submit button, the page is uploaded and the Onclick event triggers a sql bulk insert (not on the same web server.) That's it in a nutshell. The basics of this page are done. The file can be saved but for whatever reason, I'm getting a Operating system error code 3(The system cannot find the path specified.) I've modified the machine.config on the web server to impersonate another user. I've made sure that the directory in question can be reached from both servers (and it can.) I can open/edit/delete the file from the directory from both sides, but evidently that's not the issue.
View 2 RepliesAfter Upgrading / Getting Contains Is Not A Member Of System.array Error
Aug 17, 2010I have a website I developed in VS 2008 targeting .net 3.5. It has worked well. I recently upgraded to VS 2010 and needed to make a few changes to the site. However, I'm receiving compile errors (haven't made any changes to the code yet--was just launching the site to make sure it worked ok). I get "Contains" is not a member of system.array. Everything I've read states that the contains method was added in .net 3.5, which I know to be correct because it was working in VS 2008. I've been targeting .net 3.5 in VS 2010, but it still isn't working. I also used linq quite a bit with linqkit to do dynamic queries and all of my linq queries were saying my queries weren't queryable (I don't have the actual error in front of me). Anyway, to fix that one, I had to import system.linq (I previously had system.data.linq and it was working fine). To reiterate, I haven't targeted my site to .net 4 in VS 2010, I've left it targeting .net 3.5.
I tried converting my arrays to arraylists since arraylists were still pulling up with a .contains method, but then it broke my linqkit queries when I ran it on the site.
Here is my linqkit query:
Dim str() As String = archlist.ToArray(GetType(String))
Dim str3 As New ArrayList
str3 = ArrayList.Adapter(str)
predicate = predicate.And(Function(l As CompatTesting) str3.Contains(l.application.cpuarchitecture))
Before, I didn't have the arraylist conversion, I just had str.contains and it worked great to generate a sql "in" statement. Now after using the code above, the site launches, but when I actually run the code, I get Method 'Boolean Contains(System.Object)' has no supported translation to SQL. I also tried upgrading my linqkit dll to the latest version but it didn't help.
My questions are, since I'm targeting the same .net 3.5 framework in 2010, why is it not allowing me to use array.contains anymore? Maybe if I can address that issue, it will fix my linqkit issue where it says "contains" has no supported translation to sql.
System.OutOfMemoryException: Out Of Memory Error / How To Solve It
Jun 1, 2010I just published my website to a server. Using this server I get the following error when I click on an image to view it:
System.OutOfMemoryException: Out of memory.
I didn't had the error when I worked on my local server.
Export To Excel : Getting Error / System.OutOfMemoryException
Jul 9, 2010I am facing a problem wherein, whenever I am trying to export a large recordset to excel (over 50k records) I am getting the System.OutOfMemoryException. I want to know a couple of things :
1. How do I handle this exception as try - catch does not seem to work?
2. I am pasting sample code. I just want to know if there is a better way of doing this :
[code]....
ADO.NET :: Getting Error - System.InvalidOperationException: Operation Is Not Valid
Mar 29, 2011I am using static class to do every job related to Database. In this class Connection Object is static but i am creating command object in the method. I read a form post here [URL] about creating connection object local. If we do like that how can we use Connection pooling? There is an example code below.
I am creating a connection object with pooling (Validate Connection=True; Min Pool Size=10; Max Pool Size=200; Incr Pool Size=10; Decr Pool Size=5;). I am expecting to use connection pool by static connection object (this obje has a connection poll) with dynamicly created commands. Am I wrong? Sometimes i am getting "System.InvalidOperationException: Operation is not valid due to the current state of the object." error. Is it because static connectin object?
[code]....
