gridview fill with data which is not in table

Question

0.00/5 (No votes)

See more:

ALTER PROCEDURE dbo.select_data
	
AS

Declare @OutResult int

set @OutResult  ='50'

SELECT     [user_id], name1, address, mob, city, emailid
FROM         [user.] 

	RETURN

i have table : User
fields are:
Userid
name1
address
mob
city
emailid

i have taken gridview in which data is display according to this select query.
now i have to display OutResult with this exsisting data.OutResult is not in any table.

How to do this?

Posted 20-Feb-13 7:15am

Member 9511889

Updated 20-Feb-13 8:06am

v2

Add a Solution

2 solutions

Add a Solution

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

hinaiqbal · Answer 1 · 2013-02-20T07:49:00

Solution 1

use this to declare OutResult as this not in any table
Declare @OutResult int
set @OutResult='50';

but tell me where you have to store this value or just want to display this

Posted 20-Feb-13 7:49am

hinaiqbal

Comments

Member 9511889 20-Feb-13 14:00pm

i have to just display it in gridview.
you are right that i have to use Declare @OutResult int

hinaiqbal 12-Mar-15 14:42pm

accept the solution if it is helpful to you

hinaiqbal · Answer 2 · 2013-02-22T19:10:00

use this

SQL

ALTER PROCEDURE dbo.select_data

AS
Declare<pre lang="cs">@OutResult int
set @OutResult='50';
SELECT     [user_id],@OutResult as OutResult, name1, address, mob, city, emailid
FROM         [user.]

and where you are using your stored procedure using reader.HasRows retrive this and use this anywhere you want

gridview fill with data which is not in table

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

gridview fill with data which is not in table

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us