.NET (Core and Framework)

protected void btnEdit_Click(object sender, EventArgs e)
    {
        try
        {
            GridViewRow row = ((LinkButton)sender).Parent.Parent as GridViewRow;
            HiddenField vId = (HiddenField)gvUser.Rows[row.RowIndex].FindControl("hdPK");
            form obj = new form(cmscon.CONNECTIONSTRING, Convert.ToInt32(vId.Value));
            GetValue(obj);
            Label1.Text = "";
            lblError.InnerHtml = "";
        }
        catch (Exception ex)
        {

        }
    }

<asp:TemplateField HeaderText="Action">
                    <ItemTemplate>
                           <asp:HiddenField ID="hdPK" runat="server" Value='<%# Eval("Id") %>' />
                           <asp:LinkButton ID="btnEdit" runat="server" OnClick="btnEdit_Click" CausesValidation="false">Edit</asp:LinkButton>
                           &nbsp;&nbsp;
                           <asp:LinkButton ID="btnDelete" runat="server" OnClientClick="return show_confirm();"
                           OnClick="btnDelete_Click">Delete</asp:LinkButton>
                   </ItemTemplate>
                           <HeaderStyle HorizontalAlign="Center" />
                     </asp:TemplateField>

 public static DataTable GetFlightsByDate(DateTime datefile)
        {
            DataTable GetFlights=new DataTable();
            string query = "SELECT TOP (20) Pax_No, Chd_no,"+                        
				            "Hotel_Id, DateFile, DEST, DEST_D, TypeTransfer, ARR_FLT, AT_Arr, DEP_FLT"+
"FROM  V_Report_Rooming_List_Trsf where DateFile=@DateFile";
            SqlConnection con = new SqlConnection(conn);
            SqlCommand cmd = new SqlCommand(query, con);
            cmd.Parameters.Add(new SqlParameter("@DateFile",datefile));
            SqlDataAdapter sdr = new SqlDataAdapter(cmd);
            sdr.Fill(GetFlights);
            return GetFlights;
        }