Re: Get Value
- From: bruce barker <nospam@xxxxxxxxxx>
- Date: Tue, 19 Jun 2007 16:43:57 -0700
you want the proc return value, while you are trying to fetch the first column of the resultset. as your resultset is empty there is nothing to read, so you should use ExecuteNonQuery
add a parameter of ParameterDirection ReturnValue to the SqlCommand parameter list, then you can read its value after calling ExecuteNonQuery.
-- bruce (sqlwork.com)
bbawa1@xxxxxxxxx wrote:
Hi,.
I have following stored Procedure. I am writng following ado.net code
to get return value from stored procedure but it doesn't work.
String constr =
System.Configuration.ConfigurationManager.ConnectionStrings["twcsanConnectionString"].ConnectionString;
SqlConnection objConn = new SqlConnection(constr);
string sqlstmt = "usp_Update_tbtickets";
SqlCommand objCmd = new SqlCommand(sqlstmt, objConn);
objConn.Open();
//objCmd.ExecuteNonQuery();
SqlDataReader sqlDr;
sqlDr = objCmd.ExecuteReader();
while (sqlDr.Read())
{
Session["TCKid"] = Convert.ToInt32(sqlDr.GetValue(0));
}
sqlDr.Close();
objConn.Close();
CREATE PROCEDURE [twcsan].[usp_Update_tbtickets]
-- Add the parameters for the stored procedure here
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
DECLARE @id INT
SET NOCOUNT ON;
SET @id = (select top 1 ticketid from tbtickets where TcktStatusid
= 1)
update tbtickets
Set tcktopened = GetDate(), TcktAudited = GetDate(),TcktStatusid =
2
where ticketid = @id and TcktStatusid = 1
Return @id
END
- References:
- Get Value
- From: bbawa1
- Get Value
- Prev by Date: Re: FormView, ObjectDataSource and the evil binding
- Next by Date: Confirmation Responst
- Previous by thread: Re: Get Value
- Next by thread: WSAT, Access Rules, Folders not visible!
- Index(es):
Relevant Pages
|
