C# - Index (zero Based) Must Be Greater Than Or Equal To Zero
Mar 15, 2011
I keep getting an error:Index (zero based) must be greater than or equal to zero and less than the size of the argument list.y code:
OdbcCommand cmd = new OdbcCommand("SELECT FirstName, SecondName, Aboutme FROM User WHERE UserID=1", cn);
OdbcDataReader reader = cmd.ExecuteReader();
while (reader.Read())
I get the following error during DataBind to a grid: [System.FormatException] = {"Index (zero based) must be greater than or equal to zero and less than the size of the argument list."} What does this mean? Is {1} not a string or is it because of something else?
If I want to validate that a text box contains an integer greater than or equal to zero. Do I need to use TWO asp:CompareValidator controls: one with a DataTypeCheck operator and one with a GreaterThanEqual operator?
Or is the datatype operator redundant? Can I just use a single validator with the GreaterThanEqual operator (and the type set to Integer)?
I want to retrieve all the records where the datetime is greater than or equal to 30 days ago. What is the correct formatting for this line: WHERE Property.dateadded >= NOW -30 days .. Dateadded field is in datetime format.
SELECT TOP (1) Property.Name, Property.Price, Department.DepartmentTitle, Images.ImageId, Property.DateAdded FROM Property LEFT OUTER JOIN Department ON Property.DepartmentId = Department.DepartmentId LEFT OUTER JOIN Images ON Property.PropertyId = Images.PropertyId WHERE Property.dateadded >= NOW -30 days
when i was accessing Menu Item Using this code i'm getting Count=0 and menu1.items[0] index is outof bound error..plz tel me how to resolve this problem..
I'm working on a project where we're using Windows Desktop Search (WDS) to index files on a web share and then later allow the user to search via a website for documents in the share.
These documents are transferred to the share via FTP, however it would seem that either the computer never goes idle to index or at some point the indexing stops. Is there a way from the command line or within the program itself to force this to happen without having to re-invent the wheel? Using .NET 3.5 and C#.
I try to compare Datetime.Now with a Datetime variable I set, using the Datetime.CompareTo() method. I use a timer to compare these every second and display the result, but as the current time approaches the time I set, the result changes from 1 to -1, but never 0, which means these two are never equal. I'm suspecting the Datetime structure contains milliseconds?
Cannot create the clustered index 'RateViewIndex' on view 'NoteToPass.dbo.RateView' because the select list of the view contains an expression on result of aggregate function or grouping column. Consider removing expression on result of aggregate function or grouping column from select list.
I have a simple method which takes an Object and return string "No" or "Yes". Basically I want to display "Yes" or "No" when a bool value of 0 or 1 is there
But everytime there is a 1 passed to the CheckValue which in the debug shows as true, It never evaluates being equal to "true" what am I doing wrong? My Checkvalue is always returning "No" no matter what I pass.
I'd like to be able to achieve this same functionality except to fire when the desired index IS NOT set. I cannot simply create a bunch of Conditions for each index other than the one I specify due to the way this is dynamically being done in my application.
I am trying to split a collection into multiple collections while maintaining a sort I have on the collection. I have tried using the following extension method, but it breaks them incorrectly. Basically, if I was to look at the items in the collection, the order should be the same when compared to the broken up collections joined. Here is the code I am using that doesn't work:
public static IEnumerable<IEnumerable<T>> Split<T>(this IEnumerable<T> list, int parts) { int i = 0; var splits = from name in list group name by i++ % parts into part select part.AsEnumerable(); return splits; } int parts = number of sub enumerables
I'm facing a problem that Google couldn't solve yet!I'm trying to store URLs in an XML file. Problem is that these URLs contain Equal Signs (=) in them. And that generates an error.Here is my code: (**token is a variable that contains the URL)
Dim child As String = vbCrLf & "<Link URL='" & token & "'></Link>" Dim fragment As XmlDocumentFragment = doc.CreateDocumentFragment fragment.InnerXml = child
The error message: (Error line and position are meaningless here) '=' is an unexpected token. The expected token is ';'. Line 2, position 133.I've replaced all '&' symbols with '&' in case they were the ones causing the error, but no luck so far.
I have a basic web form with about 5 textboxes. One Textbox is "Date1" and the other is "Date2." Is there a way to set the value of Date1 = Date2 after the user enters a value into the Date1 textbox? I'm using Visual Studion and C#. I'm not much of a programmer, so the less technical the better.
I'm trying to pass post data from one page to the next but PreviousPage always equals null.This is what I have in the original page (inside an updatepanel
I have ASP .NET page, and VB module. I have DropDownlist in the ASP page that retrieve information from SQL database. I am trying to make a string varaible equal the value of the dropdownlist selected.
I have a Sql query (I made it shorter for an example) belowselect top 4 Count (distinct[x].ProductID ) as [Count], y.Category as Category FROM [y] left OUTER JOIN [x] on [x].CategoryID = [y].CategoryID where x.MainID in (SELECT item FROM split(@MainID, ';')) group by y.Category order by Count descthe results will show all Categories with the Count next to it... I need to get the sql query to only get all the Categories with a Count greater then 10...How can I get this?.. .........what do I need to do to let the Sql Query work?