Update or delete in gridbox C#

Question

0.00/5 (No votes)

See more:

I have written code for Updating, Deleting, Cancelling & Editing the row in the GridBox. Cancelling & Editing works fine. But when I Click Update or Delete, I get an error stating,

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

What I have tried:

C#

protected void Show_Grid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
    int id = int.Parse(Show_Grid.DataKeys[e.RowIndex].Value.ToString());
    TextBox txt_title = (TextBox)Show_Grid.Rows[e.RowIndex].FindControl("Title");
    TextBox txt_desc = (TextBox)Show_Grid.Rows[e.RowIndex].FindControl("Description");
    TextBox drop_prior = (TextBox)Show_Grid.Rows[e.RowIndex].FindControl("Priority");

    Update_todo(id, txt_title.Text, txt_desc.Text, drop_prior.Text);
    Show_Grid.EditIndex = -1;
    DataBind();
}

Posted 24-May-16 1:47am

Mohamed Sheik M

Updated 24-May-16 1:56am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

CHill60 24-May-16 7:54am

We sort of need to see the code behind the Delete and Update events

Mohamed Sheik M 24-May-16 8:08am

private void Update_todo(int id, string title, string desc, string prior)
{
string source = "Data Source=.\\SQLEXPRESS;AttachDbFilename=tododb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection dbconnect = new SqlConnection(source);
string query = "UPDATE todolist SET Title='" + title + "', Description='" + desc + "', Priority=" + prior + " WHERE id =" +id+ " ";
SqlCommand cmd = new SqlCommand (query, dbconnect);
dbconnect.Open();
cmd.ExecuteNonQuery();
}

private void Delete_todo(int id)
{
string source = "Data Source=.\\SQLEXPRESS;AttachDbFilename=tododb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection dbconnect = new SqlConnection(source);
string query = "DELETE FROM todolist WHERE id=" + id + "";
SqlCommand cmd = new SqlCommand(query, dbconnect);
dbconnect.Open();
cmd.ExecuteNonQuery();
}

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 24-May-16 7:57am

Debug and see which line and which index is coming negative.

Mohamed Sheik M 24-May-16 8:07am

int id = int.Parse(Show_Grid.DataKeys[e.RowIndex].Value.ToString());
This line gets error

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 24-May-16 9:45am

Do you have data keys declared on markup?

Mohamed Sheik M 25-May-16 0:13am

Yes, I Have Declared.
<asp:GridView ID="Show_Grid" runat="server" DataKeys="id" BackColor="White"
BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3"
CellSpacing="1" GridLines="None" AutoGenerateColumns="False"
DataSourceID="tododatasource" AllowSorting="True" Height="304px"
Width="684px" onrowcancelingedit="Show_Grid_RowCancelingEdit"
onrowdeleting="Show_Grid_RowDeleting" onrowediting="Show_Grid_RowEditing"
onrowupdating="Show_Grid_RowUpdating">

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 25-May-16 2:50am

As only one key is there, try the below and remove DataKeys property.

DataKeyNames="id"

Let me know.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)