Databind from Stored Procedue

0.00/5 (No votes)

See more:

My Procedure is

SQL

[dbo].[usp_stdselect]
@RegNo int,@Name nchar(10),@Address nvarchar(50),@Status nchar(10)
as
begin
select RegNo,Name,Address,Status from dbo.std
eend

In this Procedure using C# How to Bind value, tell the C# Code to display the stored data

Posted 14-May-15 4:41am

Success Savada Muthu

Add a Solution

Comments

F-ES Sitecore 14-May-15 11:03am

google "call storedprocedure ado.net"

Andy Lanng 14-May-15 11:05am

Does your system use any query objects? ODBC? SQL Client? EF?
What have you tried? How are you connected to the database?

"Throw is a bone, here"

Success Savada Muthu 14-May-15 12:31pm

Iam using SQL Express 2008 connect with Connection String

ZurdoDev 14-May-15 14:30pm

1. Reply to comment so that the user is notified.
2. Bind how? There are millions of ways to show the data so you have to be clear on where you are stuck.

virusstorm 14-May-15 13:19pm

What do you want to bind the stored procedure to (i.e. DataTable, POCO, etc.)? How do you want to display it (i.e. DataGrid, DataRepeater, etc.)?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Pete O'Hanlon	115
OriginalGriff	85
Dave Kreskowiak	75
Andre Oosthuizen	45
Graeme_Grant	35

Pete O'Hanlon	1,790
OriginalGriff	1,315
Graeme_Grant	810
Richard Deeming	743
Dave Kreskowiak	634

Databind from Stored Procedue

Add your solution here

Preview 0

Databind from Stored Procedue

Add your solution here

Preview 0

Existing Members

...or Join us