Hi, I have a stored procedure that I have to send one parameter to. I then have to use the same stored procedure to display results, I'm not sure how to do this. Basically the system should allow the user to select an item, push a button (which is when I have to send the username to the stored proc, at the same time I have to retrieve data from this stored proc and display it). Any help would be great, thank you.
coder91
0
Junior Poster
Recommended Answers
Jump to Postat the same time I have to retrieve data from this stored proc and display it
You need to be more specific regarding how you want to display the results. yssirhc's example shows display the results possibly to a gridview.
Maybe you want to build the HTML and …
Jump to PostHere is a very simple example i tested with a stored procedure and it works although there is no return value in my case so its slightly different than yours..
aspx
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
aspx.cs
protected void Page_Load(object sender, EventArgs e) { SqlConnection …
All 5 Replies
yssirhc
0
Light Poster
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
coder91
0
Junior Poster
JorgeM
958
Problem Solver
Team Colleague
Featured Poster
coder91
0
Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.