getting the error when passing the parameter in store procedur
<asp:GridView ID="grdOpen" runat="server" AutoGenerateColumns="false" CssClass="Grid"
DataKeyNames="transactionId" OnRowDataBound="OnRowDataBound" Height="284px"
Width="713px">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<img alt = "" style="cursor: pointer" src="../images/plus.png" />
<asp:Panel ID="pnlOrders" runat="server" Style="display: none">
<asp:GridView ID="grdOpendetails" runat="server" AutoGenerateColumns="false" CssClass = "ChildGrid">
<Columns>
<asp:BoundField ItemStyle-Width="150px" DataField="transactionId" HeaderText="Order Id" />
<asp:BoundField ItemStyle-Width="150px" DataField="Order Date" HeaderText="Date" />
<asp:BoundField ItemStyle-Width="150px" DataField="orderNumber" HeaderText="Order Id" />
<asp:BoundField ItemStyle-Width="150px" DataField="transaction_numbr" HeaderText="Date" />
</Columns>
</asp:GridView>
</asp:Panel>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField ItemStyle-Width="150px" DataField="transactionId" HeaderText="Order Id" />
<asp:BoundField ItemStyle-Width="150px" DataField="orderNumber" HeaderText="Contact Name" />
<asp:BoundField ItemStyle-Width="150px" DataField="transaction_numbr" HeaderText="City" />
</Columns>
</asp:GridView>
bind nested gridview and then command
passing for inside grid view
protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string customerId = grdOpen.DataKeys[e.Row.RowIndex].Value.ToString();
GridView gvOrders = e.Row.FindControl("grdOpendetails") as GridView;
objMain.transaction_Id =Convert.ToInt16(customerId);
DataSet ds = objMain.SelectOrderdev();
gvOrders.DataSource = ds;
gvOrders.DataBind();
}
}
and my sp code is
public DataSet SelectOrderdev()
{
SqlParameter[] parameter = new SqlParameter[1];
parameter[0] = new SqlParameter("@transactionId", transaction_Id);
DataSet dst = SQLDataAccess.ExecuteDataset(SQLDataAccess.ConnectionString, CommandType.StoredProcedure, "Sp_SelectOrderReportdev");
return dst;
}
getting the error
Procedure or function 'Sp_SelectOrderReportdev' expects parameter '@transactionId', which was not supplied.