HOW TO CLEAR THIS ERROR Index was out of range. Must be non?

Question

HI

      HOW TO CLEAR THIS ERROR.plz help me.i can able to edit,cnt able to update

 

 error line:

 

// string stor_id = gridView.DataKeys[e.RowIndex].Values["[USER NAME]"].ToString();//

 

 *

 

 

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 53:         protected void gridView_RowUpdating(object sender, GridViewUpdateEventArgs e) Line 54:        

 { Line 55:             

string stor_id = gridView.DataKeys[e.RowIndex].Values["[USER NAME]"].ToString();

 Line 56:             TextBox stor_name = (TextBox)gridView.Rows[e.RowIndex].FindControl("txtname"); 

Line 57:             TextBox stor_address = (TextBox)gridView.Rows[e.RowIndex].FindControl("txtaddress");

 

 

my prgm:

 

<asp:GridView ID="gridView" runat="server"

AutoGenerateColumns="false" ShowFooter="true" HeaderStyle-Font-Bold="true"

onrowcancelingedit="gridView_RowCancelingEdit"

onrowdeleting="gridView_RowDeleting"

onrowediting="gridView_RowEditing"

onrowupdating="gridView_RowUpdating"

onrowcommand="gridView_RowCommand"

OnRowDataBound="gridView_RowDataBound" Height="363px" Width="1091px">

<Columns>

<asp:TemplateField HeaderText="USER NAME">

<ItemTemplate>

<asp:Label ID="txtstorid" runat="server" Text='<%#Eval("[USER NAME]") %>'/>

</ItemTemplate>

<EditItemTemplate>

<asp:Label ID="lblstorid" runat="server" width="40px" Text='<%#Eval("[USER NAME]") %>'/>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="instorid" width="40px" runat="server"/>

<asp:RequiredFieldValidator ID="vstorid" runat="server" ControlToValidate="instorid" Text="?" ValidationGroup="validaiton"/>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="EDC">

<ItemTemplate>

<asp:Label ID="lblname" runat="server" Text='<%#Eval("EDC") %>'/>

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox ID="txtname" width="70px" runat="server" Text='<%#Eval("EDC") %>'/>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="inname" width="120px" runat="server"/>

<asp:RequiredFieldValidator ID="vname" runat="server" ControlToValidate="inname" Text="?" ValidationGroup="validaiton"/>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="ADDRESS1">

<ItemTemplate>

<asp:Label ID="lbladdress" runat="server" Text='<%#Eval("ADDRESS1") %>'/>

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox ID="txtaddress" width="70px" runat="server" Text='<%#Eval("ADDRESS1") %>'/>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="inaddress" width="110px" runat="server"/>

<asp:RequiredFieldValidator ID="vaddress" runat="server" ControlToValidate="inaddress" Text="?" ValidationGroup="validaiton"/>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="ADDRESS2">

<ItemTemplate>

<asp:Label ID="lblcity" runat="server" Text='<%#Eval("ADDRESS2") %>'/>

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox ID="txtcity" width="50px" runat="server" Text='<%#Eval("ADDRESS2") %>'/>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="incity" width="60px" runat="server"/>

<asp:RequiredFieldValidator ID="vcity" runat="server" ControlToValidate="incity" Text="?" ValidationGroup="validaiton"/>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="CITY">

<ItemTemplate>

<asp:Label ID="lblstate" runat="server" Text='<%#Eval("CITY") %>'/>

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox ID="txtstate" width="30px" runat="server" Text='<%#Eval("CITY") %>'/>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="instate" width="40px" runat="server"/>

<asp:RequiredFieldValidator ID="vstate" runat="server" ControlToValidate="instate" Text="?" ValidationGroup="validaiton"/>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="PINCODE">

<ItemTemplate>

<asp:Label ID="lblzip" runat="server" Text='<%#Eval("PINCODE") %>'/>

</ItemTemplate>

<EditItemTemplate>

<asp:TextBox ID="txtzip" width="30px" runat="server" Text='<%#Eval("PINCODE") %>'/>

</EditItemTemplate>

<FooterTemplate>

<asp:TextBox ID="inzip" width="40px" runat="server"/>

<asp:RequiredFieldValidator ID="vzip" runat="server" ControlToValidate="inzip" Text="?" ValidationGroup="validaiton"/>

</FooterTemplate>

</asp:TemplateField>

<asp:TemplateField>

<EditItemTemplate>

<asp:Button ID="ButtonUpdate" runat="server" CommandName="Update" Text="Update" />

<asp:Button ID="ButtonCancel" runat="server" CommandName="Cancel" Text="Cancel" />

</EditItemTemplate>

<ItemTemplate>

<asp:Button ID="ButtonEdit" runat="server" CommandName="Edit" Text="Edit" />

<asp:Button ID="ButtonDelete" runat="server" CommandName="Delete" Text="Delete" />

</ItemTemplate>

<FooterTemplate>

<asp:Button ID="ButtonAdd" runat="server" CommandName="AddNew" Text="Add New Row" ValidationGroup="validaiton" />

</FooterTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<div >

<br />&nbsp;&nbsp;&nbsp;&nbsp;

<asp:Label ID="lblmsg" runat="server"></asp:Label>

<br />

</div>

 

my code:

 

public partial class Sqt : System.Web.UI.Page

{

SqlConnection con = new SqlConnection("data source=VAAYUSEVA_SVR;Initial Catalog=cppsch;User ID=sa;Password=sa");

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

loadStores();

}

}

