public int validarUsuario(string usuario, string clave) { SqlCommand oCommand = new SqlCommand(); oCommand.CommandText = "prc_validarUsuario"; oCommand.CommandType = CommandType.StoredProcedure; oCommand.Parameters.Add("@usuario", SqlDbType.VarChar).Value = usuario; oCommand.Parameters.Add("@clave", SqlDbType.VarChar).Value = clave; Conexion conn = new Conexion(); DataTable table = new DataTable(); table = conn.EjecutarProcedureTable(oCommand); int estadoUsuario = Convert.ToInt32(table.Rows[0][0].ToString()); return(estadoUsuario); }