Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
How to get output value from stored procedure?
February 22, 2010
How to get the output parameter value returned by stored procedure in asp.net?
I am using C# as my code language
Posted Date: February 22, 2010 Points: 5
show this link will get some information
Please Check my answer if you help....
Posted Date: February 23, 2010 Points: 5
think that ur sp returns a single value username
sqlcommand cmd=new sqlcommand("sp_name",con);
now the output of sp is available in string "str"
same use SqlDataAdapter if ur sp returns a table.
Posted Date: February 24, 2010 Points: 5
Just check the link you can get Idea
Posted Date: February 25, 2010 Points: 5
sqlconnection sqlconn=new sqlconnection("connectionstring");
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlconn;
cmd.CommandText = "exec proc_insertuserprofilecur '" + ImportpId + "'";
To post reply
Related Questions Related Questions
get value from output parameter from stored procedure
i got a problem on registration form using stored procedure and classes
Table name as parameter in SQL Stored Procedure
How do I call a Stored Procedure with one associative array as Out put Parameter ?
How to find the Recently accessed stored Procedure?
Where will the text of the stored procedure gets stored?
What is Precompiled in terms of Stored Procedure in Sql Server?
Difference between Stored Procedure and function in Sql Server
Can we have a Stored Procedure and a table with a same name? if not why?
How to pass dynamic dates to pivot query through stored procedure
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend