Help with creating a Datagridview that is bound to an ObjectDataSource

Hello ASP.Net,

I have a website with a great deal of database tables and pages that interact with said tables. I have recently added a table to my database, it has the following schema:

CREATE TABLE [dbo].[tblPCT](
	[id] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[pct] [nvarchar](50) NULL,
	[credits] [smallint] NULL,
	[pctUser] [nvarchar](50) NULL,
	[pctPass] [nvarchar](25) NULL,
	[pctCode] [nchar](10) NULL,
 CONSTRAINT [PK_tblPCT] PRIMARY KEY CLUSTERED
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

I have a Dataset designed file located:

App_Code/DAL/DAL.xsd

This is where I drag on my table adapters and I create the Select/Update/Insert/Delete statements using the designer.

On my aspx form, I drag on a DataDridView and an object data source, I assign the datagridview to the ODS and to the ODS I assign the table adapter I have generated in my DAL.xsd.

All of the different columns/statements are autogenerated for me by vs2008.

This is the markup:

<asp:Content ID="Content1" ContentPlaceHolderID="page_body" runat="Server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AllowSorting="True"
        DataKeyNames="id" DataSourceID="ObjectDataSource1">
        <Columns>
            <asp:CommandField ShowDeleteButton="True" />
            <asp:BoundField DataField="id" HeaderText="id" ReadOnly="True" SortExpression="id" />
            <asp:BoundField DataField="pct" HeaderText="pct" SortExpression="pct" />
            <asp:BoundField DataField="credits" HeaderText="credits" SortExpression="credits" />
            <asp:BoundField DataField="pctUser" HeaderText="pctUser" SortExpression="pctUser" />
            <asp:BoundField DataField="pctPass" HeaderText="pctPass" SortExpression="pctPass" />
            <asp:BoundField DataField="pctCode" HeaderText="pctCode" SortExpression="pctCode" />
        </Columns>
    </asp:GridView>
    <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DeleteMethod="Delete"
        InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
        TypeName="HealthDiagnosticsTableAdapters.tblPCTTableAdapter" UpdateMethod="Update"
        DataObjectTypeName="System.Guid">
        <UpdateParameters>
            <asp:Parameter Name="id" DbType="Guid" />
            <asp:Parameter Name="pct" Type="String" />
            <asp:Parameter Name="credits" Type="Int16" />
            <asp:Parameter Name="pctUser" Type="String" />
            <asp:Parameter Name="pctPass" Type="String" />
            <asp:Parameter Name="pctCode" Type="String" />
            <asp:Parameter DbType="Guid" Name="Original_id" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter DbType="Guid" Name="id" />
            <asp:Parameter Name="pct" Type="String" />
            <asp:Parameter Name="credits" Type="Int16" />
            <asp:Parameter Name="pctUser" Type="String" />
            <asp:Parameter Name="pctPass" Type="String" />
            <asp:Parameter Name="pctCode" Type="String" />
        </InsertParameters>
    </asp:ObjectDataSource>
</asp:Content>

When I try and delete a row I get the following error:

Could not find a property named 'id' on the type specified by the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.

Any suggestions welcome

Re: Help with creating a Datagridview that is bound to an ObjectDataSource

It appears that you have no DeleteParameters items. Add one for your id property and it should work.

<DeleteParameters>
    <asp:Parameter Name="id" DbType="Guid" />
</UpdateParameters>

Re: Help with creating a Datagridview that is bound to an ObjectDataSource

I have done the above as you have suggested, I changed the *UpdateParameters to *DeleteParameters and I still get the same error:

Could not find a property named 'id' on the type specified by the DataObjectTypeName property in ObjectDataSource 'ObjectDataSource1'.

Re: Help with creating a Datagridview that is bound to an ObjectDataSource

Don't change; add. You need parameters for Insert, Update, and Delete.

When do you get the error above?

Re: Help with creating a Datagridview that is bound to an ObjectDataSource

Hello

I notice that your generated value has an original_{0}So plz remove that by changing your codes like this following

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DeleteMethod="Delete"
        InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"
        TypeName="HealthDiagnosticsTableAdapters.tblPCTTableAdapter" UpdateMethod="Update"
        DataObjectTypeName="System.Guid">
        <UpdateParameters>
            <asp:Parameter Name="id" DbType="Guid" />
            <asp:Parameter Name="pct" Type="String" />
            <asp:Parameter Name="credits" Type="Int16" />
            <asp:Parameter Name="pctUser" Type="String" />
            <asp:Parameter Name="pctPass" Type="String" />
            <asp:Parameter Name="pctCode" Type="String" />
            <asp:Parameter DbType="Guid" Name="Original_id" />
        </UpdateParameters>

…………………………

And then make sure that your UpdateParameter should include all the above parameters with the same correct type in the function