Data Presentation Controls

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

JustWantAnAnswer — Thu, 18 Dec 2008 16:58:14 GMT

Well, I didn't say it, but I did find it. Not that I can do anything with it, it remains stubbornly disabled and greyed out and won't let me select it.

The radio button for "two way binding" shows up if you select your gridview in design mode and you have at least one template associated to it. When you select it, you should see a right facing triangle up in the upper right corner, and when you click on that you get a popdown window whose last item is a link titled "edit templates". So if you have a command column with edit and delete buttons in it, for example, as a template, then that will come up in the new display, and when you mouse over the link for "edit" another triangle will popup and if you click that you'll get a dialog box that has a (disabled) check box for "Two-way databinding".

So that's where it is, I'd sure be curious to find out what it does and just what all this template business does for us.

(by the way, you'll have to back out of this template editing area gracefully: after you close the dialog box, select the right triangle again and select "End Template Editing".)

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

ronald_yoh — Wed, 17 Dec 2008 03:06:40 GMT

hey mate.. when you said two-way binding.. what does it mean? where can i find it?

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

JustWantAnAnswer — Tue, 02 Sep 2008 19:39:12 GMT

Eventually, reading through here and several other places, i finally got rid of the parameter mismatch by using point and clickery on my object data source to point directly to my supporting webservice and selecting methods declared there as web methods.

see http://forums.asp.net/p/1310573/2595948.aspx#2595948

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

JustWantAnAnswer — Fri, 29 Aug 2008 21:28:52 GMT

I'd say there is definitely a bug involved here. three years later and still catching people. So I have another variation, though maybe some one has a magic wand for me:

ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'UpdateClassInfo' that has parameters: ERRCLASSTYPE, ERRCOUNTY, ERRZIP, ERRCLASSROOMHOURS, ERRLIVEFIRING, ERRCHIEFPHONE, ERRNUMMINORITY, ERRSTUDENTENDROLLED, ERRSTUDENTCERTIFIED, ERRDESC, ERRDATE, errclsclassid, ERRSTUDENTENROLLED.

First off, I have no idea where the second errstudentenrolled is coming from. Secondly, I don't seem to have the tools available that others in this thread have, perhaps because I'm using (have to) a web service to get my data from. It gets the data just fine. I can modify one of the fields and get this error when I click the generated update button. I would just as soon write procedureal field by field code in a regular button handler, but nothing I do there seems able to find the data in these 2005 components (I've done it with 2003 components...) I'd love either how to fix this error, or how to find the data in code. Here's the aspx.

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeBehind="FixClassErr.aspx.cs" Inherits="MoHuntEdWebApp.WebForm11" Title="Untitled Page" %>
<asp:Content ID="FixClassErr" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
     <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateDeleteButton="True"
        AutoGenerateEditButton="True" DataSourceID="ObjectDataSource1" DefaultMode="Edit"
        Height="50px" Width="125px" DataKeyNames="errclsclassid" OnItemDeleted="DetailsView1_ItemDeleted" OnItemInserted="DetailsView1_ItemInserted" OnItemUpdated="DetailsView1_ItemUpdated" AutoGenerateRows="False">
        <Fields>
            <asp:BoundField DataField="ERRCLSCLASSID" HeaderText="ERRCLSCLASSID" />
            <asp:BoundField DataField="ERRCLASSTYPE" HeaderText="ERRCLASSTYPE"   />
            <asp:BoundField DataField="ERRCOUNTY" HeaderText="ERRCOUNTY" />
            <asp:BoundField DataField="ERRZIP" HeaderText="ERRZIP" />
            <asp:BoundField DataField="ERRCLASSROOMHOURS" HeaderText="ERRCLASSROOMHOURS" />
            <asp:BoundField DataField="ERRLIVEFIRING" HeaderText="ERRLIVEFIRING" />
            <asp:BoundField DataField="ERRCHIEFPHONE" HeaderText="ERRCHIEFPHONE" />
            <asp:BoundField DataField="ERRNUMMINORITY" HeaderText="ERRNUMMINORITY" />
            <asp:BoundField DataField="ERRSTUDENTENROLLED" HeaderText="ERRSTUDENTENROLLED" />
            <asp:BoundField DataField="ERRSTUDENTCERTIFIED" HeaderText="ERRSTUDENTCERTIFIED"/>
            <asp:BoundField DataField="ERRDESC" HeaderText="ERRDESC" />
            <asp:BoundField DataField="ERRDATE" HeaderText="ERRDATE" />
        </Fields>
    </asp:DetailsView>
    <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" SelectMethod="GetClassErr"
        TypeName="MoHuntEdWebApp.moHuntEdWebSvc.MoHuntEdWebSvc" OnDeleted="ObjectDataSource1_Deleted" OnInserted="ObjectDataSource1_Inserted" OnUpdated="ObjectDataSource1_Updated" UpdateMethod="UpdateClassInfo">
        <SelectParameters>
            <asp:QueryStringParameter Name="primarykeyid" QueryStringField="key" Type="String" />
        </SelectParameters>
        <UpdateParameters>
            <asp:Parameter Direction="InputOutput" Name="errclsclassid" Type="String" />
            <asp:Parameter Name="ERRCLASSTYPE" Type="String" />
            <asp:Parameter Name="ERRCOUNTY" Type="String" />
            <asp:Parameter Name="ERRZIP" Type="String" />
            <asp:Parameter Name="ERRCLASSROOMHOURS" Type="String" />
            <asp:Parameter Name="ERRLIVEFIRING" Type="String" />
            <asp:Parameter Name="ERRCHIEFPHONE" Type="String" />
            <asp:Parameter Name="ERRNUMMINORITY" Type="String" />
            <asp:Parameter Name="ERRSTUDENTENDROLLED" Type="String" />
            <asp:Parameter Name="ERRSTUDENTCERTIFIED" Type="String" />
            <asp:Parameter Name="ERRDESC" Type="String" />
            <asp:Parameter Name="ERRDATE" Type="String" />
        </UpdateParameters>
    </asp:ObjectDataSource>
    <asp:Label ID="lblStatus" runat="server" Font-Bold="True" ForeColor="Red" Visible="False"></asp:Label> 
    <asp:Button ID="btnUpdate" runat="server" OnClick="btnUpdate_Click" Text="Apply Update" />
    <asp:Button ID="btnDone" runat="server" OnClick="btnDone_Click" Text="Done" />
</asp:Content>

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

1sweetkate — Wed, 09 Jan 2008 17:24:02 GMT

I had this very same issue but on a FormView. I thought I would lose my mind. The fix for me, was to add a DataKeyNames.

<asp:FormView ID="fvVRS" runat="server" DataSourceID="odsVRS" DefaultMode="Edit" DataKeyNames="ID" >

Only thing I can say that this error was a nightmare, but a great learning tool for this newbie.

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

RebelChris — Tue, 02 Oct 2007 09:32:42 GMT

I have the same problem

But:

My edit and delte functions work great

only the insert funciton on my detailsview doesnt work it first said ObjectDataSource 'ObjectDataSource' could not find a non-generic method that has parameters:

Ive changed the old values paramter and all

but now ive said that id should be read only false and i get this error:

Column 'ProductID' does not allow nulls.

I really dont know what to do now
It's really neader to insert products.

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

CodeDigger — Tue, 27 Feb 2007 16:30:07 GMT

I'm banging my head against the wall with generated datasets and ObjectSource.

What I've found out ill now is, that it will work without any hassle IF all generated SQL statements are generated without the optimistic concurreny option being set.

Strange enough, I hope MS will eventually fix VS2005

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

JumpinJackFlash — Tue, 27 Feb 2007 12:23:49 GMT

I got this working in a gridview by including the PK (field 'ID' in code below) as an asp:label in any edititemtemplate, adding 2 way databinding, then setting visibility to false so it couldn't be seen. I didn't put an entry in the itemtemplate at all! Obviously this requires at least one templatecolumn in the gridview, but means all other code generated automatically for the gridview/objectdatasource including stored procedures works as is!

asp:Label ID="PKLabel" runat="server" Text='<%# Bind("ID") %>' Visible="False" />

...other controls here....

EditItemTemplate>

Cheers,

Jack

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

greg_white — Mon, 08 Jan 2007 21:25:47 GMT

I wasnt able to get this working using the above methods but once i changed my primary key from a guid to an int it worked without error!!

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

ImDaFrEaK — Sat, 06 Jan 2007 00:17:47 GMT

Thank you! This is the post that did it for me. However; I had to take one extra step and add a custom UpdateQuery Command to my DataSet. I removed the parameters that weren't given to me in the error. I have spent nearly all day literrally trying to figure this out. I even followed along side step by step one of the how asp.net videos and it still didn't work. Anyways, Got it working now. Thank you.

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

pitronot — Mon, 25 Dec 2006 15:05:40 GMT

This is a mix-n-match of alot of answers i read on the net, some from here, and from other places as well..

Basicaly, from wat I gather, the Primary Key is not sent by the DataGrid, and this causes the error.

So what i did was a simple workaround.

Lets say the PK is called "ID"

what i do is simply catch the DataObject_Updating event and add this line:

e.InputParameters.Add(

"ID", e.InputParameters["Original_ID"]);

and it works. and it's simple.

Hope this helps,
Mickey Perlstein
Head of RnD
Interlect ltd.

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

Steveorsomethin — Fri, 06 Oct 2006 20:59:23 GMT

Hi,

I was also becoming frustrated with this issue and was not willing to implement a workaround. Ultimately I added the Primary Key to the DataKeyNames property of my GridView and it worked flawlessly. The only hitch that I ran accross was that I had to rebuild the Update function in my dataset, then reassociate it with my ObjectDataSource to prevent an error stating that the function could not be found. Hope this helps someone else as well.

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

MNF — Wed, 27 Sep 2006 00:34:18 GMT

Brady,

Have you submit your post to https://connect.microsoft.com/VisualStudio/feedback/?
By the way, I wanted to add comment to your blog post , but "Anonymous comments are disabled" and I didn't find how to login.

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

tatochip — Tue, 26 Sep 2006 21:10:24 GMT

Since so many people seem to have such a huge problem with this I've posted a blog post about the reproduction of this problem. Hopefully we'll see some sort of fix from MS sooner rather than later.

http://weblogs.asp.net/bradygaster/archive/2006/09/26/How-to-Bloody-Your-Forehead.aspx

Re: Dataset + ObjectDatasource + GridView + ASP.NET 2

MNF — Fri, 01 Sep 2006 02:56:54 GMT

I've posted in my blog the steps to create Update method in DataAdaptor with parameters to satisfy editing of GridView with ObjectDataSource.