Wrox Programmer Forums
|
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 6th, 2006, 03:16 AM
Registered User
 
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Editable Gridview

I am using Gridview control in a web form. I have added two new columns of type command field of "edit" and "delete" in it.

I don't know how to bind sql quries to edit or delete specific rows in gridview (using sqldatasource). I am unable to identify the specific row for delete or edit while writing sql query in sqldatasource control. The problem is setting parameters in sqldatasource, see code below:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:HomeString %>"
            SelectCommand="SELECT hrmdegree.degreeid, hrmdegree.degreename, hrmempqualification.remarks, hrmempqualification.percentage, hrmempqualification.degreeid AS Expr1, hrmempqualification.institutename, hrmempqualification.qualificationyear, hrmempqualification.qualificationid FROM hrmdegree INNER JOIN hrmempqualification ON hrmdegree.degreeid = hrmempqualification.degreeid WHERE (hrmempqualification.empid = @empid)" OnSelecting="SqlDataSource1_Selecting" DeleteCommand="DELETE FROM hrmempqualification WHERE (empid = @empid) AND [u](qualificationid = @qualificationid)</u>" >
            <DeleteParameters>
                <asp:SessionParameter Name="empid" SessionField="EmplID" />

            </DeleteParameters>


Please help me in this issue





Similar Threads
Thread Thread Starter Forum Replies Last Post
iframe editable skyler Javascript 3 April 15th, 2011 05:28 AM
Editable Dropdownlist msbsam ASP.NET 2.0 Professional 1 March 31st, 2008 09:08 AM
editable datagrid .............help maddy137 ASP.NET 1.0 and 1.1 Professional 0 May 17th, 2006 07:33 PM
Convert Fully Editable DataGrid To F Edit Gridview gtjr92 ASP.NET 2.0 Basics 0 May 4th, 2005 12:48 PM
Editable regions in templates craigrobertson Dreamweaver (all versions) 2 April 13th, 2005 04:23 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.