Click here to Skip to main content
15,923,015 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Plz hlp me..., Pin
sPaudel19-Jun-07 18:17
sPaudel19-Jun-07 18:17 
AnswerRe: Plz hlp me..., Pin
PrakashBhaskar19-Jun-07 18:18
PrakashBhaskar19-Jun-07 18:18 
GeneralRe: Plz hlp me..., Pin
Member 387988119-Jun-07 19:37
Member 387988119-Jun-07 19:37 
AnswerRe: Plz hlp me..., Pin
Reza Shojaee19-Jun-07 18:34
Reza Shojaee19-Jun-07 18:34 
AnswerRe: Plz hlp me..., Pin
Member 387988119-Jun-07 19:39
Member 387988119-Jun-07 19:39 
QuestionHaving difficulty deploying ASP.Net Pin
RDayalu19-Jun-07 15:23
RDayalu19-Jun-07 15:23 
AnswerRe: Having difficulty deploying ASP.Net Pin
Sathesh Sakthivel19-Jun-07 17:14
Sathesh Sakthivel19-Jun-07 17:14 
QuestionGet value Pin
seemamltn19-Jun-07 12:16
seemamltn19-Jun-07 12:16 
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["twcsanConnecti­onString"].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




seema

AnswerRe: Get value Pin
PrakashBhaskar19-Jun-07 18:10
PrakashBhaskar19-Jun-07 18:10 
QuestionRead cell phone # from SIM card programmatically Pin
Kuber K19-Jun-07 11:54
Kuber K19-Jun-07 11:54 
QuestionMembership vs MembershipProvider Pin
Brendan Vogt19-Jun-07 11:46
Brendan Vogt19-Jun-07 11:46 
QuestionTwo dimensional arraylist Pin
Hasan Ali19-Jun-07 11:38
Hasan Ali19-Jun-07 11:38 
AnswerRe: Two dimensional arraylist Pin
RepliCrux19-Jun-07 13:08
RepliCrux19-Jun-07 13:08 
QuestionAjax Post XMLHttpRequest take long time Pin
Immunity1819-Jun-07 11:30
Immunity1819-Jun-07 11:30 
Questionasp.net frequently called time consuming method Pin
AmrSaad8419-Jun-07 11:14
AmrSaad8419-Jun-07 11:14 
QuestionReturn value Pin
seemamltn19-Jun-07 8:06
seemamltn19-Jun-07 8:06 
AnswerRe: Return value Pin
RepliCrux19-Jun-07 10:35
RepliCrux19-Jun-07 10:35 
QuestionAny way to implement Gridview paging without postback? Pin
InvalidTypecast19-Jun-07 7:07
InvalidTypecast19-Jun-07 7:07 
AnswerRe: Any way to implement Gridview paging without postback? Pin
Not Active19-Jun-07 7:41
mentorNot Active19-Jun-07 7:41 
Questionneed to do customize installing shield to my web application Pin
AbdullahM19-Jun-07 7:06
AbdullahM19-Jun-07 7:06 
AnswerRe: need to do customize installing shield to my web application Pin
PrakashBhaskar19-Jun-07 18:28
PrakashBhaskar19-Jun-07 18:28 
QuestionRedirect from my contentpage Pin
anderslundsgard19-Jun-07 4:24
anderslundsgard19-Jun-07 4:24 
AnswerRe: Redirect from my contentpage Pin
badgrs19-Jun-07 4:53
badgrs19-Jun-07 4:53 
GeneralRe: Redirect from my contentpage Pin
anderslundsgard19-Jun-07 22:48
anderslundsgard19-Jun-07 22:48 
QuestionGeneral Term Needed Pin
Brendan Vogt19-Jun-07 4:06
Brendan Vogt19-Jun-07 4:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.