protected void loadStores()

{

con.Open();

SqlCommand cmd = new SqlCommand("Select * from TBL_CPPMASTER", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

int count = ds.Tables[0].Rows.Count;

con.Close();

if (ds.Tables[0].Rows.Count > 0)

{

gridView.DataSource = ds;

gridView.DataBind();

}

else

{

ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());

gridView.DataSource = ds;

gridView.DataBind();

int columncount = gridView.Rows[0].Cells.Count;

lblmsg.Text = " No data found !!!";

}

}

protected void gridView_RowEditing(object sender, GridViewEditEventArgs e)

{

gridView.EditIndex = e.NewEditIndex;

loadStores();

}

protected void gridView_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

string stor_id = gridView.DataKeys[e.RowIndex].Values["[USER NAME]"].ToString();

TextBox stor_name = (TextBox)gridView.Rows[e.RowIndex].FindControl("txtname");

TextBox stor_address = (TextBox)gridView.Rows[e.RowIndex].FindControl("txtaddress");

TextBox city = (TextBox)gridView.Rows[e.RowIndex].FindControl("txtcity");

TextBox state = (TextBox)gridView.Rows[e.RowIndex].FindControl("txtstate");

TextBox zip = (TextBox)gridView.Rows[e.RowIndex].FindControl("txtzip");

con.Open();

SqlCommand cmd = new SqlCommand("update TBL_CPPMASTER set EDC ='" + stor_name.Text + "', ADDRESS1='" + stor_address.Text + "', ADDRESS2='" + city.Text + "', CITY='" + state.Text + "', PINCODE='" + zip.Text + "' where [USER NAME]=" + stor_id, con);

cmd.ExecuteNonQuery();

con.Close();

lblmsg.BackColor = Color.Blue;

lblmsg.ForeColor = Color.White;

lblmsg.Text = stor_id + " Updated successfully........ ";

gridView.EditIndex = -1;

loadStores();

}

protected void gridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

gridView.EditIndex = -1;

loadStores();

}

protected void gridView_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

string stor_id = gridView.DataKeys[e.RowIndex].Values["[USER NAME]"].ToString();

con.Open();

SqlCommand cmd = new SqlCommand("delete from TBL_CPPMASTER where [USER NAME]=" + stor_id, con);

int result = cmd.ExecuteNonQuery();

con.Close();

if (result == 1)

{

loadStores();

lblmsg.BackColor = Color.Red;

lblmsg.ForeColor = Color.White;

lblmsg.Text = stor_id + " Deleted successfully....... ";

}

}

protected void gridView_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

string stor_id = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "[USER NAME]"));

Button lnkbtnresult = (Button)e.Row.FindControl("ButtonDelete");

if (lnkbtnresult != null)

{

lnkbtnresult.Attributes.Add("onclick", "javascript:return deleteConfirm('" + stor_id + "')");

}

}

}

protected void gridView_RowCommand(object sender, GridViewCommandEventArgs e)

{

if (e.CommandName.Equals("AddNew"))

{

TextBox instorid = (TextBox)gridView.FooterRow.FindControl("instorid");

TextBox inname = (TextBox)gridView.FooterRow.FindControl("inname");

TextBox inaddress = (TextBox)gridView.FooterRow.FindControl("inaddress");

TextBox incity = (TextBox)gridView.FooterRow.FindControl("incity");

TextBox instate = (TextBox)gridView.FooterRow.FindControl("instate");

TextBox inzip = (TextBox)gridView.FooterRow.FindControl("inzip");

con.Open();

SqlCommand cmd =

new SqlCommand(

"insert into TBL_CPPMASTER ([USER NAME],EDC,ADDRESS1,ADDRESS2,CITY,PINCODE) values('" + instorid.Text + "','" +

inname.Text + "','" + inaddress.Text + "','" + incity.Text + "','" + instate.Text + "','" + inzip.Text + "')", con);

int result = cmd.ExecuteNonQuery();

con.Close();

if (result == 1)

{

loadStores();

lblmsg.BackColor = Color.Green;

lblmsg.ForeColor = Color.White;

lblmsg.Text = instorid.Text + " Added successfully...... ";

}

else

{

lblmsg.BackColor = Color.Red;

lblmsg.ForeColor = Color.White;

lblmsg.Text = instorid.Text + " Error while adding row.....";

}

}

}

}