Hi there,

I'm using <asp:SqlDataSource> to connect to a database and update a record in a gridview.

The problem is my data is not updating.  In the past with 1.1 I could easily debug code with Datagrid, but because I'm using asp:SqlDataSource I cannot add breakpoints.

How can I debug this part of the code and see why my table is not updating.

Many thanks

You can create Updating and Updated event handlers for the SqlDataSource and stick breakpoints in those to see if either are hit.

my suggestion is to wire up the onupdating event and then look at your parameters and their values make sure you have all the default values set, and check to see if they are named right, moreover make sure youre sproc works in sql therefore you know its not the sql. but hopefully everything you need will be in that event.

Thanks.

Would you have an example of using OnUpdating to display parameters that I'm defining in asp:sqldatasource?

If you select the datasource in design view, you can get to its events via the Properties panel.  Just click the lightning icon.  Double click the Updating event, and that will create the event handler code.  Within that do this:

foreach(SqlParameter p in e.Command.Parameters)
{
    Response.Write(p.ParameterName + ": " + p.Value + "<br />");
}
 

Thanks Mike.

My parameters are displaying the correct data that I'm entering in the gridview, but my database isn't, so my gridview is retrieving old data.

Any ideas why?  Do I need to bind like you do with 1.1 datagrid?

Thanks.

No.  The SqlDataSource should take care of that.  Post your aspx code (just the relevant portions).

sometimes trying to get those magic parameters to work can be a B&*$$ so what i do sometimes is in your gridview make your fields that you are updating template fields then you can name the texboxes whatever you want (i know this is work but thats why you get paid $$$$$ (ding ding sound) . once you do that on updating you can set your default values of your parameters to your texbox values, moreover this also gives you the opportunity to do some sweet validation client and server side. let me holla at you real quick and show you what i mean

 (i cant cut and paste images soooo... i hope you know how to do this.) but its in the smart tag of the gridview then select your field then click the link that says (change to template) then again on your smart tag of your gridview go to edit template fields, on that drop down select your new template field and go to the "edit" box and name that textbox something appropriate, now on updatingyou can set the default value... (im not sure if this is going to help becuase it sounds like your gridview is getting its data from some other place but its a suggestion)

by the way try it with one field before you change your whole gridview

make sure your update works too just in sql

aspx code:

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
            <Columns>
                <asp:CommandField ShowSelectButton="True" />
                <asp:CommandField ShowEditButton="True" />
                <asp:CommandField ShowDeleteButton="True" />
                <asp:BoundField DataField="taskname" HeaderText="taskname" SortExpression="taskname" NullDisplayText="N/A" />
                <asp:BoundField DataField="taskdescription" HeaderText="taskdescription" SortExpression="taskdescription" NullDisplayText="N/A" />
                <asp:BoundField DataField="taskstatus" HeaderText="taskstatus" SortExpression="taskstatus" NullDisplayText="N/A" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Taskdb %>"
            SelectCommand="SELECT [taskid], [taskname], [taskdescription], [taskstatus] FROM [tblTask]" UpdateCommand="UPDATE [tbltask] set [taskname] = @taskname, [taskdescription] = @taskdescription, [taskstatus] = @taskstatus where [taskid] = @taskid" OnUpdated="OnUpdated" OnUpdating="SqlDataSource1_Updating">
            <UpdateParameters>
                <asp:Parameter Type="String" Name="taskname" />
                <asp:Parameter Type="String" Name="taskdescription" />
                <asp:Parameter Type="Int32" Name="taskstatus" />
                <asp:Parameter Type="Int32" Name="taskid" />
            </UpdateParameters>
        </asp:SqlDataSource>

Looks like you are missing the DataKeyNames attribute.

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" DataKeyNames="taskid"
            AutoGenerateColumns="False" DataSourceID="SqlDataSource1">

It's working, thanks Mike.