0

like i am setting a button i gridview which when i click then shoulf turn row into editable mode, i could use Automatic EDIT button of Gridview but i didn't on purpose, it went good when i developed a delete button, +1, but stuck with this edit , it throws error:
The GridView 'gvTest' fired event RowEditing which wasn't handled.

code:
.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class Default2 : System.Web.UI.Page
{
    public String constrng = "Data Source=PALERIDER-PC;Initial Catalog=Login;Integrated Security=True";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {

            connectToDb();
        }
    }

    public void connectToDb() 
    {
        SqlConnection sqlcon = new SqlConnection(constrng);
        String com1 = "select * from login";
        SqlCommand sqlcom = new SqlCommand(com1, sqlcon);
        SqlDataAdapter sqlda = new SqlDataAdapter(sqlcom);
        DataSet ds = new DataSet();

        try
        {
            sqlcon.Open();
            sqlda.Fill(ds);
            gvTest.DataSource = ds;
            gvTest.DataBind();
        }
        catch (Exception exc)
        {
            Response.Write(exc.ToString());
        }
        finally
        {
            sqlcon.Close();
        }
    }

    protected void gvTest_RowDataBound(Object sender, GridViewRowEventArgs e) 
    {
        if (e.Row.RowType == DataControlRowType.DataRow) 
        {
            DropDownList ddlist = (DropDownList)e.Row.FindControl("ddListTest");
            ddlist.Items.Insert(0, "Select");
        }
    }

    protected void gvTest_Delete(Object sender, CommandEventArgs e) 
    {
        if (e.CommandName == "deleterow")
        {

            int index_row = Convert.ToInt32(e.CommandArgument);
            Response.Write(index_row+"</br>");

            //  Button GrdBtn = (Button)gvTest.Rows[index_row].FindControl("btnDelete");
          //  TextBox GrdTxtBox = (TextBox)gvTest.Rows[index_row].FindControl("txtboxTest");
          //  DropDownList GrdDlist = (DropDownList)gvTest.Rows[index_row].FindControl("ddListTest");

           // String delete_comm = "delete from login where stid= '"+index_row+"' ";

            int pk = Convert.ToInt32(gvTest.DataKeys[index_row].Value);  

            SqlConnection sqlcon = new SqlConnection(constrng);
            SqlCommand sqlComDelte = new SqlCommand("deleteRow", sqlcon);
            sqlComDelte.CommandType = CommandType.StoredProcedure;

            sqlComDelte.Parameters.Add("@index", SqlDbType.Int).Value = pk ;
            Response.Write("PK=" + pk+"</br>");
            //sqlComDelte.Parameters["@index"].Value = index_row;

            try
            {
                sqlcon.Open();
                int numRowEffected = Convert.ToInt32(sqlComDelte.ExecuteNonQuery());
                Response.Write("Num of rows deleted="+numRowEffected+"</br>");
                connectToDb();
                Response.Write("Loaded again");
            }
            catch (Exception ex)
            {
                Response.Write(ex.ToString());
            }
            finally 
            {
                sqlcon.Close();
            }

        }
    }

    protected void gvTest_Edit(Object sender, GridViewEditEventArgs e) 
    {
        gvTest.EditIndex = e.NewEditIndex;
        Response.Write("Editing...");
        connectToDb();
    }
    protected void gvTest_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}

.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
     <asp:GridView ID="gvTest" runat= "server" OnRowDataBound="gvTest_RowDataBound" DataKeyNames="stid">
      <Columns>
       <asp:TemplateField HeaderText="Delete" >
        <ItemTemplate>
         <asp:Button ID="btnDelete" runat="server"  Text="Delete" onCommand="gvTest_Delete"  CommandName="deleterow" 
          CommandArgument='<%# Container.DataItemIndex %>'   />
         <asp:Button ID= "btnEdit" runat="server" Text="Edit" OnRowEditing="gvTest_Edit" CommandName="edit" 
          CommandArgument='<%# Container.DataItemIndex %>' />
        </ItemTemplate>
       </asp:TemplateField>

       <asp:TemplateField HeaderText="Enter Key">
        <ItemTemplate>
         <asp:TextBox ID="txtboxTest" Text='<%#Eval("Name") %>' Width="90" runat="server"  />
        </ItemTemplate>
        <EditItemTemplate>
         <asp:TextBox ID="txtboxTest" Text='<%#Eval("Name") %>' Width="90" runat="server"  />
        </EditItemTemplate>
       </asp:TemplateField>
       <asp:TemplateField HeaderText="Select Value">
        <ItemTemplate>
         <!-- <asp:Image ID="img1" runat="server" ImageUrl="DSC03148.jpg" Height="10%" Width="5%" /> -->
        <asp:DropDownList ID= "ddListTest" runat="server" DataSourceid="SqlDS01" DataTextField="name" DataValueField="stid" ></asp:DropDownList>
        </ItemTemplate>
       </asp:TemplateField>
      </Columns>
     </asp:GridView>
     <asp:SqlDataSource id="SqlDS01"  runat="server" ConnectionString="Data Source=PALERIDER-PC;Initial Catalog=Login;Integrated Security=True"
          SelectCommand = "select stid, name from login" >
     </asp:SqlDataSource>
    </div>
   </form>
</body>
</html>
2
Contributors
4
Replies
9
Views
4 Years
Discussion Span
Last Post by JorgeM
1

I think "OnRowEditing="gvTest_Edit" belongs on line 12 with the gridview control, not on the button control.

0

o wow ! that was so stupid of m, even i did something like this before but couldn't find out this time but thanks jorGem

0

btw one thing that i have been searching since many days that confuses me is that the difference between ONCOMMNAD and ONROWCOMMAND,
Oncommand methid use parameters like "DELTEROW" EDITROW while ONROWCOMMAND uses DELETE, EDIT etc and both send different kinda objects like one send GridviewEventargs type object while another sends commandeventargs,

WHY ? Where to use ? HOW ?

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.