Мне нужно удалить изменить обновить gridview в архитектуре 3tier с помощью rowcommand

---

Прикладной уровень:

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;
using System.Configuration;
using ENT;
using BAL;

//pls give me server side code for me to make rowcommand event run
namespace myTeststudent3tier
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        int Flag = 0;
        private int flag;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {

                LoadGrid();
            }
        }
        private void LoadGrid()
        {
            

                TBAL BL = new TBAL();
                DataTable DT = new DataTable();
                DT = BL.Select();
                GridView1.DataSource = DT;//when i ru with this code i got error says Both DataSource and DataSourceID are defined on 'GridView1'.  Remove one definition.
               
                GridView1.DataBind();
            }
    }

        protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "EditRow")//this code got from surfing the net
            {
                int rowindex = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
                GridView1.EditIndex = rowindex;
                LoadGrid();
            }
            else if (e.CommandName == "CancelUpdate")//this code got from surfing the net
            {
                GridView1.EditIndex = -1;

                LoadGrid();

            }
            else if (e.CommandName == "UpdateRow")
            {
                //here ihave to write a code for updaterow in template but i dontknow how to do but this is the code u used but this one will not implement nothing on templatefield
                int val = Convert.ToInt16(Session["PKId"]);
                testENT EN = new testENT()
                {
                    StrName = txtName.Text,
                    IntGender = Convert.ToInt16(DropDownList1.SelectedValue.ToString()),
                    IntId = val

                };
                TBAL objBAL = new TBAL();

                Flag = objBAL.Update(EN);
            }



            else if (e.CommandName == "DeleteRow")
            {
                int val = Convert.ToInt16(e.CommandArgument.ToString());
                Session["PKId"] = val.ToString();


                testENT obj = new testENT()
                   {
                       IntId = val



                   };
                Flag = new TBAL().Delete(obj);
                LoadGrid();
                if (Flag > 0)
                {

                    LoadGrid();

                    lblDisplay.Text = "Record deleted Successfully ";
                }
                else
                {
                    lblDisplay.Text = "try Again";
                }
            }
        }

        protected void btn1_Click(object sender, EventArgs e)//this piece of code is k here is used to insert then ican use separate button to make update delete but i wanna need to do it in rowcommand//pls help
        {
            testENT ENT = new testENT()
            {
                StrName = txtName.Text,
                IntGender = Convert.ToInt16(DropDownList1.SelectedValue.ToString())
            };


            TBAL objBal = new TBAL();
            Flag = objBal.Insert(ENT);

            if (Page.IsValid)
            {



                txtName.Text = "";
                DropDownList1.SelectedIndex = -1;

                lblDisplay.Text = "Record Inserted Successfully ";
                LoadGrid();
            }
            else
            {
                lblDisplay.Text = "pls try again ";
            }
        }
    }


}

ЛОР:

public class testENT
    {
        public int IntId { get; set; }
        public string StrName { get; set; }
        public int IntGender { get; set; }
    }
}

