Click here to Skip to main content
15,909,829 members
Home / Discussions / C#
   

C#

 
GeneralRe: stack overflow Pin
hotthoughtguy11-May-09 7:12
hotthoughtguy11-May-09 7:12 
GeneralRe: stack overflow Pin
Luc Pattyn11-May-09 7:27
sitebuilderLuc Pattyn11-May-09 7:27 
GeneralRe: stack overflow Pin
hotthoughtguy11-May-09 7:40
hotthoughtguy11-May-09 7:40 
GeneralRe: stack overflow Pin
Luc Pattyn11-May-09 8:04
sitebuilderLuc Pattyn11-May-09 8:04 
GeneralRe: stack overflow Pin
hotthoughtguy11-May-09 8:08
hotthoughtguy11-May-09 8:08 
GeneralRe: stack overflow Pin
Dave Kreskowiak11-May-09 12:03
mveDave Kreskowiak11-May-09 12:03 
QuestionObtain value from a stored procedure Pin
Gresziu11-May-09 5:50
Gresziu11-May-09 5:50 
AnswerRe: Obtain value from a stored procedure Pin
Ian McCaul11-May-09 6:23
Ian McCaul11-May-09 6:23 
I believe the problem is that you are calling the reader outside of the scope of the readers command/connection objects. So inside of your method try this.

public void ExecuteStoreProcedure(string nombreProcedimiento,string parametro)
{
  using (SqlConnection connection = new SqlConnection(cadenaConexion))
  {
    using (SqlCommand command = new SqlCommand(nombreProcedimiento,connection))
    {
      connection.Open();
      //command.Connection = connection;
      command.CommandType = System.Data.CommandType.StoredProcedure;
      command.CommandText = nombreProcedimiento;
      command.CommandTimeout = 10;
      command.Parameters.AddWithValue("@parametroEntrada", parametro);
      reader = command.ExecuteReader();

      while (reader.Read())
      {
        articuloPermitido = reader.GetBoolean(0);
      }

    }
  }
}


Or you could have the method return the bool value from the reader.
GeneralRe: Obtain value from a stored procedure Pin
Gresziu11-May-09 21:23
Gresziu11-May-09 21:23 
Questionstudent information system Pin
dotnetdev8111-May-09 5:49
dotnetdev8111-May-09 5:49 
AnswerRe: student information system Pin
OriginalGriff11-May-09 5:54
mveOriginalGriff11-May-09 5:54 
GeneralRe: student information system Pin
dotnetdev8111-May-09 7:12
dotnetdev8111-May-09 7:12 
JokeRe: student information system Pin
OriginalGriff11-May-09 8:12
mveOriginalGriff11-May-09 8:12 
General[Message Deleted] Pin
dotnetdev8111-May-09 8:15
dotnetdev8111-May-09 8:15 
GeneralRe: student information system Pin
EliottA11-May-09 8:20
EliottA11-May-09 8:20 
GeneralRe: student information system Pin
harold aptroot11-May-09 6:04
harold aptroot11-May-09 6:04 
AnswerRe: student information system Pin
DaveyM6911-May-09 6:06
professionalDaveyM6911-May-09 6:06 
AnswerRe: student information system [modified] Pin
0x3c011-May-09 6:54
0x3c011-May-09 6:54 
QuestionHow can i know when my database done update values ? Pin
Yanshof11-May-09 5:38
Yanshof11-May-09 5:38 
QuestionHow to a Control to the NonClient area of Form in C#? Pin
CodeVarma11-May-09 5:03
CodeVarma11-May-09 5:03 
AnswerRe: How to a Control to the NonClient area of Form in C#? Pin
Dave Kreskowiak11-May-09 5:11
mveDave Kreskowiak11-May-09 5:11 
GeneralRe: How to a Control to the NonClient area of Form in C#? Pin
CodeVarma11-May-09 5:38
CodeVarma11-May-09 5:38 
GeneralRe: How to a Control to the NonClient area of Form in C#? Pin
Dave Kreskowiak11-May-09 6:59
mveDave Kreskowiak11-May-09 6:59 
QuestionHow to develop chat application without server for LAN? Pin
mitz11-May-09 4:06
mitz11-May-09 4:06 
AnswerRe: How to develop chat application without server for LAN? Pin
Henry Minute11-May-09 4:13
Henry Minute11-May-09 4:13 

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.