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())
[code]...
I am bindibg data to a grid and in my asp page I have the following asp:HyperLinkField:
asp:HyperLinkField
DataNavigateUrlFields="serialno"
DataTextField="serialno"
HeaderText="serialno" DataNavigateUrlFormatString="DeviceDetails.aspx?serialno={0}"
/>
This is working perfectly, but when I add a second parameter to the querystring it does not work anymore:
DataNavigateUrlFormatString="DeviceDetails.aspx?serialno={0}&id={1}"This
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
validation to check the date greater and equal to the current date .
View 1 Replieshow to clear the GridView column greater than index 1.
grdview.Columns.Clear() will clear all columns, but i need to clear the columns greater than index 1
[code].....
why when I selected button select then it show index equal -1 in gridview ?
I have Created Menu by Passing SiteMap file.
[Code]....
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..
If I enter any number in a TextBox I want to open some .aspx page. I don't want to click on any button. How should I do this in asp.net?
View 1 RepliesI'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?
View 7 RepliesI am looking for help on how get a response if xxx does not equal xxx in VB.Net 2008.Here is my original code:
[code]...
Here is my code in SQL
[Code]....
Error i am facing is :
Msg 8668, Level 16, State 0, Line 2
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.
what is difference in cluster index and noncluster index?
which is faster?how many cluster index and non cluster index per table?
what is composite primary key?on how many columns we can create composite key?
hao many maximum composite key's we can create on one table?
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
<asp:TextBox ID="TextBox3" runat="server" MaxLength="50" Width="150px" Text='<%# Checkvalue(Eval("AustResident")) %>' />
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.
protected string Checkvalue(object obj)
{
if (obj != null)
{
if (obj.Equals("true"))
{
return "Yes";
}
else
{
return "No";
}
}
else
{
return "No";
}
}
we are using the PeterBlum SelectedIndexCondition to control whether or not some controls are displayed using the following snippet:
PeterBlum.DES.MultiFieldStateController fsc = new PeterBlum.DES.MultiFieldStateController();
PeterBlum.DES.SelectedIndexCondition cnd2 = new PeterBlum.DES.SelectedIndexCondition();
cnd2.Index = desiredIndex
cnd2.ControlToEvaluate = ControlToEvaluate//ListBox, dropdown, etc
fsc.Condition = cnd2;
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.
View 11 RepliesI'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
<asp:Button ID="mmGo" runat="server" Text="Merge" PostBackUrl="~/Default2.aspx?action=merge"/>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<%@ PreviousPageType VirtualPath="~/Default.aspx" %>
[code]...
Im creating a Report to see all I have sold to a Client, my SQL query looks like this
[Code]....
What I dont want is to get a list of repeted items, I want to sum all items that are equal. for exemple:
Current Situation:
[Code]....
What I want to acomplish
[Code]....
what are Keycodes for Less than (<) and greater than (>)? For example, keycode for "Enter" is 13. Please note that I am using C#.
[Code]....
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.
View 3 RepliesI 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?
View 3 RepliesThis expression is to check number > 1
^[1-9]+[0-9]*$
what is the expression to check if it's greater than a given value, say "99" ? what about a value less than, 99?
Update:
I'm using ASP.NET validation control.