ДАЛМАТИНЕЦ:

 public class DBconnection
    {
        public String ConnString = ConfigurationManager.ConnectionStrings["SQLconnection"].ConnectionString;
        public SqlConnection sql;
        public void DBCon()
        {

            sql = new SqlConnection(ConnString);
        }

        public void Connect()
        {
            if (sql.State == ConnectionState.Closed)
                sql.Open();
        }

        public void DisConnect()
        {
            if (sql.State == ConnectionState.Open)
                sql.Close();
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ENT;
using System.Data.SqlClient;
using System.Data;

namespace DAL
{
   public class testDAL:DBconnection
    {
       testENT ENTObj = new testENT();
        int Flag = 0;
        public int Insert(testENT ENTObj)
        {
            DBCon();
            Connect();
            SqlCommand cmd = new SqlCommand("tblStudentInsert", sql);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Name", ENTObj.StrName);
            cmd.Parameters.AddWithValue("@Gender", ENTObj.IntGender);
            Flag = cmd.ExecuteNonQuery();
            DisConnect();
            return Flag;
        }
        public int Delete(testENT ENTObj)
        {
            DBCon();
            Connect();
            SqlCommand cmd = new SqlCommand("tblStudentDelete", sql);
           cmd.Parameters.AddWithValue("@Id", ENTObj.IntId);
            cmd.CommandType = CommandType.StoredProcedure;
            Flag = cmd.ExecuteNonQuery();
            DisConnect();
            return Flag;
        }
        public int Update(testENT ENTObj)
        {
            DBCon();
            Connect();

            SqlCommand cmd = new SqlCommand("tblStudentUpdate", sql);
            cmd.Parameters.AddWithValue("@Name", ENTObj.StrName);
            cmd.Parameters.AddWithValue("@Gender", ENTObj.IntGender);
            cmd.Parameters.AddWithValue("@Id", ENTObj.IntId);
            cmd.CommandType = CommandType.StoredProcedure;
            Flag = cmd.ExecuteNonQuery();
            DisConnect();
            return Flag;
        }
        public DataTable Select()
        {
            DBCon();
            Connect();
            DataTable dt1 = new DataTable();



            SqlCommand cmd = new SqlCommand("tblStudentSelect", sql);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlDataAdapter adt = new SqlDataAdapter(cmd);
            adt.Fill(dt1);
            DisConnect();
            return dt1;
        }


        public DataTable Edit(testENT obj)
        {
            DBCon();
            Connect();
            DataTable dt1 = new DataTable();



            SqlCommand cmd = new SqlCommand("tblStudentEdit", sql);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Id", obj.IntId);
            SqlDataAdapter adt = new SqlDataAdapter(cmd);
            adt.Fill(dt1);
            
            DisConnect();
            return dt1;
        }
    }

}

БАЛАНС:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ENT;
using DAL;
using System.Data; 

namespace BAL
{
    public class TBAL
    {
         public int Insert(testENT ENobj)
        {
            return new testDAL().Insert(ENobj);
        }
        public int Delete(testENT ENobj)
        {
            return new testDAL().Delete(ENobj);
        }
        public DataTable Select()
        {
            return new testDAL().Select();
        }
        public DataTable Edit(testENT ENobj)
        {
            return new testDAL().Edit(ENobj);
        }
        public int Update(testENT ENobj)
        {
            return new testDAL().Update(ENobj);
        }
    }

    }

Designfilrcodexhtml

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="myTeststudent3tier.WebForm1" %>

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

    <title>
 
    <div>
    
        Name:<asp:TextBox ID="txtName" runat="server">
        <asp:RequiredFieldValidator ID="RequiredFieldValidatorName" runat="server" ErrorMessage="Name is Required" ControlToValidate="txtName">
        <asp:DropDownList ID="DropDownList1"  runat="server">
        
        <asp:ListItem Text="selectGender" Value="-1"> 
         
            <asp:ListItem Value="1" Text="Male">
            <asp:ListItem Value="2" Text="Female">
            
        
        <asp:RequiredFieldValidator ID="RequiredFieldValidatorGender" runat="server" ErrorMessage="Gender is Required" InitialValue="-1" ControlToValidate="DropDownList1">
    
        <asp:Button ID="btn1" runat="server" Text="Submit" onclick="btn1_Click" />
    
        <br>
    
    </div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 

        CellPadding="4" DataKeyNames="Id" DataSourceID="SqlDataSource1" 

        ForeColor="#333333" GridLines="None">
        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        <columns>
        <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
        <asp:templatefield>
        <itemtemplate>
            <asp:LinkButton ID="lnkEdit" CommandArgument='<%# Eval("Id") %>' CommandName ="EditRow"  Forecolor="#8c4510" runat="server">Edit
            <asp:LinkButton ID="lnkDelete" CommandArgument='<%# Eval("Id") %>' CommandName ="DeleteRow"  runat="server">Delete
            
            <edititemtemplate>
            <asp:LinkButton ID="lnkUpdate" CommandArgument='<%# Eval("Id") %>' CommandName ="UpdateRow"  runat="server">Update
            <asp:LinkButton ID="lnkCancel" CommandArgument='<%# Eval("Id") %>' CommandName ="CancelUpdate"  runat="server">Cancel
            
        
        
            
            <asp:TemplateField HeaderText="Id" InsertVisible="False" SortExpression="Id">
                <itemtemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("Id") %>'>
                
                <edititemtemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Eval("Id") %>'>
                
            
            <asp:TemplateField HeaderText="Name" SortExpression="Name">
                <itemtemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("Name") %>'>
                
                <edititemtemplate>
                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Name") %>'>
                
            
            <asp:TemplateField HeaderText="Gender" SortExpression="Gender">
                <itemtemplate>
                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("Gender") %>'>
                
                <edititemtemplate>
                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Gender") %>'>
                
            
                 <asp:templatefield>
                <itemtemplate>
    
            <asp:templatefield>
                <itemtemplate>

        <EditRowStyle BackColor="#999999" />
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#E9E7E2" />
        <SortedAscendingHeaderStyle BackColor="#506C8C" />
        <SortedDescendingCellStyle BackColor="#FFFDF8" />
        <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
    
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 

        ConnectionString="<%$ ConnectionStrings:SQLconnection %>" 

        DeleteCommand="DELETE FROM [tblStudent] WHERE [Id] = @Id" 

        InsertCommand="INSERT INTO [tblStudent] ([Name], [Gender]) VALUES (@Name, @Gender)" 

        SelectCommand="SELECT * FROM [tblStudent]" 

        UpdateCommand="UPDATE [tblStudent] SET [Name] = @Name, [Gender] = @Gender WHERE [Id] = @Id">
        <deleteparameters>
            <asp:Parameter Name="Id" Type="Int32" />
        
        <insertparameters>
            <asp:Parameter Name="Name" Type="String" />
            <asp:Parameter Name="Gender" Type="String" />
        
        <updateparameters>
            <asp:Parameter Name="Name" Type="String" />
            <asp:Parameter Name="Gender" Type="String" />
            <asp:Parameter Name="Id" Type="Int32" />
        
    
    <asp:Label ID="lblDisplay" runat="server" Text="Label">

Что я уже пробовал:

Я попробовал вставить кнопку работает но событие rowcommand не работает и bindgrid иногда появляется и datasoure и datasourceid находятся в одном gridview1

---