I have a gridview that displays a ORDER_ID in the first column and
then I add 2 button columns on the end of it to approve or deny the
order. If they approve it I want to update the database row's column
"status" with a 2 and if they deny the order then it will update that
column to 6. Im having trouble doing that with a AccessDataSourc e
control. Could someone help me figure it out. Here is what i have.
<asp:GridView ID="GridView1" runat="server"
AutoGenerateCol umns="False" DataKeyNames="O RDER_ID"
DataSourceID="M anagerQueue"
OnRowCommand="G ridView1_RowCom mand">
<Columns>
<asp:HyperLinkF ield DataTextField=" ORDER_ID"
HeaderText="ORD ER_ID" SortExpression= "ORDER_ID"
DataNavigateUrl Fields="ORDER_I D"
DataNavigateUrl FormatString="O rderDisplay.asp x?id={0}" />
<asp:ButtonFiel d ButtonType="But ton"
CommandName="Up dateApprove" Text="Approve Order" />
<asp:ButtonFiel d ButtonType="But ton"
CommandName="Up dateReject" Text="Reject Order" />
</Columns>
</asp:GridView>
</center>
<asp:AccessData Source ID="ManagerQueu e" runat="server" DataFile="~/
App_Data/ASPNetDB.mdb"
SelectCommand=" SELECT Order.ORDER_ID, Order.STATUS_ID FROM
[Order] WHERE Order.STATUS_ID =1;">
</asp:AccessDataS ource>
<asp:AccessData Source ID="ManagerQueu eUpdateApprove"
runat="server" DataFile="~/App_Data/ASPNetDB.mdb"
UpdateCommand=" UPDATE [Order] SET STATUS_ID = 2 WHERE ORDER_ID
= @ORDER_ID;">
</asp:AccessDataS ource>
<asp:AccessData Source ID="ManagerQueu eUpdateReject" runat="server"
DataFile="~/App_Data/ASPNetDB.mdb"
UpdateCommand=" UPDATE [Order] SET STATUS_ID = 6 WHERE ORDER_ID
= @ORDER_ID">
</asp:AccessDataS ource>
protected void GridView1_RowCo mmand(object sender,
GridViewCommand EventArgs e)
{
if (e.CommandName == "UpdateApprove" )
{
ManagerQueueUpd ateApprove.Upda te();
}
else if (e.CommandName == "UpdateReje ct")
{
ManagerQueueUpd ateReject.Updat e();
}
}
it tells me "No value given for one or more required parameters." when
it tries to do the update command with either one.
