Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
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: Tuesday, September 30, 2014 2:07 PM
Points: 3, Visits: 16

I have a login page which validate user Credential on 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();

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

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