Stored Procedure Returning output of Another Stored Procedure

• yash.job

  Newbie

  Points: 5

  More actions

  June 13, 2014 at 3:46 pm

  #309148

  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 ..