Hi Phillip,
Thank you so much for the reply. After looking over your suggested reading
and reading some other posts I got the impression that the Edit/Delete
functions only work when you are using a Datasource attached to the
DatasourceId property. Is this correct? Based on that, I have redesigned the
for some using a SqlDataSource attached to the DatasourceId. But I'm getting
the following error when trying to update a row:
Procedure or function Admin_UpdatePOI tem has too many arguments specified.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.Sql Client.SqlExcep tion: Procedure or function
Admin_UpdatePOI tem has too many arguments specified.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Now, I have setup the gridview as follows:
<asp:GridView ID="grdPOs" runat="server" AllowPaging="Tr ue"
AutoGenerateCol umns="False"
BackColor="Whit e" BorderColor="#C C9966" BorderStyle="No ne"
BorderWidth="1p x"
CellPadding="4" DataKeyNames="I temId" Height="68px" PageSize="5"
Width="642px" AutoGenerateDel eteButton="True " AutoGenerateEdi tButton="True"
AutoGenerateSel ectButton="True " DataSourceID="P ODetailDataSour ce">
<FooterStyle BackColor="#FFF FCC" ForeColor="#330 099" />
<Columns>
<asp:BoundFie ld DataField="Item ID" HeaderText="Ite m ID"
Visible="False" />
<asp:BoundFie ld DataField="POrd erId" HeaderText="PO Id"
Visible="False" />
<asp:BoundFie ld DataField="Page " HeaderText="Pag e">
<ItemStyle HorizontalAlign ="Right" />
</asp:BoundField>
<asp:BoundFie ld DataField="Cata logId" HeaderText="Cat alog #">
<ItemStyle HorizontalAlign ="Right" Width="80px" />
</asp:BoundField>
<asp:BoundFie ld DataField="Item Description"
HeaderText="Des cription">
<ItemStyle Width="250px" />
</asp:BoundField>
<asp:BoundFie ld DataField="Qty" HeaderText="Qty ">
<ItemStyle HorizontalAlign ="Right" />
</asp:BoundField>
<asp:BoundFie ld DataField="Unit Price"
DataFormatStrin g="{0:C}" HeaderText="Uni tPrice">
<ItemStyle HorizontalAlign ="Right" Width="70px" />
</asp:BoundField>
<asp:BoundFie ld DataFormatStrin g="{0:0.00}"
HeaderText="Tot al" InsertVisible=" False" />
</Columns>
<RowStyle BackColor="Whit e" ForeColor="#330 099" />
<SelectedRowSty le BackColor="#FFC C66" Font-Bold="True"
ForeColor="#663 399" />
<PagerStyle BackColor="#FFF FCC" ForeColor="#330 099"
HorizontalAlign ="Center" />
<HeaderStyle BackColor="#990 000" Font-Bold="True"
ForeColor="#FFF FCC" />
</asp:GridView>
And the datasource is as follows:
<asp:SqlDataSou rce ID="PODetailDat aSource" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:PODetailsCon nectionString %>"
SelectCommand=" admin_GetPODeta ils"
SelectCommandTy pe="StoredProce dure" DeleteCommand=" Admin_DeletePOI tem"
DeleteCommandTy pe="StoredProce dure" InsertCommand=" Admin_AddPOItem s"
InsertCommandTy pe="StoredProce dure" UpdateCommand=" Admin_UpdatePOI tem"
UpdateCommandTy pe="StoredProce dure">
<SelectParamete rs>
<asp:ControlPar ameter ControlID="cmbP ORequests"
Name="POrderId" PropertyName="S electedValue"
Type="Int32" />
</SelectParameter s>
<DeleteParamete rs>
<asp:Paramete r Name="ItemId" Type="Int32" />
</DeleteParameter s>
<UpdateParamete rs>
<asp:Paramete r Name="ItemID" Type="Int32" />
<asp:Paramete r Name="CatalogId " Type="String" />
<asp:Paramete r Name="ItemDescr iption" Type="String" />
<asp:Paramete r Name="Qty" Type="Int32" />
<asp:Paramete r Name="UnitPrice " Type="Decimal" />
<asp:Paramete r Name="Page" Type="String" />
</UpdateParameter s>
<InsertParamete rs>
<asp:Paramete r Name="POrderId" Type="Int32" />
<asp:Paramete r Name="CatalogeI d" Type="String" />
<asp:Paramete r Name="ItemDescr iption" Type="String" />
<asp:Paramete r Name="Qty" Type="Int32" />
<asp:Paramete r Name="UnitPrice " Type="Decimal" />
<asp:Paramete r Name="Page" Type="String" />
</InsertParameter s>
</asp:SqlDataSour ce>
The Stored proc is written as follows:
CREATE PROCEDURE [dbo].[Admin_UpdatePOI tem]
@ItemID int,
@CatalogId varchar(20),
@ItemDescriptio n varchar(250),
@Qty int,
@UnitPrice money,
@Page varchar(10)
AS
Update OrderItems Set
CatalogId = @CatalogId,
ItemDescription = @ItemDescriptio n,
Qty = @Qty,
UnitPrice = @UnitPrice,
Page = @Page
Where ItemID = @ItemID
GO
The research that I've done so far I have found that there is an extra
parameter, so I setup a function to remove the parameter but I still get the
error. Here is the code to delete.
'Serves to tell me what parameters and delete the extra one.
Protected Sub PODetailDataSou rce_Updating(By Val sender As Object, ByVal e As
System.Web.UI.W ebControls.SqlD ataSourceComman dEventArgs) Handles
PODetailDataSou rce.Updating
Dim param As DbParameter
Dim DeleteParam as DbParameter
Debug.WriteLine ("Starting Test")
Debug.WriteLine ("The command has " & e.Command.Param eters.Count.ToS tring
& " parameters altogether.")
For Each param In e.Command.Param eters
if param.Parameter Name.ToString = "@POrderId" then
DeleteParam = param
End If
if param.Parameter Name.ToString.L ength > 1 then
Debug.WriteLine ("parameter " & param.Parameter Name.ToString & "
=> " & (param.Value.To String & "") & "<br>")
end if
Next
if not isnothing(Delet eParam) then
e.Command.Param eters.Remove(De leteParam)
end if
Debug.WriteLine ("Starting Second Test")
Debug.WriteLine ("The command has " & e.Command.Param eters.Count.ToS tring
& " parameters altogether.")
For Each param In e.Command.Param eters
if param.Parameter Name.ToString = "@POrderId" then
DeleteParam = param
End If
if param.Parameter Name.ToString.L ength > 1 then
Debug.WriteLine ("parameter " & param.Parameter Name.ToString & "
=> " & (param.Value.To String & "") & "<br>")
end if
Next
End Sub
After the code is run (before deleting the parameter) I get the following
parameter:
The command has 8 parameters altogether.
parameter @CatalogId => 254-547<br>
parameter @ItemDescriptio n => Testing<br>
parameter @Qty => 5<br>
parameter @UnitPrice => 24.1500<br>
parameter @Page => 55<br>
parameter @ItemId => 3<br>
parameter @POrderId => 1<br> ****Param to remove *****
Starting Second Test
The command has 7 parameters altogether.
parameter @CatalogId => 254-547<br>
parameter @ItemDescriptio n => Testing<br>
parameter @Qty => 5<br>
parameter @UnitPrice => 24.1500<br>
parameter @Page => 55<br>
parameter @ItemId => 3<br>
Sorry for the long message, but I figured you may need to know this info.
What do you think. Thanks for the help.
Michael
