Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stored Procedure Returning output of Another Stored Procedure Expand / Collapse
Author
Message
Posted Friday, June 13, 2014 3:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 11:49 PM
Points: 2, Visits: 12


I have a login page which validate user Credential on Asp.net Website

SqlCommand sqlComm = new SqlCommand();
sqlComm.CommandType = System.Data.CommandType.StoredProcedure;
sqlComm.CommandText = "loginSp";


sqlComm.Parameters.Add("@userid", SqlDbType.VarChar, 50).Value = txtusrnm.Text;
sqlComm.Parameters.Add("@Password", SqlDbType.VarChar, 50).Value = txtpswd.Text;

sqlComm.Connection = new SqlConnection(conString);
SqlDataAdapter sa = new SqlDataAdapter(sqlComm);
DataSet ds = new System.Data.DataSet();
sa.Fill(ds);

ConnectionString :
<add key="connection" value="server=localhost;database=XXX;trusted_connection=yes;Min Pool Size=5;Max Pool Size=60;Connect Timeout=60"/>

The issue is that Sometime above Line of Code Return the Output of other Procedure instead of Calling "loginSp" Stored Procedure ... I wrote a log file in each and every step

here is the logFile

http://notepad.cc/hogauphi9

I don't know what is Wrong happening .. I m facing Error on Development Server only ..
Post #1580743
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse