DetailsView not binding to GridView with stored procedure

mike

I'm trying to display records in a DetailsView after I click on the record in the GridView. Everything works good if I don't use a stored procedure to populate the DetailsView, but if I try to use a SP in the DetailsView it won't display after clicking on the record in the GridView. For some reason it won't bind together with the Stored Procedure. I click on the GridView record and nothing happens. Could someone let me know what I'm doing wrong. Thanks

Both GridView & DetailsView have this: DataKeyNames="ShippingIdentity"

Stored Procedure:

SELECT ShippingIdentity,

OrigPortDoor,

OrigPortCode,

AirExport,

OrigCity,

OrigState,

OrigZip,

OrigCountry,

DestPortDoor,

DestCity,

DestState,

DestZip,

DestCountry,

ShippingLane

FROM ShippingInfo

RETURN

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
Hi
First create the SP and then use the below code to bind the Gridview with it
<asp:SqlDataSource
  ID="sds2"
  runat="server"
  ConnectionString="..."
  SelectCommand="spTest"
  SelectCommandType="StoredProcedure"
  >
  <SelectParameters>
    <asp:ControlParameter ControlID="TextBox1" PropertyName="Text"
                              Name="ParamName" Type="Int32" DefaultValue="0" />
  SelectParameters>
asp:SqlDataSource>
<asp:GridView ID="gv" runat="server" DataSourceID="sds2">asp:GridView>
For detail have a look of the link

http://www.asp.net/web-forms/overview/data-access/accessing-the-database-directly-from-an-aspnet-page/using-parameterized-queries-with-the-sqldatasource-vb
http://stackoverflow.com/questions/5326113/how-to-specify-parameter-value-for-stored-procedure-in-sqldatasource
http://stackoverflow.com/questions/12966722/running-a-stored-procedure-in-a-sqldatasource-on-button-click
0
Karthik Elumalai10y ago
Hi mike,
i think , in your code there is small problem only in creating the stored procedure.
Syntax for stored procedure:
Create Procedure Procedure-name ( Input parameters , Output Parameters (If required) ) As Begin Sql statement used in the stored procedure En
just cross check the below website surely it will solve your problem:
http://www.aspsnippets.com/Articles/SqlDataSource-StoredProcedure-example-Pass-parameters-to-StoredProcedure-using-SqlDataSource-in-ASPNet.aspx
Kindly let me know your thougths
Thanks
karthik
0