I'm trying to update a gridview using checkboxes (to allow user to remove multiple rows if needed)
In my Page_Load I have:
[Code]....
And then I have a UPDATE button that runs the following code:
[Code]....
I am developeing web application using csharp. The the code is reading the text file load on to Gridview, but when I run the the code it is giving me the error as "Index was outside the bounds of the array."Where I am going wrong. The code and records are as follows:
[Code]....
Records on Text File
6/5/2010,Bun,2010,H,20,50040
6/5/2010,BUG,2010,G,26,90000
16/5/2010,COT,2010,B,26,45040
I have it working on many other pages on my site, i created a new page and setup like the other pages adn on this page getting error.
[Code]....
Index was outside the bounds of the array.
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.IndexOutOfRangeException: Index was outside the bounds of the array.
[Code]....
Stack Trace:
[Code]....
[IndexOutOfRangeException: Index was outside the bounds of the array.] _Default.SortDropDownList(DropDownList ddl) +107 _Default.Submit_Click(Object sender, EventArgs e) +111 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
I have a problem with my site created with Share Point Portal. This morning I launched a specific link I came out this error: Index was outside the bounds of the array.Server Error in '/_layouts/incident' Application. Index was outside the bounds of the array. 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.IndexOutOfRangeException: Index was outside the bounds of the array. Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[IndexOutOfRangeException: Index was outside the bounds of the array.]
Incident.ActionResponse..ctor(SPListItem item) +290
Incident.ActionResponseCollection..ctor(SPWeb web) +96
Incident.Incident.Page_Load(Object sender, EventArgs e) +1089
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573
Index was outside the bounds of the array.
private void PopulateWallPosts(string userId)
{
using (OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=gymwebsite2; User=root; Password=commando;"))
{
[Code].....
Exception Details: System.IndexOutOfRangeException: Index was outside the bounds of the array.
Source Error:
[Code]....
Source File: C:le4-29-2010LinkExchangeradminpurge_banned_sites.aspx.vb Line: 26 I am confused. Why is this happening? I need an array of integers for 2 columns for later on when I go back and perform clean up. Both are primary keys for two tables. Why is thing tripping at my first record?
[Code]....
i create registration form in asp.net & sql server..after fill up form when i click save button it's show error..here is my code :-
private void ExecuteInsert(string AccNo, string CompanyName, string Desc2, string RegisterNo, string Address1, string Address2, string Address3, string Address4, string PostCode, string DeliverAddr1, string DeliverAddr2, string DeliverAddr3, string
[code]...
I know exactly what causes this, but have been unable to find a solution that doesn't involve looping. I've created one DataTable and numerous DataViews of said DataTable, with each DataView bound to a control. A dynamically created array controls how the dataview rows are filtered, but I have a hard coded number of DataViews. If the number of Dataviews is greater than the number of elements in the array, the code errors out with "Index was outside the bounds of the array". And it should, because it is outside the array. I would just like to check if the element exists before I attempt to use it. Code looks like this (where eid is dynamically created array of employee ids):
dv0 = New DataView(grpData)
dv0.RowFilter = "employee_id = " & eid(0) & ""
DayPilotCalendar1.Visible = True
DayPilotCalendar1.StartDate = New DateTime(2010, 2, 3)
DayPilotCalendar1.DataSource = dv0
DayPilotCalendar1.DataBind()
What I need is something like this:
If (not array.exists(eid(0))) then
dv0 = New DataView(grpData)
dv0.RowFilter = "employee_id = " & eid(0) & ""
DayPilotCalendar1.Visible = True
DayPilotCalendar1.StartDate = New DateTime(2010, 2, 3)
DayPilotCalendar1.DataSource = dv0
DayPilotCalendar1.DataBind()
End If
I don't need to know the values of anything in the array, I just need to not use eid(4) if the last element in the array was eid(3), if that makes sense. array.exists may not be in any way what I need here. It is just an example of how I would like it to work. If array.exist does happen to work, I haven't found the right syntax.
i am fighting alot with reorderlist today. So far, i seem to be loosing. I can't seem to get it to work, when i bind directly to my sqldatasource. Instead, i have tried to feed it a datatable, and bind on pageload. BUT, when i do a reorder, that affects the 1st entry in the list, it tells me the index was outside the bounds of the array.
View 2 RepliesI'm trying to merge vintasoft barcode sdk with my data access dll and it's not working after ilmerge.
here is the error:
IndexOutOfRangeException: Index was outside the bounds of the array.]
2.┌.©(Byte[] param0) in :0
2.┌..cctor() in :0
[code]...
I have a simple application with a GridView bound to a LinqDataSource and a DetailView that displays a row from the GridView when it's selected. This works as expected. But now I'm placing the GridView and DetailView in separate TabPanels in an asp.net ajax Tab Control.
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<asp:TabContainer ID="CourseFinder" runat="server" ActiveTabIndex="0">
<asp:TabPanel ID="ResultsTab" runat="server" HeaderText="Results" >
</asp:TabPanel>
<asp:TabPanel ID="DetailTab" runat="server" HeaderText="Detail">
</asp:TabPanel>
</asp:TabContainer>
and my code behind file
protected void Page_Load(object sender, EventArgs e)
{
CourseFinder.Tabs[0].Controls.Add(Results);
CourseFinder.Tabs[1].Controls.Add(DetailsView1);
}
When I run the page I'm getting
[ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index]
System.Collections.ArrayList.get_Item(Int32 index) +7483656
System.Web.UI.WebControls.GridViewRowCollection.get_Item(Int32 index) +13
_Default.Results_SelectedIndexChanged(Object sender, EventArgs e) in c:Documents and
SettingsAdministratorMy DocumentsVisual Studio
2008WebSitesWebSite1Default.aspx.cs:35
The line of code getting the error is the one attempting to get the SelectedIndex from the GridView and update my DetailView.
GridViewRow row = Results.Rows[Results.SelectedIndex]; I stepped through the code with the debugger and SelectedIndex is not negative and it's not larger than the number of rows in the GridView. So I'm confused why simply placing the controls inside a Tab is causing this error?
I add all row [Code].... in my [Code].... helping with this [Code].... Here is my [Code]....
[Code]....
But when i do that, getting strange error like this;
i use objectdatasource control for bind record and also in gridview paging.in my gridview there is a linkbutton(edit) when i click it then it redirect to next page with some key value.but problem is when i try to paging in gridview an error is occure that is Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
protected void grdClassList_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow row = grdClassList.Rows[Convert.ToInt32(e.CommandArgument)];//error
[code]...
I have used to code below successfully to export a gridview to an excel spreadsheet, however when i use it for a gridview with data from a different table i receive the following error:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
The thing is it works locally fine but when i upload to my shared server i receive the error above?
how to resolve/troubleshoot this?
aspx file:
[Code]....
code behind button click:
[Code]....
This is my code for checking the spelling written in text box is correct or not.
But it is not working, it is not executing and if (readingPos[k] == TextboxPos[k]) in this line giving error index is out of bond array.
protected void Button2_Click(object sender, EventArgs e)
{
string j = TextBox1.Text;//TextBox1.Text =
_dictionary(j) ;
}
public string _dictionary(string word)
{
string[] wordArray = new string[125896];
string reading;
int nwords = 0;
FileStream fs = new FileStream(@"C:Documents and Settingsharsha.limayeDesktopspelling.txt", FileMode.Open, FileAccess.Read);
StreamReader s = new StreamReader(fs);
while((reading=s.ReadLine())!=null)
{
char[] TextboxPos=reading.ToLower().ToCharArray();
char[] readingPos = new char[20];
readingPos = TextBox1.Text.ToLower().ToCharArray();
if (TextboxPos[0] == readingPos[0])
{
//int[] save = new int[20];
int save = 0;
for (int k = 1; k < reading.Length; k++)
{
if (readingPos[k] == TextboxPos[k])
{ }
else
save += k;
}
if (save !=0 && save < 3)
{
TextBox1.Text = "Search for this" + reading;
break;
}
}
wordArray[nwords] = reading;
nwords++;
}
I have gridview control. visit [URL] but when i change page index of this i get error the following error
Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.
somehow I broke this b/c it was working... I've got a gridview with a standard delete button. here is the top of the gridview:
[Code]....
and here is the SQL source:
[Code]....
here is my rowdeleting event:
[Code]....
the error: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index happens after that on line 31 of ss.gv_NotificationDetails
[Code]....
interestingly if I add more columns to the datakeynames, the error moves up one line to e.Values(0unfortunately I do not remember everything I have changed since the last time I tested this.
I get the error:
Index was out of range. Must be non-negative and less than the size of the collection.
when vieing a page with a datalist on it. i have other controls in the datalist. what would cause this? here is my code behind.
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
Label theiruseridLabel = DataList1.Items[0].FindControl("theiruseridLabel") as Label;
HyperLink hp2 = DataList1.Items[0].FindControl("HyperLink2") as HyperLink;
HyperLink hp3 = DataList1.Items[0].FindControl("HyperLink3") as HyperLink;
Label Label1 = DataList1.Items[0].FindControl("Label1") as Label;
string userName = theiruseridLabel.Text;
ProfileCommon userProfile = System.Web.Profile.ProfileBase.Create(userName, true) as ProfileCommon;
hp2.Text = userProfile.FirstName;
hp3.Text = userProfile.CompanyName;
Label1.Text = userName;
}
I recently had to remove a field from my datakey on all three gridview tables. On the top level table the field (ignum) remains as a non key field. On the two lower level tables it was removed completely. Now, the top level gridview opens correctly, but when I click on select this should bring up all the records in the second gridview associated with the selected row in the first gridview, but I get the following error:
[Code]....
I've looked at everything I can thing of and everything looks ok. The tables look good, I've removed all references to the removed field and I've restructured all the code to account for the changes. I'm missing something, but I don't know what. I've gone through debug step by step and the error occurs as I leave the GridView1_SelectedIndexChanged code. It goes down to the End Sub line with no errors, but when I step again it errors out. Here is that section of code.
[Code]....
Server Error in '/EBOOKS' Application.
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
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.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Source Error:
Line 61: Dim favorname As String = GridView1.DataKeys(row.RowIndex).ToStringLine 62: Line 63: ' Pass the value of the selected Employye ID to the Delete //command. My coding as
Protected Sub btnMultipleRowDelete_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnMultipleRowDelete.Click
' Looping through all the rows in the GridView
For Each row As GridViewRow In GridView1.Rows
Dim checkbox As CheckBox = CType(row.FindControl("cbRows"), CheckBox)
'Check if the checkbox is checked.
'value in the HtmlInputCheckBox's Value property is set as the //value of the delete command's parameter.
If checkbox.Checked Then
' Retreive the Favorname
Dim favorname As String = GridView1.DataKeys(row.RowIndex).ToString
' Pass the value of the selected Employye ID to the Delete //command.
SqlDataSource1.DeleteParameters("Favorname").DefaultValue = favorname.ToString()
SqlDataSource1.Delete()
End If
Next row
End Sub
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"
Width="563px" AutoGenerateColumns="False">
<RowStyle CssClass="fontsmallthennormal" />
<HeaderStyle CssClass="fontnormalblue8" />
<EditRowStyle CssClass="fontsmallthennormal" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="cbRows" runat="server"/>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Favorname" HeaderText="Favorname" SortExpression="Favorname" />
<asp:BoundField DataField="FavorDate" HeaderText="FavorDate" SortExpression="FavorDate" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1"
ConnectionString="<%$ ConnectionStrings:yyyy %>"
runat="server" SelectCommand="SELECT [US], [Favorname], [FavorDate] FROM [TBL_FAVORITES] WHERE ([US] = @US)"
DeleteCommand="DELETE from TBL_FAVORITES where [Favorname]= @Favorname"
>
<SelectParameters >
<asp:ControlParameter ControlID="txtusername1" Name="US" PropertyName="Text" Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="Favorname" />
</DeleteParameters>
</asp:SqlDataSource>
i have erro in this code Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
Asp.net control gridview
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace WebApplication2
{
public partial class _Default : System.Web.UI.Page
{
string query, strcn;
public SqlConnection cn;
public SqlDataAdapter da;
public DataSet ds;
private void fill()
{
string strc = "Data source =V_v_S-PC; initial catalog=Entry; User Id=sa; password=sa;";
cn = new SqlConnection(strc);
cn.Open();
string strq = "Select*from th";
da = new SqlDataAdapter(strq, cn);
ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
fill();
}
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
fill();
}
protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
{
// GridViewRow row = (GridViewRow)GridView1.Rows[e.AffectedRows];
// TextBox textID = (TextBox)row.FindControl("textbox3");
//TextBox textEname = (TextBox)row.FindControl("textbox4");
//GridView1.EditIndex = -1;
//cn.Open();
//SqlCommand sc = new SqlCommand("update e set Ename=" + textEname.Text + " where Id=" + textID.Text + "", cn);
//sc.ExecuteNonQuery();
}
protected void TextBox3_TextChanged(object sender, EventArgs e)
{
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
//int iKey = Convert.ToInt16(gv.DataKeys[e.RowIndex].Values["MovieId"]);
//string TaskID = grdTask.DataKeys[e.Row.RowIndex].Value.ToString();
int ike = Convert.ToInt16(GridView1.DataKeys[e.RowIndex].Values["Id"]);
TextBox tex = (TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0];
string idne = tex.Text;
strcn = ConfigurationManager.ConnectionStrings["SachinConnectionString"].ConnectionString;
cn = new SqlConnection(strcn);
cn.Open();
query = "update e set Ename='" + idne + "' where Id= " + ike + " ";
//string strUpdate = "update tbl_Movie set MovieName='"+strMovieName+"' where MovieId="+iMovieId+"";
SqlCommand com = new SqlCommand(query, cn);
com.ExecuteNonQuery();
GridView1.EditIndex = -1;
fill();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
fill();
}
}
}
I am invoking GridView1 RowCommand and updating table but getting null value error or index out of range.
here is my code:
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Primary")
{
[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.
gvOff.DataSource = o.ViewData(dCity.SelectedValue);
gvOff.DataBind();
gvOff.Columns[0].HeaderText = "ZZZZZZZZ";
gvOff.Columns[1].HeaderText = "YYYYYYYY";
gvOff.Columns[2].HeaderText = "XXXXXXXX";
Header count is correct.
AutoGenerateColumns: Flase/True ( i tried both)
If i remove the gvOff.Columns[index].HeaderText portions, GridView works fine, but when i put the gvOff.Columns[0].HeaderText, i get the exceptional error.
, i couldn't solve it. If you need further info, inform me.
EDITED:
Hold on! I commented the HeaderText portion and tested
int i = gvOffer.Columns.Count;
I found count is 0 eventhough the columns print out with DataBind()... Why?
NOTE: AutoColumn in this case is set to true. I guess i will have to edit the column
names from DataTable.
