Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Post
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Reply
DetailsView not binding to GridView with stored procedure
mike
8 years ago
294
Reply
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"
<asp:SqlDataSource ID="Shipping_DS" runat="server" ConnectionString="<%$ ConnectionStrings:NFIConnection %>" SelectCommand="GetShippingInfoDetailsView" SelectCommandType="StoredProcedure" >
<SelectParameters>
<asp:ControlParameter ControlID="ManageQuotesGridView" Name="ShippingIdentity" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
Stored Procedure:
SELECT ShippingIdentity,
OrigPortDoor,
OrigPortCode,
AirExport,
OrigCity,
OrigState,
OrigZip,
OrigCountry,
DestPortDoor,
DestCity,
DestState,
DestZip,
DestCountry,
ShippingLane
FROM ShippingInfo
RETURN
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Fire Timers Tick Event simultaneously c# windows application
Checking Last Shutdown Reason